安裝perconna源
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm
安裝依賴
yum install epel-release -y
yum install jemalloc -y
++++++++++++++++++++++++++++++++++++++
TokuDB storage engine requires libjemalloc library 3.3.0 or greater. If the version in the distribution repository is lower than that you can use one from Percona Software Repositories or download it from somewhere else.
If the libjemalloc wasn’t installed and enabled before it will be automatically installed when installing the TokuDB storage engine package by using the apt` or yum package manager, but Percona Server instance should be restarted for libjemalloc to be loaded. This way libjemalloc will be loaded with LD_PRELOAD. You can also enable libjemalloc by specifying malloc-lib variable in the [mysqld_safe] section of the my.cnf file:
[mysqld_safe]
malloc-lib= /path/to/jemalloc
+++++++++++++++++++++++++++++++++++++++
關(guān)閉大頁內(nèi)存
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
+++++++++++++++++++++++++++++++++++
TokuDB won’t be able to start if the transparent huge pages are enabled. Transparent huge pages is feature available in the newer kernel versions. You can check if the Transparent huge pages are enabled with:
$ cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
If transparent huge pages are enabled and you try to start the TokuDB engine you’ll get the following message in you error.log:
Transparent huge pages are enabled, according to /sys/kernel/mm/redhat_transparent_hugepage/enabled
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled
You can disable transparent huge pages permanently by passing transparent_hugepage=never to the kernel in your bootloader (NOTE: For this change to take an effect you’ll need to reboot your server).
You can disable the transparent huge pages by running the following command as root (NOTE: Setting this will last only until the server is rebooted):
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag
++++++++++++++++++++++++++++++++++++++++
安裝percona數(shù)據(jù)庫及tokudb插件
yum install Percona-Server-tokudb-57.x86_64
啟動mysql
systemctl start mysqld
登錄并更改密碼和過期策略
登錄：
mysql -u root -p
,c!)fa/Cd9kD
更改密碼及過期策略：
SET PASSWORD = PASSWORD('Qwe_1234');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
配置root用戶遠(yuǎn)程登錄（只是為了測試，不代表生產(chǎn)操作）
grant all privileges on *.* to root@"%" identified by "Qwe_1234";
測試本地登錄與遠(yuǎn)程登錄(我數(shù)據(jù)庫IP為10.0.0.12)
mysql -uroot -pQwe_1234
mysql -uroot -pQwe_1234 -h 10.0.0.12 -P3306
加載插件
ps_tokudb_admin --enable -uroot -pPassw0rd
INSTALL PLUGIN tokudb SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_file_map SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_fractal_tree_info SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_fractal_tree_block_map SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_trx SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_locks SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_lock_waits SONAME 'ha_tokudb.so';
INSTALL PLUGIN tokudb_background_job_status SONAME 'ha_tokudb.so';
show engines;
show plungins;
SELECT @@tokudb_version;
添加zabbix用戶
grant all on zabbix.* to zabbix@'localhost' identified by 'Zabbix_pass123';
創(chuàng)建數(shù)據(jù)庫：
create database zabbix charset utf8;
zabbix安裝
[root@oldboy ~]# vim /etc/yum.repos.d/zabbix.repo
[root@oldboy ~]# cat /etc/yum.repos.d/zabbix.repo
[zabbix]
name=Zabbix Official Repository - $basearch
baseurl=https://mirrors.tuna.tsinghua.edu.cn/zabbix/zabbix/3.0/rhel/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX
[zabbix-non-supported]
name=Zabbix Official Repository non-supported - $basearch
baseurl=https://mirrors.tuna.tsinghua.edu.cn/zabbix/non-supported/rhel/7/$basearch/
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX
gpgcheck=0
[root@oldboy ~]#
yum install -y zabbix-server-mysql zabbix-web-mysql zabbix-agent
修改配置文件
[root@oldboy zabbix]# vim zabbix_server.conf
DBPassword=Zabbix_pass123
vim /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Shanghai
導(dǎo)入zabbix數(shù)據(jù)庫
[root@oldboy conf.d]# rpm -ql zabbix-server-mysql
/etc/logrotate.d/zabbix-server
/etc/zabbix/zabbix_server.conf
/usr/lib/systemd/system/zabbix-server.service
/usr/lib/tmpfiles.d/zabbix-server.conf
/usr/lib/zabbix/alertscripts
/usr/lib/zabbix/externalscripts
/usr/sbin/zabbix_server_mysql
/usr/share/doc/zabbix-server-mysql-3.0.21
/usr/share/doc/zabbix-server-mysql-3.0.21/AUTHORS
/usr/share/doc/zabbix-server-mysql-3.0.21/COPYING
/usr/share/doc/zabbix-server-mysql-3.0.21/ChangeLog
/usr/share/doc/zabbix-server-mysql-3.0.21/NEWS
/usr/share/doc/zabbix-server-mysql-3.0.21/README
/usr/share/doc/zabbix-server-mysql-3.0.21/create.sql.gz
/usr/share/man/man8/zabbix_server.8.gz
/var/log/zabbix
/var/run/zabbix
[root@oldboy conf.d]#
[root@oldboy conf.d]# cd /usr/share/doc/zabbix-server-mysql-3.0.21/
[root@oldboy zabbix-server-mysql-3.0.21]# gunzip create.sql.gz
注意：如果使用tokudb，需要將sql腳本中的InnoDB替換為tokudb
mysql -uroot -pQwe_1234
重啟zabbix相關(guān)服務(wù)
[root@oldboy ~]# systemctl restart zabbix-server
[root@oldboy ~]# systemctl restart zabbix-agent
[root@oldboy ~]# systemctl restart httpd
web登錄配置zabbix（略）
安裝percona監(jiān)控模板rpm包
注意：修改采集腳本用戶密碼
/var/lib/zabbix/percona/scripts
vim get_mysql_stats_wrapper.sh
RES=`HOME=~zabbix mysql -u root -pQwe_1234
vim ss_get_mysql_stats.php
#
$mysql_user = 'root';
$mysql_pass = 'Qwe_1234';
命令行測試監(jiān)控項
yum install zabbix-get.x86_64 -y
systemctl restart zabbix-agent.service
cat /etc/zabbix/zabbix_agentd.d/userparameter_percona_mysql.conf
zabbix_get -s 127.0.0.1 -k MySQL.Open-files
