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

Can I use Xtrabackup to clone an existing replica?

steve_wechslersteve_wechsler EntrantCurrent User Role Beginner
Suppose I have a master and a replica already in production, and I want to create a second replica of the master (not chained). I'd like to do this during production hours, so running a backup against the master instance is off the table. I can currently do this by shutting down the replica and copying all the data files over to the new replica, then using the info in the original replica's file to start replication on the new replica. If I want to do this without shutting down the first replica, is there a way I can clone it using Xtrabackup and then somehow retrieve the required start positions to start the I/O thread on the new replica without duplicating or losing any transactions?



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.