Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question