Database replication between datacenters
Linode
Linode Staff
Hi,
Is it possible with Linode to have two servers with exactly the same data on the disk and in the MySQL database (editable from one place) on a server in EU and on another Server in the US to decrease latency time?
1 Reply
Hi,
What you're looking to achieve is possible but you will also need to account for time spent in replication over the public network. This guide on master-master replication, adopted to use the public address may help you out. The databases section of our docs also contains application specific guides on configuring clusters.
Depending on your end goals, a CDN may also be appropriate; services such as Cloudflare and Akamai offer these. While this will not replicate your database, they offer caching that can improve your sites response times.