Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

Multi-Node Real-Time Replication Technology

  • Posted April 11, 2014

Hello,

Need some advice on which replication technology to choose? Please find a network diagram at the following URL for clarity:

http://www.screencast.com/t/zqfhMN10jKu

A Brief Synopsis:

I need to deploy a web application based on PHP and MySQL across Geographically spread data centres. Each Data Centre will have multiple nodes and the load balancing will be done by a HA Proxy Server within the DC. All nodes within the DC needs to be replicated in Real Time and nodes across DCs need to be replicated in Real Time as well.

When an end user fires a DNS query, the anycast DNS servers will lookup the requestor IP and then route the user to the geographically closest DC. The DNS servers will also manage a DNS level Fail Over in case the HA Proxy Server in any of the DCs goes down. In case an additional HA proxy server is deployed per DC for HA, then the DNS will also do load balancing between the 2 HA proxy servers.

I am stumped with which replication technology to choose. I considered DRBD but then that allows replication between 2 nodes only. DRBD 9 allows multi-node replication however that is yet in pre-release phase. Gluster FS will achieve HA however the Geo Targetting will not work. RSync and Unison are completely out of the equation as they are not real-time.

Please guide…

Thanks and regards, Mangesh

Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

ManishSingh • October 1, 2014

Setup DRBD (synchronous replication) between two geo separated node. Both should have slaves at each end.

Introduce Percona MySQL for Synchronous Replication (i think it provides synchronous replication feature) for inter DC DB replication.

DNS can be configured as Round Robin fashion for DNS level load balancing.

Please correct me if i misunderstood.

-Manish

Kamal Nasser • April 15, 2014

<blockquote>Gluster FS will achieve HA however the Geo Targetting will not work.</blockquote>I’m not sure I understand why Geotargeting won’t work with GlusterFS. <br> <br>GlusterFS isn’t exposed to your users, it simply mirrors the filesystem between your nodes. Geotargeting will still target your HAProxy instances properly.