Re: Switch replication master

2004-03-15 Thread cvarda
and up-to-date. []s, Conrado - Original Message - From: Steve Williams To: cvarda Cc: Batara Kesuma ; [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:28 AM Subject: Re: Switch replication master Hi, Could you take the database down long enough (scheduled downtime) to make the master

Re: Switch replication master

2004-03-15 Thread Steve Williams
Hi, Could you take the database down long enough (scheduled downtime) to make the master a slave to the slave? I seem to remember reading on this mail list that you can do circular replication... or am I talking nonsense? That way when you took the "original" master down for maintenance, the

Re: Switch replication master

2004-03-15 Thread cvarda
Depending on the size of your databases, it might be a good idea to copy back your 'data' directory from slave to master. I think this should work better, even because the master wouldn't get the INSERT/UPDATEs made on the slave. []s, Conrado - Original Message - From: "Batara Kesuma" <