Solution: How to geographically distribute MySQL read-write database?

Development | Databases
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!
No attachments
So far, the most suitable solution looks like Galera Cluster. For more detail see: :-)
on December 23rd, 2019 (10:14 am)
All coments
This solution has not been commented yet.
You must sign in to comment!! LOGIN
We use cookies to give you the best possible experience on our site. By continuing to use the site you agree to our use of cookies. Find out more Accept