MySQL Forums :: Replication :: Setting up Circular replication in existing replication infrastructure


Advanced Search

Setting up Circular replication in existing replication infrastructure
Posted by: Phil Marsay ()
Date: September 24, 2012 04:52AM

I have the following MySQL replication topology set up for fault tolerance/recovery with master server A and slaves B,C:

A -> B
A -> C

Both B and C are fully up to date with everything from A and have nothing in addition to that (i.e. there is nothing in B,C that is not in A).

I would like to introduce some circular replication such that:
A <-> B
A -> C

So changes made in B would replicate back to server A. The reason for this is to allow me to get more use out of a secondary server by spreading the load over two primary servers.

Primary use of each individual database on the servers would be limited to a specific server. So, e.g. Users of DB "bookingsystem" always access via server B, users of DB "enquirysystem" always use server A. So there is no danger of having to deal with changes on the same DB in two different locations. The replication is purely for fault tolerance should there be a problem with either server.

So, my question is, can I simply set server A to slave from server B and have this working straight away, or is there further preparatory, or subsequent work needed?

Thanks!

Phil

Options: ReplyQuote


Subject Views Written By Posted
Setting up Circular replication in existing replication infrastructure 1702 Phil Marsay 09/24/2012 04:52AM
Re: Setting up Circular replication in existing replication infrastructure 809 Rick James 09/25/2012 09:22PM
Re: Setting up Circular replication in existing replication infrastructure 676 Phil Marsay 09/27/2012 05:48AM
Re: Setting up Circular replication in existing replication infrastructure 630 Aftab Khan 09/27/2012 02:09AM
Re: Setting up Circular replication in existing replication infrastructure 636 Phil Marsay 09/27/2012 05:49AM
Re: Setting up Circular replication in existing replication infrastructure 625 Rick James 09/27/2012 07:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.