MySQL Forums
Forum List  »  Replication

Suggestion for the master-master cross datacenter.
Posted by: Leo Zheng
Date: September 21, 2018 03:19PM

I am new to mysql and need help for the following setting:

The layout.

DC1: A1 A2
DC2: S1 S2

A1, A2 are the two mysql servers in datacenter 1, which is master-master, and hosted two database (db01, db02)
S1, S2 are the two mysql servers in datacenter 2, which is master-master, and hosted two database (db02, db01)

db01 in A1/A2 is used by the application1 in DC1, db01 in S1/S2 is for the standby.
Similiarly, db02 in S1/S2 is used by the application2 in DC2, db02 in A1/A2 is for the standy.

In case datacenter 1 goes down, "standby" application1 (in dc2) will use the standby db01 in DC2. Later after DC1 recovered, we need to be able to sync db01 from dc2 to dc1 from dc2.

How can we sync? (two-way replications/sync?) Could you help to provide some advice? Steps will be more helpful.

Options: ReplyQuote


Subject
Views
Written By
Posted
Suggestion for the master-master cross datacenter.
635
September 21, 2018 03:19PM


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.