I have a pair of servers running standard active/passive circular replication using mmm,
call them A and B. I want to introduce new server C, ultimately to replace B. I'm setting
it up by restoring an xtrabackup snapshot taken from B (using the practice of doing
backups on a slave to keep backup traffic off the active master). I know the details of
the master log and position for the backup, but it's from B not A, and though there must
be one, I've no way of knowing what the corresponding log and position on A is.
Here's the background: I want to move from:
A <-> B
to (slave C from A)
C <- A <-> B
to (break replication back from B)
C <- A -> B
to (close loop from A to C)
C <-> A -> B
to (remove B)
C <-> A
As far as I can see I can either:
• Take a new backup from A
• Switch B to be active master and retire A instead (A and B are identical)
Any other suggestions?
Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
Attachment: [application/pkcs7-signature] smime.p7s
