Percona5.7TokuBackup支持TokuDB热备份-创新互联
Percona5.7 TokuBackup支持TokuDB热备份
让客户满意是我们工作的目标,不断超越客户的期望值来自于我们对这个行业的热爱。我们立志把好的技术通过有效、简单的方式提供给客户,将通过不懈努力成为客户在信息化领域值得信任、有价值的长期合作伙伴,公司提供的服务项目有:主机域名、网络空间、营销软件、网站建设、吴起网站维护、网站推广。一、安装tokudb引擎
执行以下脚本,自动安装tokudb。
# bin/ps-admin --defaults-file=/etc/my3308.cnf --enable -uroot -p123456 -S /tmp/mysql3308.sock Checking SELinux status... INFO: SELinux is disabled. Checking if TokuDB plugin is available for installation ... INFO: ha_tokudb.so library for TokuDB found at /usr/local/Percona/lib/mysql/plugin/ha_tokudb.so. Checking location of jemalloc library ... INFO: jemalloc library needed for TokuDB found at /usr/local/Percona/lib/mysql/libjemalloc.so.1 Checking if Percona Server is running with jemalloc enabled... INFO: Percona Server is running with jemalloc enabled. Checking transparent huge pages status on the system... INFO: Transparent huge pages are currently disabled on the system. Checking if thp-setting=never option is already set in config file... INFO: Option thp-setting=never is not set in the config file. (needed only if THP is not disabled permanently on the system) Checking TokuDB engine plugin status... INFO: TokuDB engine plugin is installed. Adding thp-setting=never option into /etc/my3308.cnf INFO: Successfully added thp-setting=never option into /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.sock WARNING: This script is deprecated and will be removed in 8.0. You can use ps-admin script which has more functionality. Checking SELinux status... INFO: SELinux is disabled. Checking if Percona Server is running with jemalloc enabled... INFO: Percona Server is running with jemalloc enabled. Checking transparent huge pages status on the system... INFO: Transparent huge pages are currently disabled on the system. Checking if thp-setting=never option is already set in config file... INFO: Option thp-setting=never is set in the config file. Checking if preload-hotbackup option is already set in config file... INFO: Option preload-hotbackup is not set in the config file. Checking TokuDB engine plugin status... INFO: TokuDB engine plugin is installed. Checking TokuBackup plugin status... INFO: TokuBackup plugin is not installed. Adding preload-hotbackup option into /etc/my3308.cnf INFO: Successfully added preload-hotbackup option into /etc/my3308.cnf PLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!三、重启mysqld服务
/etc/init.d/mysql restart四、安装热备份TokuBackup plugin工具插件
# bin/ps_tokudb_admin --defaults-file=/etc/my3308.cnf --enable-backup -uroot -p123456 -S /tmp/mysql3308.sock WARNING: This script is deprecated and will be removed in 8.0. You can use ps-admin script which has more functionality. Checking SELinux status... INFO: SELinux is disabled. Checking if Percona Server is running with jemalloc enabled... INFO: Percona Server is running with jemalloc enabled. Checking transparent huge pages status on the system... INFO: Transparent huge pages are currently disabled on the system. Checking if thp-setting=never option is already set in config file... INFO: Option thp-setting=never is set in the config file. Checking if preload-hotbackup option is already set in config file... INFO: Option preload-hotbackup is set in the config file. Checking TokuDB engine plugin status... INFO: TokuDB engine plugin is installed. Checking TokuBackup plugin status... INFO: TokuBackup plugin is not installed. Checking if Percona Server is running with libHotBackup.so preloaded... INFO: Percona Server is running with libHotBackup.so preloaded. Installing TokuBackup plugin... INFO: Successfully installed TokuBackup plugin.五、开始全量热备份
执行下面的命令即可开启热备份:
MySQL [(none)]> set tokudb_backup_dir='/data/tokudb_bak/'; Query OK, 0 rows affected (0.408 sec)注:创建一个空目录/data/tokudb_bak,并将其属性改成mysql
注意事项:
1、关闭异步IO,否则备份失败。
innodb_use_native_aio = 02、不支持增量备份
六、恢复
直接拷贝备份文件至你的数据目录下,启动mysqld进程即可。
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
当前题目:Percona5.7TokuBackup支持TokuDB热备份-创新互联
标题网址:http://myzitong.com/article/ddeodd.html