TokuDB是一个支持事务的“新”引擎,有出色的数据压缩功能,如果数据写多读少,而且数据量比较大,建议使用TokuDB,节省空间成本,大幅降低存储使用量和IOPS开销,不过会相应增加CPU压力。
安装percona mysql 5.7
#yum安装
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm](http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
yum install Percona-Server-server-57
安装percona之后,随机密码在/var/log/mysqld.log中
cat /var/log/mysqld.log | grep "A temporary password" | awk -F " " '{print$11}'
#登录之后重新修改密码
ALTER USER root@localhost IDENTIFIED BY 'YourPassword';
#设置密码策略为0
set global validate_password_policy = 0;
#设置/etc/my.cnf,增加
[mysqld_safe]
malloc-lib= /path/to/jemalloc
安装tokudb
#安装之前要安装jemalloc
yum install -y jemalloc
yum install Percona-Server-tokudb-57.x86_64
ps_tokudb_admin --enable -uroot -p
检查
show engines;
| TokuDB | YES | Percona TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES |
show plugins;
| TokuDB | ACTIVE | STORAGE ENGINE | ha_tokudb.so | GPL |
| TokuDB_file_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_info | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_block_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_trx | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_locks | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_lock_waits | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_background_job_status | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
#查看版本
mysql> SELECT @@tokudb_version;
+------------------+
| @@tokudb_version |
+------------------+
| 5.7.18-15 |
+------------------+
1 row in set (0.00 sec)