编写的脚本用来监控mysql主从模式 环境: Centos5.6 mysql只做同步指定库,没有同步mysql库用户数据 登陆从服务器mysql,添加验证的用户 grant replication client on *.* to 'nagios'@localhost identified by '123456'; flush privileges; 查看是否添加成功 select user,host from mysql.user 在从服务器安装 nrpe,然后在
nagios监控mysql服务器: 1、建立专用数据库: [root@svr3 ~]# /usr/local/webserver/mysql/bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 51910 Server version: 5.5.3-m3-log Source distribution T