zabbix monitor mysql
来源:互联网 发布:决战武林宠物进阶数据 编辑:程序博客网 时间:2024/05/01 23:18
1、grant user for mysql
GRANTUSAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY "zabbix";
2、touch /var/lib/zabbix/.my.cnf
# Zabbix Agent
[mysql]
host=localhost
user=zabbix
password=zabbix
socket=/tmp/mysql.sock
[mysqladmin]
host=localhost
user=zabbix
password=zabbix
socket=/tmp/mysql.sock
3、cp userparameter_mysql.conf/etc/zabbix/zabbix_agentd.d/
HOME=/var/lib/zabbix #where store mysql grant user info ,after itmysql is mysql command full path
4、vim /etc/zabbix/zabbix_agentd.com
Include=/etc/zabbix/zabbix_agentd.d/
5、/etc/init.d/zabbix_agentd restart
6、zabbix_get -s 127.0.0.1 -k mysql.status[Com_begin]
7、Apply Template App MySQL
本文出自 “ThunderMeng” 博客,请务必保留此出处http://thundermeng.blog.51cto.com/9414441/1608322
- zabbix monitor mysql
- mysql监控工具:zabbix+MPM(Performance Monitor for MySQL)
- Zabbix Server和MPM(monitor for mysql)的快速部署
- zabbix 部署110 monitor
- 借助zabbix和mysql performance monitor模板实现mysql数据库的监控
- zabbix自带database monitor
- MySQL replication monitor
- MySQL Enterprise Monitor安装
- 安装MySQL Enterprise Monitor
- zabbix全面监控mysql
- zabbix mysql 迁移总结
- MySQL监控软件zabbix
- Zabbix 2.4 监控 MySQL
- zabbix 监控 mysql
- ZABBIX监控MYSQL
- zabbix监控mysql客户端
- zabbix监控mysql
- 用zabbix监控mysql
- LVS+Keepalived实现四层负载及高可用
- CentOS启动卡在开机进度条certmonger后
- Fabric自动化运维工具实现远程SSH部署及系统管理
- A10负载配置及主备手动切换命令
- Nginx实现TCP反向代理
- zabbix monitor mysql
- A Lightened CNN for Deep Face Representation
- Windows Server 2003 使用vSphere5.5连接ESXI5.5 “客户端无法向服务器发送完整的请求” 的解决办法
- Shanghai
- zabbix 编译安装
- Hadoop HA
- FastDFS+Nginx安装配置
- FastDFS配置和运行中出现的问题及解决(FAQ)
- MySQL之truncate表后恢复思路整理(前提是有备份且开启binlog)