MySQL Forums
Forum List  »  Replication

Multi-Master replication
Posted by: Robert Martin
Date: February 26, 2015 02:04PM

So today I finally figured out how to setup a multi-master replication scenario (per my customers request).

ServerA
ServerB

Each server has 5 databases running under a single instance and I have tested the replication on both sides and see my transactions coming across from a> B and from B > A. No problem....

However, for forgive me for being a noob in this area, but the customer has asked now about how to take advantage of this setup so that their applicaiton will fail over to ServerA if ServerB is down and vice versa?

Again, being new to this and being an Oracle DBA....I took care of what they requested and now finding that MySQL does not have a "tnsnames" for configuring this type of failover. What options do I have available?

Thank you in advance....

-Rob

Options: ReplyQuote


Subject
Views
Written By
Posted
Multi-Master replication
1624
February 26, 2015 02:04PM
957
February 27, 2015 12:09PM
917
April 21, 2015 08:07PM


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.