alibaba / Tsar2db

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接口指定时间和模块，查看具体数据，比如： [[email protected] 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