innobackupex 备份还原

备份数据

/usr/local/percona-xtrabackup-2.4.7/bin/innobackupex --user=xxx --password=xxxx --socket=/data/apps/mysql/var/mysql.sock /data/backup/2026-07-13_06-30-01

还原数据

/usr/local/percona-xtrabackup-2.4.7/bin/innobackupex --apply-log /data/backup/2026-07-13_06-30-01

/usr/local/percona-xtrabackup-2.4.7/bin/innobackupex --copy-back --datadir=/data/mysql/data  /data/backup/2026-07-13_06-30-01

查看备份信息

cat xtrabackup_info

uuid = e0dcbb3d-7eba-11f1-b87c-6c92bf31adaa
name = 
tool_name = innobackupex
tool_command = --user=ibuser --password=... --socket=/data/database/mysql/var/mysql.sock /mysqlbak
tool_version = 2.4.7
ibbackup_version = 2.4.7
server_version = 5.7.36-log
start_time = 2026-07-13 20:00:02
end_time = 2026-07-13 21:00:52
lock_time = 0
binlog_pos = filename 'mysql-bin.000902', position '188452778', GTID of the last change '026fa466-8bef-11ed-82c5-6c92bf31adaa:1-295126864'
innodb_from_lsn = 0
innodb_to_lsn = 800727644648
partial = N
incremental = N
format = file
compact = N
compressed = N
encrypted = N

配置主从同步

reset slave all;

reset master;

SET GLOBAL gtid_purged = '026fa466-8bef-11ed-82c5-6c92bf31adaa:1-295126864';

-- 在从库上执行
CHANGE MASTER TO MASTER_HOST='xxx', MASTER_PORT=3306,MASTER_USER='xxx',MASTER_PASSWORD='xxx', MASTER_AUTO_POSITION=1; 

START SLAVE;