ansible-mysql

ansible mysql -m command -a "yum -y install https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpm"     #安装mysql第三方插件

 

ansible mysql -m lineinfile -a "dest=/etc/zabbix/chk_mysql.sh regexp='MYSQL_PWD=123456' state=absent"                                 #删除MYSQL_PWD=123456的一行

 

ansible mysql -m lineinfile -a "dest=/etc/zabbix/chk_mysql.sh regexp='MYSQL_PWD=zabbix' line='MYSQL_PWD='123456''"         #更改MYSQL_PWD=zabbix成MYSQL_PWD='123456'

 

ansible mysql -m command -a "cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/"         #拷贝监控模板