How to synchronize 3 identical mysql databases?

Question

PHP

There are three identical sites with the same mysql database structure. Each site with its database is located on a separate server. You need to synchronize them with each other. So that, for example, when a new row is added to table T of base A, it appears in table T of bases B and C.
Are there ready-made solutions for this task?

Answer 1

If the bases need to be synchronized completely, I would think about the need for 3 separate bases in general. In my opinion, it is much easier to either switch to a single database, or, for example, make master-slave replication and modify the code so that you always write to the master and read from the local slave.
All other solutions are much less trivial and require thoughtful tuning.
Replication even master-master between two servers works through one place.
3 masters have never tried it, but I believe @RicoX 's word

Answer 2

The solution out of the box - master-master replication between 3 bases - is a hell of a buggy solution. For some scenarios, the Percona XtraDB Cluster (or MariaDB Galera Cluster) works much better than basic replication.

Answer 3

triple master master replication