011-通过安装percona插件监控MySQL

客户端安装percona插件

若下载失败可到文末底部GitHub链接下载再安装

<code class="hljs awk">rpm -ivh https:<span class="hljs-regexp">//www.percona.com<span class="hljs-regexp">/downloads/percona-monitoring-plugins<span class="hljs-regexp">/percona-monitoring-plugins-1.1.8/binary<span class="hljs-regexp">/redhat/<span class="hljs-number">7<span class="hljs-regexp">/x86_64/percona-zabbix-templates-<span class="hljs-number">1.1.<span class="hljs-number">8-<span class="hljs-number">1.noarch.rpm</span></span></span></span></span></span></span></span></span></code>

查看安装后的文件

当装完percona插件之后，默认在/var/lib/zabbix/下会生成percona目录，查看如下

<code class="hljs perl">[root@gzyk201808 ~]<span class="hljs-comment"># cd /var/lib/zabbix/
[root@gzyk201808 zabbix]<span class="hljs-comment"># ll
总用量 <span class="hljs-number">0
drwxr-xr-<span class="hljs-keyword">x <span class="hljs-number">4 root root <span class="hljs-number">38 <span class="hljs-number">3月  <span class="hljs-number">16 <span class="hljs-number">16:<span class="hljs-number">49 percona
[root@gzyk201808 zabbix]<span class="hljs-comment"># tree percona/
percona/
├── scripts
│   ├── get_mysql_stats_wrapper.sh
│   └── ss_get_mysql_stats.php
└── templates
    ├── userparameter_percona_mysql.conf
    └── zabbix_agent_template_percona_mysql_server_ht_2.<span class="hljs-number">0.<span class="hljs-number">9-sver1.<span class="hljs-number">1.8.xml
<span class="hljs-number">2 directories, <span class="hljs-number">4 files</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

复制模板文件到zabbix客户端目录

<code class="hljs groovy">cp <span class="hljs-regexp">/var/lib<span class="hljs-regexp">/zabbix/percona<span class="hljs-regexp">/templates/userparameter_percona_mysql.conf <span class="hljs-regexp">/etc/zabbix<span class="hljs-regexp">/zabbix_agentd.d/</span></span></span></span></span></code>

客户端数据库添加zabbix账号

<code class="hljs nginx"><span class="hljs-comment"># 安装时已完成，可略过
<span class="hljs-attribute">grant all privileges <span class="hljs-literal">on *.* to zabbix<span class="hljs-variable">@localhost identified by <span class="hljs-string">"Zabbix@123";</span></span></span></span></span></code>

修改ss_get_mysql_stats.php文件

<code class="hljs shell">[root@gzyk201808 zabbix]# vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
<span class="hljs-meta">#<span class="bash"> 依据mysql安装和数据库情况编辑
<span class="hljs-meta">$<span class="bash">mysql_user = <span class="hljs-string">‘zabbix‘;
<span class="hljs-meta">$<span class="bash">mysql_pass = <span class="hljs-string">‘Zabbix@123‘;
<span class="hljs-meta">$<span class="bash">mysql_port = 3306;
<span class="hljs-meta">#<span class="bash"> 根据mysql安装配置修改
<span class="hljs-meta">$<span class="bash">mysql_socket = NUll;</span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

修改get_mysql_stats_wrapper.sh脚本

<code class="hljs groovy">chmod +x <span class="hljs-regexp">/var/lib<span class="hljs-regexp">/zabbix/percona<span class="hljs-regexp">/scripts/get_mysql_stats_wrapper.sh</span></span></span></code>

重启客户端并测试连通性

<code class="hljs shell">systemctl restart zabbix-agent
<span class="hljs-meta">#<span class="bash"> 先检查是否存在 /tmp/localhost-mysql_cacti_stats.txt 文件，若不存在执行以下语句会生成该文件，默认存在该文件
/usr/bin/php -q /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php --host localhost --items gg
<span class="hljs-meta">#<span class="bash"> 在Agent节点上配置和验证与127.0.0.1的MySQL连接，返回任何数字则表式连接成功
/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg</span></span></span></span></code>

修改客户端mysql配置文件 /etc/my.cnf ，添加如下并重启客户端数据库

测试脚本，执行未报错且输出为0或1则表明测试通过

<code class="hljs">sudo -u zabbix -H /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave</code>

配置权限

<code class="hljs groovy">chown -R zabbix.zabbix <span class="hljs-regexp">/tmp/localhost-mysql_cacti_stats.txt
chmod <span class="hljs-number">755 <span class="hljs-regexp">/tmp/localhost-mysql_cacti_stats.txt</span></span></span></code>

服务端测试获取数据

<code class="hljs css"><span class="hljs-selector-tag">zabbix_get <span class="hljs-selector-tag">-s 192<span class="hljs-selector-class">.168<span class="hljs-selector-class">.181<span class="hljs-selector-class">.136 <span class="hljs-selector-tag">-p10050 <span class="hljs-selector-tag">-k "<span class="hljs-selector-tag">MySQL<span class="hljs-selector-class">.Threads-connected"</span></span></span></span></span></span></span></span></span></code>

添加percona插件MySQL模板

配置-模板-导入模板，这里提供完整模板，地址，自行选择模板类型，导入模板之后，选择相应的主机添加模板即可

011-通过安装percona插件监控MySQL

标签：str   特性   rip   ble   connect   数字   行数据   connected   moni