mysql 8.0 xtrabackup简介与安装

本文链接：mysql 8.0 xtrabackup简介与安装 -- cnDBA.cn_中国DBA社区

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 mysql]# cat xtrabackup_binlog_info 
   mysql-bin.000005        155
   

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/