Hi, Sean Leach wrote:
> my question is in the best way to sync Slave 1 and Slave 2 with Master B
> since Master A and Master B weren't completely in sync.
>
Well, obviously you need to sync the slaves to B. ;-)
I've written a Python script that does this. Holler if you want it.
NB, the script
Yeah - sorry, a typo. Master A is down, so I need to repoint Slave 1
and Slave 2 to Master B. Same problem though. I know how to tell it's
down, my question is in the best way to sync Slave 1 and Slave 2 with
Master B since Master A and Master B weren't completely in sync.
Sanjeev Sagar wrot
Master A has Slave 1 and Slave 2
Master B has Slave 3 and Slave 4
Master A is ahead of Master B, and Master A goes down, we want to
repoint Slave 3 and Slave 4 to Master B. Since the data is large, we
don't want to do a fresh resync of Slave 3 and 4 from scratch. And A
and B may not have be
We have an environment where we will have multiple mysql masters, and
multiple slaves hanging off each master (the masters are actually slaves
from another data store updated by a script).
The table we are replicating is about 6GB in size, so somewhat large.
If one of the masters goes down, we