Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

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

share|improve this answer
    
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. –  Andrew Smith Aug 20 '12 at 19:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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