阿里云RDS迁移，极简安装 MySQL TokuDB 引擎( 二 ) _阿里云

If the script returns no errors, TokuDB storage engine should be successfully enabled on your server. You can check it out by running:
mysql> SHOW ENGINES;... | TokuDB | YES | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES |...To check if all the TokuDB plugins have been installed correctly you should run:
mysql> 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|...TokuDB storage engine version can be checked with:
mysql> SELECT @@tokudb_version;+------------------+| @@tokudb_version |+------------------+| 5.6.27-76.0|+------------------+1 row in set (0.00 sec)

TokuDB storage engine has the same version as Percona Server for MySQL after 5.6.26-74.0 release.

mysql 配置文件

# Percona-5.6.17, TokuDB-7.1.6，用于Zabbix数据库参考配置# 我的服务器配置：E5-2620 * 2，64G内存，1T可用磁盘空间（建议datadir所在分区设置为xfs文件系统）# TokuDB版本：Percona-5.6.17, TokuDB-7.1.6(插件加载模式)# [client]port= 3306socket= mysql.sock#default-character-set=utf8 [mysql]prompt="\u@\h \D \R:\m:\s [\d]>#pager="less -i -n -S"tee=/home/mysql/query.logno-auto-rehash[mysqld]open_files_limit = 8192max_connect_errors = 100000 #buffer & cachetable_open_cache = 2048table_definition_cache = 2048max_heap_table_size = 96Msort_buffer_size = 2Mjoin_buffer_size = 2Mtmp_table_size = 96Mkey_buffer_size = 8Mread_buffer_size = 2Mread_rnd_buffer_size = 16Mbulk_insert_buffer_size = 32M #innodb#只有部分小表保留InnoDB引擎，因此InnoDB Buffer Pool设置为1G基本上够了innodb_buffer_pool_size = 1Ginnodb_buffer_pool_instances = 1innodb_data_file_path = ibdata1:1G:autoextendinnodb_flush_log_at_trx_commit = 1innodb_log_buffer_size = 64Minnodb_log_file_size = 256Minnodb_log_files_in_group = 2innodb_file_per_table = 1innodb_status_file = 1transaction_isolation = READ-COMMITTEDinnodb_flush_method = O_DIRECT#tokudbmalloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.soplugin-dir = /usr/local/mysql/lib/mysql/plugin/plugin-load=ha_tokudb.so #把TokuDB datadir以及logdir和MySQL的datadir分开，美观点，也可以不分开，注释掉本行以及下面2行即可tokudb-data-dir = /data/mysql/zabbix_3306/tokudbDatatokudb-log-dir = /data/mysql/zabbix_3306/tokudbLog #TokuDB的行模式，建议用 FAST 就足够了，如果磁盘空间很紧张，建议用 SMALL#tokudb_row_format = tokudb_smalltokudb_row_format = tokudb_fasttokudb_cache_size = 44G #其他大部分配置其实可以不用修改的，只需要几个关键配置即可tokudb_commit_sync = 0tokudb_directio = 1tokudb_read_block_size = 128Ktokudb_read_buf_size = 128K

参考

[TokuDB Installation](https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_installation.html)
[Installing Percona Server for MySQL on Red Hat Enterprise Linux and CentOS](https://www.percona.com/doc/percona-server/5.6/installation/yum_repo.html#yum-repo)
[自建Percona5.7.23同步阿里云RDS(MySQL5.6)TokuDB数据库](https://yq.aliyun.com/articles/667969)
[RDS MySQL 物理备份文件恢复到自建数据库](https://help.aliyun.com/knowledge_detail/41817.html)

【阿里云RDS迁移，极简安装 MySQL TokuDB 引擎】