Percona5.7 TokuBackup支持TokuDB热备份

一、安装tokudb引擎

执行以下脚本，自动安装tokudb。

#bin/ps-admin--defaults-file=/etc/my3308.cnf--enable-uroot-p123456-S/tmp/mysql3308.sockCheckingSELinuxstatus...INFO:SELinuxisdisabled.CheckingifTokuDBpluginisavailableforinstallation...INFO:ha_tokudb.solibraryforTokuDBfoundat/usr/local/Percona/lib/mysql/plugin/ha_tokudb.so.Checkinglocationofjemalloclibrary...INFO:jemalloclibraryneededforTokuDBfoundat/usr/local/Percona/lib/mysql/libjemalloc.so.1CheckingifPerconaServerisrunningwithjemallocenabled...INFO:PerconaServerisrunningwithjemallocenabled.Checkingtransparenthugepagesstatusonthesystem...INFO:Transparenthugepagesarecurrentlydisabledonthesystem.Checkingifthp-setting=neveroptionisalreadysetinconfigfile...INFO:Optionthp-setting=neverisnotsetintheconfigfile.(neededonlyifTHPisnotdisabledpermanentlyonthesystem)CheckingTokuDBenginepluginstatus...INFO:TokuDBenginepluginisinstalled.Addingthp-setting=neveroptioninto/etc/my3308.cnfINFO:Successfullyaddedthp-setting=neveroptioninto/etc/my3308.cnf

二、增加mysqld_safe启动参数preload-hotbackup至my.cnf配置文件里

#bin/ps_tokudb_admin--defaults-file=/etc/my3308.cnf--enable-backup-uroot-p123456-S/tmp/mysql3308.sockWARNING:Thisscriptisdeprecatedandwillberemovedin8.0.Youcanuseps-adminscriptwhichhasmorefunctionality.CheckingSELinuxstatus...INFO:SELinuxisdisabled.CheckingifPerconaServerisrunningwithjemallocenabled...INFO:PerconaServerisrunningwithjemallocenabled.Checkingtransparenthugepagesstatusonthesystem...INFO:Transparenthugepagesarecurrentlydisabledonthesystem.Checkingifthp-setting=neveroptionisalreadysetinconfigfile...INFO:Optionthp-setting=neverissetintheconfigfile.Checkingifpreload-hotbackupoptionisalreadysetinconfigfile...INFO:Optionpreload-hotbackupisnotsetintheconfigfile.CheckingTokuDBenginepluginstatus...INFO:TokuDBenginepluginisinstalled.CheckingTokuBackuppluginstatus...INFO:TokuBackuppluginisnotinstalled.Addingpreload-hotbackupoptioninto/etc/my3308.cnfINFO:Successfullyaddedpreload-hotbackupoptioninto/etc/my3308.cnfPLEASERESTARTMYSQLSERVICEANDRUNTHISSCRIPTAGAINTOFINISHINSTALLATION!

三、重启mysqld服务

/etc/init.d/mysqlrestart

四、安装热备份TokuBackup plugin工具插件

#bin/ps_tokudb_admin--defaults-file=/etc/my3308.cnf--enable-backup-uroot-p123456-S/tmp/mysql3308.sockWARNING:Thisscriptisdeprecatedandwillberemovedin8.0.Youcanuseps-adminscriptwhichhasmorefunctionality.CheckingSELinuxstatus...INFO:SELinuxisdisabled.CheckingifPerconaServerisrunningwithjemallocenabled...INFO:PerconaServerisrunningwithjemallocenabled.Checkingtransparenthugepagesstatusonthesystem...INFO:Transparenthugepagesarecurrentlydisabledonthesystem.Checkingifthp-setting=neveroptionisalreadysetinconfigfile...INFO:Optionthp-setting=neverissetintheconfigfile.Checkingifpreload-hotbackupoptionisalreadysetinconfigfile...INFO:Optionpreload-hotbackupissetintheconfigfile.CheckingTokuDBenginepluginstatus...INFO:TokuDBenginepluginisinstalled.CheckingTokuBackuppluginstatus...INFO:TokuBackuppluginisnotinstalled.CheckingifPerconaServerisrunningwithlibHotBackup.sopreloaded...INFO:PerconaServerisrunningwithlibHotBackup.sopreloaded.InstallingTokuBackupplugin...INFO:SuccessfullyinstalledTokuBackupplugin.

五、开始全量热备份

执行下面的命令即可开启热备份：

MySQL[(none)]>settokudb_backup_dir='/data/tokudb_bak/';QueryOK,0rowsaffected(0.408sec)

注：创建一个空目录/data/tokudb_bak，并将其属性改成mysql

注意事项：

1、关闭异步IO，否则备份失败。

innodb_use_native_aio=0

2、不支持增量备份

六、恢复

直接拷贝备份文件至你的数据目录下，启动mysqld进程即可。