查看“Zabbix监控mysql”的源代码

=1.Install Zabbix agent and MySQL client =
 * 1. Install Zabbix agent and MySQL client. If necessary, add the path to   
 the mysql and mysqladmin utilities to the global environment variable PATH. 
 
==centos7 yum install mysql5.7 ==      

[[CentOS7 yum安装MySQL5.7]] 
<pre>
密码查看 
  grep "password" /var/log/mysqld.log                                        
                                                                             
 2021-10-22T02:11:26.214298Z 1 [Note] A temporary password is generated for  
 root@localhost: 71p=K-p-mVur   
</pre>

=2  Copy template_db_mysql.conf =
Copy template_db_mysql.conf into the folder with Zabbix agent          
 configuration (/etc/zabbix/zabbix_agentd.d/ by default). Don't forget to    
 restart Zabbix agent.  

<pre>#或者去网上找也差不多 
 cp  /usr/share/doc/zabbix-agent-5.0.18/userparameter_mysql.conf /etc/zabbix/zabbix_agentd.d/

 cp  /usr/share/doc/zabbix-agent-4.4.10/userparameter_mysql.conf   /etc/zabbix/zabbix_agentd.d/   
</pre>

=3.   Create a MySQL user for monitoring (<password> at yourdiscretion)=
<pre>
 CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';                   
 GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO         
 'zbx_monitor'@'%'; 
</pre>
=4. Create .my.cnf in the home directory of Zabbix agent for Linux(/var/lib/zabbix by default ) =
<pre>
 mkdir -p /var/lib/zabbix                                                    
 chown -R  zabbix:zabbix /var/lib/zabbix                                     
                                                                             
                                                                             
 vi /var/lib/zabbix/.my.cnf                                                  
 [client]                                                                    
 user='zbx_monitor'                                                          
 password='<password>' 
</pre>


上次居然看不懂官方的 ,看来英文近来是提升了一点点呀 


注意 

    使用Zabbix自带模板监控MySQL时，Zabbix Server编译时需要使用“--with-libxml2”加入“libxml2”库。如果没有，需要重新编译Zabbix Server并重启。在CentOS中，可以通过“yum -y install libxml2 libxml2-devel”安装“libxml2”库。
    通过Zabbix源码目录中的“config.log”文件查看编译选项：


# cat /usr/local/src/zabbix-5.0.10/config.log | grep '^.*configure.*--prefix'

=Zabbix 监控Mysql 主从=
qk 他们是监控了很多选项的 而我没空搞这么多
=参考=

[https://www.zabbix.com/cn/integrations/mysql#mysql_agent mysql monitoring  zabbix.com]

[https://blog.csdn.net/zhen1819/article/details/116058706  Zabbix5.0 监控MySQL]

https://www.zabbix.com/documentation/current/manual/config/templates_out_of_the_box/zabbix_agent

[http://blog.sctux.com/?p=396 zabbix 监控mysql状态以及mysql主从]


[https://blog.csdn.net/qq_45939993/article/details/116853593  Zabbix自动化监控——监控MySQL]

[ ]

[https://www.codeleading.com/article/941015593/  zabbix自定义key监控mysql ]

[http://lihuipeng.blog.51cto.com/3064864/1081562  Zabbix 监控Mysql 主从状态（Python脚本]

[http://www.cnblogs.com/metasequoia/p/5832364.html Zabbix监控mysql主从复制状态]

 [[category:zabbix]]  [[category:mysql]]