D
D
Dmitry Lezhnev2016-03-16 13:25:16
MySQL
Dmitry Lezhnev, 2016-03-16 13:25:16

How to geographically distribute a (My)SQL read-write database?

Situation: application (php+mysql db). Everything is located on one powerful server in the cloud (DC - USA).
Problem: European customers accessing the app has pings, which is bad for business.
I did a little research and realized that master-slave replication is not suitable for us, because. each client can constantly perform write operations and immediately read.
Master-master replication looks unreliable and requires expert supervision.
What solution can be seen (based on other sql databases)? Especially something that supports geo-sharing out of the box.
Share your experience!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Lezhnev, 2016-03-17
@dimalez

So far, Galera Cluster looks like the most suitable solution.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question