通过zabbix监控galera Cluster:
下载网址: http://share.zabbix.com/databases/mysql/galera-cluster-monitoring
里面的userparameter_galera.conf是给Cluster用的,App-Galera_Cluster.xml是要导入到zabbix server模板里的
Cluster node:
cp userparameter_galera.conf /etc/zabbix/zabbix_agentd.d/
mkdir /var/lib/zabbix
vi /var/lib/zabbix/.my.cnf
[mysql]
host=localhost
user=zabbix
password=xxxxx
:wq
mysql -u root -p'xxxx'
grant select on . to zabbix@'localhost' identified by 'xxxx'; flush privileges; quit
vi /etc/my.cnf (如果是mysql 5.7需要开启下面参数)
show_compatibility_56=on
:wq
systemctl restart mysqld
systemctl restart zabbix-agent
验证:
zabbix_agentd -t "galera.cluster_status"
zabbix_agentd -t "galera.cluster_size" (会显示Cluster的node数)
zabbix server:
将App-Galera_Cluster.xml导入到模板,然后将Cluster node加到对应模板