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.