2

I have downloaded the new MySQL Community Server 5.6 and I dont quite understand how to use it properly for GeoIP based replication across 20 nodes. I want to have one central node, then three smaller ones, and then 8 sub-sub nodes so it's like a tree, and the writes are propagating in the cycle around the globe.

Have anyone has any link to point any theory on the above scenario, or what would be appropriate option without migrating to MySQL Cluster?

1

Would you be interested in a MySQL Replication setup that is shaped like a snowflake ?

You could setup a Star Topology

  • Have a Write Master
  • Setup up a Distribution Master (DM). The role of the Distribution Master is simple
    • Slave to Write Master
    • Store No Data (All tables use BLACKHOLE Storage Engine)
    • Have Binary Logging Enabled
    • Act as Master to Multiple Read Slaves

For your case, you could have

Write Master in WM1

  • DM1 as Slave to WM1
    • SLV1 as Slave to DM1
    • SLV2 as Slave to DM1
  • DM2 as Slave to WM1
    • SLV3 as Slave to DM2
    • SLV4 as Slave to DM2
  • DM3 as Slave to WM1
    • SLV5 as Slave to DM3
    • SLV6 as Slave to DM3

You could hang a DM as a Slave off of another DM

The possibilities are endless

I have written about setting this up before

1
  • OKOK I have now idea how to get this to work properly. I'll put one in place, and see how it performs with 4 nodes with 200-300ms distances from the write master in London. Aug 20 '12 at 19:11

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.