Situation: application(php + mysql db).Everything is located on one powerful server in the cloud(DC - USA).
Problem: access to the client application from Europe has pings, which is bad for business.
I did a little research and realized that master-slave replication does not suit us, because Each client can constantly perform write and read operations.
Master-master replication seems unreliable and requires expert supervision.
What solution can I see(based on other sql db)? Especially something that supports out-of-the-box geo-distribution.
Share your experience!