alibaba / tsar2db Goto Github PK

used to store tsar data to mysql

C 83.10% Shell 10.23% Perl 6.67%

tsar2db's Introduction

tsar2db用来收集一个cdn节点内tsar的采集数据，存到mysql数据库，提供给其它应用查询
数据保留最近3个月的，各表字段含义和tsar采集定义相同
从mysql的tsar库中可以看到整个cdn节点tsar采集到的数据

配置tsar向tsar2db传送数据vi /etc/tsar/tsar.conf
output_nagios_addr console2:56677
将console2替换成tsar2db的hostname

tsar2db的编译依赖mysql-devel，运行依赖于httpd和mysql-server，其中httpd是用来提供cgi环境供查询
mysql可以下载：
mysql:http://vault.centos.org/5.3/updates/x86_64/RPMS/mysql-5.0.77-3.el5.x86_64.rpm
mysql-devel:http://vault.centos.org/5.3/updates/x86_64/RPMS/mysql-devel-5.0.77-3.el5.x86_64.rpm
mysql-server:http://vault.centos.org/5.3/updates/x86_64/RPMS/mysql-server-5.0.77-3.el5.x86_64.rpm

查询时通过cgi接口指定时间和模块，查看具体数据，比如：
[kongjian@console1 cdnlog]$ curl http://localhost:8082/query.cgi
Error:miss table name.
Table:load mem cpu tcp squid haproxy lvs switch traffic udp tcpx apache partition swap io pcsw 
Host:cache161.cn20 
Start/End:timestamp or stardtime, 1292472000 or 2010-12-16_12:00:00 
Sample as:query.cgi?table=load&start=1292472000&end=1292472060&host=mmdev2.corp.alimama.com

tsar2db's People

Contributors

Stargazers

Watchers

Forkers

ygliang2009 childebao 08opt no2key fyatao wangdongdong1989 twlkyao di3online microhuang linwaterbin copyofalibaba rzs840707 izhangleilei achun2080 ccvcd adomaxbd teamstudy leverly inuyasha1027 ljb-2000 hanwangkun wyx0578 tongtf popeye0807 zheng-hl poneyo zhangkaixuan kongjian baiyuzhixing skyformat99 cloudxtreme xty88645 james9191 wangfakang alibaba-boonya itbirds shineforever cnsuhao libingbing667 shanshuieast hanxueming126 hongjie7202 kal9il dingbb callmedba ftt1024 vkingi redyoung86 zhaisongfang lu-software-tools dbgche eailoo

tsar2db's Issues

用户名和密码都是对的，为什么会出现output_db.c:110 output_db write error:Connection refused？

[root@localhost cron.d]# tsar --cron
[Wed Dec 12 11:12:33 2018] output_db.c:110 output_db write error:Connection refused

开启采集以后，提示无法连接数据库。
tsar2db的配置如下：
[root@localhost cron.d]# cat /etc/tsar2db/tsar2db.cfg
#mysql database hostname or ip
db_address=localhost
#database port default is 3306
db_port=3306
#mysql user info for tsar
db_name=tsar
db_user=root
db_pw=11
#tsar2db port.same as output_nagios_addr at /etc/tsar/tsar.conf
server_port=56677
#log for tsar2db.see more@/var/log/message
debug=0
pid_file=/var/run/tsar2db.pid
配置中用户名和密码都是正确的。请问这是什么问题？或是哪里有详细的错误日志？

如何运行tsar2db？写的不是很详细呀

readme写的不是很详细呀，先做哪一步再做哪一步？怎么运行tsar_client, tsar_server

alibaba / tsar2db Goto Github PK

tsar2db's Introduction

tsar2db's People

Contributors

Stargazers

Watchers

Forkers

tsar2db's Issues

用户名和密码都是对的，为什么会出现output_db.c:110 output_db write error:Connection refused？

如何运行tsar2db？写的不是很详细呀

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent