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

Backup/restore for multi source replicated server?

aspantelaspantel EntrantInactive User Role Beginner
Hello, we have started looking into multi-source replication (for two master databases) recently but then realized that we don't understand well if xtrabackup would work for this. Assuming that xtrabackup would create a backup file just fine, is there a way to restore just one source/master from the backup file?

We backup with this command

innobackupex --no-lock --stream=xbstream --compress --compress-threads=2 ./backup

The backup file would contain the whole multi-source replicated database, right?

Any info on this topic would be very appreciated.

Thank you.
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.