Re: Change master on replication

2004-10-23 Thread Matthias Urlichs
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

Re: Change master on replication

2004-10-22 Thread Sean Leach
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

RE: Change master on replication

2004-10-22 Thread Sanjeev Sagar
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