Not the answer you need?
Register and ask your own question!

new slave from xtrabackup of slave

ITBITB EntrantCurrent User Role Beginner
We currently have a master (say, A) and a slave (say, B). We have weekly full and daily incrementals of the slave, B. We now want to introduce a new slave, as a sibling of B (say, C). We want to create this slave C with a restore of the slave B backups. Is it possible to do this? where can we find the master (A) binlog position at the time of the backup? xtrabackup_binlog_info contains the binlog info of the B server but not of the A. Or should we just restore the backup, and will the binlog position be available to the restored database, so we can just start the replication and it will sync with the master?

thanks, ITB.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.