使用XtraBackup创建mysql slave10

franket

发布于 2022-05-12 22:58:37

4820

发布于 2022-05-12 22:58:37

恢复数据库

准备完数据后，会多出来一个文件

[root@slave-test 2015-10-12_15-24-06]# ll /tmp/xtrabackup_*
-rw-r--r-- 1 root root    25 Oct 12 20:02 /tmp/xtrabackup_binlog_info
-rw-r----- 1 root root    97 Oct 12 20:02 /tmp/xtrabackup_checkpoints
-rw-r--r-- 1 root root   610 Oct 12 20:02 /tmp/xtrabackup_info
-rw-r----- 1 root root 13824 Oct 12 20:02 /tmp/xtrabackup_logfile
[root@slave-test 2015-10-12_15-24-06]# ll xtrabackup_*
-rw-r--r-- 1 root root      25 Oct 12 15:31 xtrabackup_binlog_info
-rw-r--r-- 1 root root      25 Oct 12 20:23 xtrabackup_binlog_pos_innodb
-rw-r----- 1 root root      97 Oct 12 20:23 xtrabackup_checkpoints
-rw-r--r-- 1 root root     610 Oct 12 15:31 xtrabackup_info
-rw-r----- 1 root root 2097152 Oct 12 20:23 xtrabackup_logfile
[root@slave-test 2015-10-12_15-24-06]# cat  /tmp/xtrabackup_binlog_info
mysql-bin.000009	1509223
[root@slave-test 2015-10-12_15-24-06]# cat xtrabackup_binlog_info 
mysql-bin.000009	1509223
[root@slave-test 2015-10-12_15-24-06]# cat xtrabackup_binlog_pos_innodb 
mysql-bin.000009	1509223
[root@slave-test 2015-10-12_15-24-06]#

在合适的位置创建一个空文件夹，用来存放数据文件

[root@slave-test lib]# mv mysql/ mysql.old
[root@slave-test lib]# ln -s /data/mysql/  /var/lib/mysql
[root@slave-test lib]# cd /var/lib/mysql
[root@slave-test mysql]# ls
[root@slave-test mysql]# 
[root@slave-test ~]# ll /var/lib/mysql
lrwxrwxrwx 1 root root 12 Oct 12 15:00 /var/lib/mysql -> /data/mysql/
[root@slave-test ~]# ll /data/mysql/
total 0
[root@slave-test ~]#

Note: The datadir must be empty ; Percona XtraBackup innobackupex –copy-back option will not copy over existing files unless innobackupex –force-non-empty-directories option is specified. Also it’s important to note that MySQL server needs to be shut down before restore is performed. You can’t restore to a datadir of a running mysqld instance (except when importing a partial backup).

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

数据库