MYSQL 5.6 Recovery Record--Percona xtrabackup

KING02 Install only MySQL 5.6 software no need to build library please refer to "MySQL 5.6 source code compilation installation Record"

KING02 Install Xtrabackup, please refer to "MYSQL 5.6 Backup transcript-Percona xtrabackup"

[Email protected] ~]# mkdir-p/usr/local/mysql/backup

[Email protected] ~]# chown-r mysql/usr/local/mysql/backup

[Email protected] ~]# scp/etc/my.cnf [email protected]:/etc

[Email protected] ~]# Su-mysql

[Email protected] ~]$ cd/usr/local/mysql/backup/

[Email protected] backup]$ scp-r 2018-02-04_03-00-01 [email protected]:/usr/local/mysql/backup

[Email protected] backup]$ scp-r 2018-02-05_03-00-01 [email protected]:/usr/local/mysql/backup

[Email protected] ~]# Su-mysql

[Email protected] ~]$ Innobackupex--defaults-file=/etc/my.cnf--apply-log--redo-only/usr/local/mysql/backup/ 2018-02-04_03-00-01/

[Email protected] ~]$ Innobackupex--defaults-file=/etc/my.cnf--apply-log/usr/local/mysql/backup/2018-02-04_ 03-00-01/--incremental-dir=/usr/local/mysql/backup/2018-02-05_03-00-01

[Email protected] ~]$ Innobackupex--defaults-file=/etc/my.cnf--copy-back/usr/local/mysql/backup/2018-02-04_ 03-00-01/

[[Email protected] ~]$ service mysqld start

Starting MySQL. [OK]

[[Email protected] ~]$ service mysqld status

MySQL Running (15608)

MYSQL 5.6 Recovery Record--Percona xtrabackup