Zabbix Server 自带模板监控无密码MySQL数据库
作者：尹正杰
版权声明：原创作品，谢绝转载！否则将追究法律责任。
一.安装MariaDB
1>.安装MariaDB
[root@node102 ~]# yum -y install mariadb-serverLoaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: mirrors.163.com * extras: mirrors.aliyun.com * updates: mirrors.163.comResolving Dependencies--> Running transaction check---> Package mariadb-server.x86_64 1:5.5.60-1.el7_5 will be installed--> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Processing Dependency: libaio.so.1()(64bit) for package: 1:mariadb-server-5.5.60-1.el7_5.x86_64--> Running transaction check---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed--> Running transaction check---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch--> Running transaction check---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed--> Running transaction check---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved=========================================================================================================================================================================================== Package Arch Version Repository Size===========================================================================================================================================================================================Installing: mariadb-server x86_64 1:5.5.60-1.el7_5 base 11 MInstalling for dependencies: libaio x86_64 0.3.109-13.el7 base 24 k perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBD-MySQL x86_64 4.023-6.el7 base 140 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-Data-Dumper x86_64 2.145-3.el7 base 47 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PlRPC noarch 0.2020-14.el7 base 36 kTransaction Summary===========================================================================================================================================================================================Install 1 Package (+9 Dependent packages)Total download size: 12 MInstalled size: 62 MDownloading packages:(1/10): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00 (2/10): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00 (3/10): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 (4/10): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 (5/10): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 (6/10): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (7/10): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 (8/10): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm | 140 kB 00:00:00 (9/10): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 (10/10): mariadb-server-5.5.60-1.el7_5.x86_64.rpm | 11 MB 00:00:07 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total 1.7 MB/s | 12 MB 00:00:07 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : perl-Data-Dumper-2.145-3.el7.x86_64 1/10 Installing : libaio-0.3.109-13.el7.x86_64 2/10 Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 3/10 Installing : perl-Net-Daemon-0.48-5.el7.noarch 4/10 Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 5/10 Installing : perl-IO-Compress-2.061-2.el7.noarch 6/10 Installing : perl-PlRPC-0.2020-14.el7.noarch 7/10 Installing : perl-DBI-1.627-4.el7.x86_64 8/10 Installing : perl-DBD-MySQL-4.023-6.el7.x86_64 9/10 Installing : 1:mariadb-server-5.5.60-1.el7_5.x86_64 10/10 Verifying : 1:mariadb-server-5.5.60-1.el7_5.x86_64 1/10 Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 2/10 Verifying : perl-Net-Daemon-0.48-5.el7.noarch 3/10 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 4/10 Verifying : perl-DBD-MySQL-4.023-6.el7.x86_64 5/10 Verifying : perl-IO-Compress-2.061-2.el7.noarch 6/10 Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 7/10 Verifying : perl-DBI-1.627-4.el7.x86_64 8/10 Verifying : libaio-0.3.109-13.el7.x86_64 9/10 Verifying : perl-PlRPC-0.2020-14.el7.noarch 10/10 Installed: mariadb-server.x86_64 1:5.5.60-1.el7_5 Dependency Installed: libaio.x86_64 0:0.3.109-13.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-6.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 Complete![root@node102 ~]#
2>.启动MariaDB
[root@node102 ~]# systemctl status mariadb● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: inactive (dead)[root@node102 ~]# [root@node102 ~]# systemctl start mariadb[root@node102 ~]# [root@node102 ~]# [root@node102 ~]# systemctl enable mariadbCreated symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.[root@node102 ~]# [root@node102 ~]# [root@node102 ~]# systemctl status mariadb● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: active (running) since Tue 2019-02-19 08:01:16 PST; 7s ago Main PID: 3860 (mysqld_safe) CGroup: /system.slice/mariadb.service ├─3860 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─4022 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/...Feb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: MySQL manual for more instructions.Feb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: Please report any problems at http://mariadb.org/jiraFeb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: The latest information about MariaDB is available at http://mariadb.org/.Feb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: You can find additional information about the MySQL part at:Feb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: http://dev.mysql.comFeb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: Consider joining MariaDB's strong and vibrant community:Feb 19 08:01:14 node102.yinzhengjie.org.cn mariadb-prepare-db-dir[3782]: https://mariadb.org/get-involved/Feb 19 08:01:14 node102.yinzhengjie.org.cn mysqld_safe[3860]: 190219 08:01:14 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.Feb 19 08:01:14 node102.yinzhengjie.org.cn mysqld_safe[3860]: 190219 08:01:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysqlFeb 19 08:01:16 node102.yinzhengjie.org.cn systemd[1]: Started MariaDB database server.[root@node102 ~]# [root@node102 ~]#
二.Zabbix Server 配置监控无密码的MariaDB数据库
1>.创建主机
2>.配置host界面
3>.配置zabbix监控数据库的模板
4>.主机添加完成
5>.如下图所示，zabbix默认有14个监控项
6>.查看监控MySQL的图形
