0

We'd like to have two MySQL cluster groups, and at the same time have replication set up between them. Is that possible?

migrated from serverfault.com Dec 9 '14 at 3:31

This question came from our site for system and network administrators.

1

Here are two possible setups you could try

TOPOLOGY #1

  • Data Center #1 with two(2) DB Servers (DB1, DB2)
  • Data Center #2 with two(2) DB Servers (DB3, DB4)
  • Setup DRBD with Each Data Center
  • Setup MySQL Replication Between the DRBD Primaries
  • Setup DBVIP (Linux Heartbeat/ Pacemaker / ucarp)

What this setup provides

  • Synchronous Disk-Level Replication Within Each Data Center
  • Asynchronous Replication Between Data Centers

TOPOLOGY #2

  • Data Center #1
  • Data Center #2
  • MySQL Circular Replication
    • DB3 used as Master to DB6
    • DB3 used as Slave to DB6
    • Use Semisync Replication Between Master and Slave

What this setup provides

  • Virtually Synchronous Replication Within Each Data Center
  • Asynchronous Replication Between Data Centers

I have discussed setups like this before

GIVE IT A TRY !!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy