fb_pixel

How to geographically distribute MySQL read-write database?

Development | Databases
Description
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!
Attachments
No attachments
Info
Description
So far, the most suitable solution looks like Galera Cluster. For more detail see: https://galeracluster.com/products/ :-)
on December 23rd, 2019 (10:14 am)
All coments
This job has not been commented yet.