mysql 8.0 xtrabackup简介与安装_ide

  1. 安装

wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-8.0.4/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.4-1.el7.x86_64.rpm
yum localinstall percona-xtrabackup-80-8.0.4-1.el7.x86_64.rpm

  1. 授权操作

CREATE USER 'backupuser'@'%' IDENTIFIED with mysql_native_password BY 'wwwwww';
GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'backupuser'@'%';
GRANT SELECT ON performance_schema.log_status TO 'backupuser'@'%';
FLUSH PRIVILEGES;

  1. 执行完全备份操作

[root@mysql ~]# xtrabackup --host=192.168.2.150 --port=3306 --user=backupuser --password=wwwwww --backup --target-dir=/data/mysql/
[root@mysql mysql]# cat xtrabackup_checkpoints 
backup_type = full-backuped
from_lsn = 0
to_lsn = 431427667
last_lsn = 431427667
flushed_lsn = 0
[root@mysql

4.模拟删除数据库

mysql> drop database test;
Query OK, 2 rows affected (0.28 sec)

5.恢复全备

[root@mysql mysql]# /etc/init.d/mysqld stop
Shutting down MySQL..... SUCCESS! 
[root@mysql mysql]# mv /mysql/data/ /mysql/data_bak
[root@mysql mysql]# mkdir /mysql/data
[root@mysql mysql]# chown mysql.mysql /mysql/data
[root@mysql mysql]# xtrabackup --host=192.168.2.150 --port=3306 --user=backupuser --password=wwwwww --datadir=/mysql/data --copy-back --target-dir=/data/mysql/