innobackupex /data/backups/ $ cat xtrabackup_binlog_info Mysql-bin.000002 1232 c777888a-b6df-11e2-a604-080027635ef5:
innobackupex /data/backups/
$ cat xtrabackup_binlog_info
Mysql-bin.000002 1232 c777888a-b6df-11e2-a604-080027635ef5:1-4
TheMaster$ innobackupex --apply-log /data/backups/$TIMESTAMP/
TheMaster$ rsync -avprP -e ssh /path/to/backupdir/$TIMESTAMP NewSlave:/path/to/mysql/
NewSlave$ chown mysql:mysql /path/to/mysql/datadir
NewSlave > SET GLOBAL gtid_purged="c777888a-b6df-11e2-a604-080027635ef5:1-4";
NewSlave > CHANGE MASTER TO
MASTER_HOST="$masterip",
MASTER_USER="repl",
MASTER_PASSWord="$slavepass",
MASTER_AUTO_POSITION = 1;
注: innobackupex was previously deprecated and has been removed from Percona XtraBackup 8.0-3-rc1 .
--结束END--
本文标题: Create a new (or repair a broken) GTID based slave
本文链接: https://www.lsjlt.com/news/6168.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0