Shulou(Shulou.com)06/01 Report--

Percona5.7 TokuBackup supports TokuDB hot backup

Install the tokudb engine

Execute the following script to install tokudb automatically.

# bin/ps-admin-defaults-file=/etc/my3308.cnf-enable-uroot-p123456-S / tmp/mysql3308.sockChecking 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.1Checking 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.cnfINFO: Successfully added thp-setting=never option into / etc/my3308.cnf

Add the mysqld_safe startup parameter preload-hotbackup to the my.cnf configuration file

# bin/ps_tokudb_admin-defaults-file=/etc/my3308.cnf-enable-backup-uroot-p123456-S / tmp/mysql3308.sockWARNING: 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.cnfINFO: Successfully added preload-hotbackup option into / etc/my3308.cnfPLEASE RESTART MYSQL SERVICE AND RUN THIS SCRIPT AGAIN TO FINISH INSTALLATION!

Restart the mysqld service

/ etc/init.d/mysql restart

Install the hot backup TokuBackup plugin tool plug-in

# bin/ps_tokudb_admin-defaults-file=/etc/my3308.cnf-enable-backup-uroot-p123456-S / tmp/mysql3308.sockWARNING: 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.

5. Start full hot backup

Hot backup can be started by executing the following command:

MySQL [(none)] > set tokudb_backup_dir='/data/tokudb_bak/';Query OK, 0 rows affected (0.408 sec)

Note: create an empty directory / data/tokudb_bak and change its property to mysql

Note:

1. Close the asynchronous IO, otherwise the backup fails.

Innodb_use_native_aio = 0

2. Incremental backup is not supported

VI. Recovery

Copy the backup files directly to your data directory and start the mysqld process.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.