2-6 監控MySQL · 運維工作筆記

#### 使用的Fpmmm模板監控MySQL 手冊地址：http://www.fromdual.com/fpmmm-installation-guide 下載地址：https://support.fromdual.com/admin/download/fpmmm-1.0.1.tar.gz ##### 配置 ```shell yum install php-cli php-process php-mysqli -y cat << _EOF >/etc/php.d/fpmmm.ini variables_order = "EGPCS" date.timezone = 'Asia/Shanghai' _EOF ``` ##### 安裝zabbix客戶端 ```shell #fpmmm依賴zabbix-sender yum install zabbix-agent zabbix-sender ``` ##### 下載并上傳fpmmm文件到/opt目錄下 ```shell cd /opt tar xzf /opt/fpmmm-1.0.1.tar.gz mv fpmmm-1.0.1 /app/ chown -R root.root /app/fpmmm-1.0.1 cd /app &&ln -s fpmmm-1.0.1 fpmmm ``` ##### 配置fpmmm ```shell mkdir /etc/fpmmm cp /app/fpmmm/tpl/fpmmm.conf.template /etc/fpmmm/fpmmm.conf chown -R zabbix: /etc/fpmmm ``` ##### 增加本地授權（收集數據） ```shell CREATE USER 'fpmmm_agent'@'127.0.0.1' IDENTIFIED BY 'secret'; GRANT SELECT, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'fpmmm_agent'@'127.0.0.1'; ``` **生產請使用強密碼！** ##### fpmmm配置文件模板修改以下內容 ```shell [self] Interval = 60 PidFile = /var/run/fpmmm/fpmmm.pid [default] LogLevel = 2 LogFile = /var/log/fpmmm/fpmmm.log CacheFileBase = /var/cache/fpmmm/fpmmm AgentLockFile = /var/run/fpmmm/fpmmm.lock Username = fpmmm_agent Password = secret MysqlHost = 127.0.0.1 MysqlPort = 3306 ZabbixServer = 192.168.2.30 Disabled = false Modules = innodb master myisam mysql process security PidFile = /data/mysql3306/mon02-s01.prod.ding.pid [mdb01-s1.test.ding] # This MUST match Hostname in Zabbix! Type = host Modules = fpmmm server [mdb01-s1-3306] # This MUST match Hostname in Zabbix! Type = mysqld MysqlPort = 3306 Modules = process mysql myisam innodb master slave security PidFile = /data/mysql3306/mon02-s01.prod.ding.pid ``` 備注1：[mdb01-s1.test.ding]要和zabbix中的Host name中的定義要一致 [mdb01-s1-3306]是自定義的名字，在Zabbix的host中也要添加，綁定模板不同備注2：數據庫監控不要添加fpmmm和server監控，如果添加，其他監控項將**不收集！！！** ##### 這里栽了很大的坑，沒有認真的看官方文檔，fpmmm server但單獨收集的，我不需要，所以就注釋了。 ##### 還是多說一句吧，官方文檔說的是，Zabbix建立兩個主機，一個服務器主機，綁定fpmmm和server監控性能和版本，另一個MySQL主機（虛擬的，和配置里一個名字），綁定其他MySQL模板。 #### 測試 ```shell /app/fpmmm/bin/fpmmm --config=/etc/fpmmm/fpmmm.conf 1 ``` 查看日志 ```shell tail -f /var/log/fpmmm/fpmmm.log ``` ```shell 31489:2017-07-21 11:50:43.857 - INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (1.0.1) run started. 31489:2017-07-21 11:50:43.912 - WARN: Please install program /usr/bin/numactl. (rc=1534). 31489:2017-07-21 11:50:43.912 - WARN: sudo apt-get install numactl 31489:2017-07-21 11:50:43.912 - WARN: sudo yum install numactl 31489:2017-07-21 11:50:44.917 - WARN: Please install program /usr/bin/numactl. (rc=1534). 31489:2017-07-21 11:50:44.917 - WARN: sudo apt-get install numactl 31489:2017-07-21 11:50:44.917 - WARN: sudo yum install numactl 31489:2017-07-21 11:50:46.305 - WARN: Instance mdb01-s1-3306 seems not to be a Slave. (rc=1577). 31489:2017-07-21 11:50:46.405 - INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc=0). ``` ##### 導入所有模板 ##### Zabbix添加主機 ```shell [mdb01-s1.test.ding] 模板：fpmmm server [mdb01-s1-3306] 模板：innodb master myisam mysql process security ``` ##### 配置數據發送方式 ```shell REGULARLY RUNNING THE FPMMM AGENT There are 2 different possibilities to run fpmmm regularly. First by the Zabbix agent: Put the following line either into its own file (/etc/zabbix/conf.d/fpmmm.conf) or add it to the Zabbix agent configuartion file (/etc/zabbix/zabbix_agentd.conf). UserParameter=FromDual.MySQL.check,/app/fpmmm/bin/fpmmm --config=/etc/fpmmm/fpmmm.conf or second by the crontab: * * * * * /app/fpmmm/bin/fpmmm --config=/etc/fpmmm/fpmmm.conf >/dev/null ```