For two hosts, everything is simple: I specify the first as the first server for the first one, and the first for the second (with the help of the SQL command change master to master_host ..).

There is a need to configure replication for a system of 4 hosts. Tell me how to implement it.

  • This is not called "Multi-master", but "master-master" replication. Creating a replication grid for 4 hosts is impossible; replication in MySQL can only operate with a single master. You can try to create a ring of replication (the first is the master of the second, the master of the third, he is the master of the fourth, who will be the master of the first). - Akina
  • Although if you have NDB - then everything is according to the manual. dev.mysql.com/doc/refman/5.7/en/… - Akina
  • Thanks for answers. I stopped at the NDB cluster, as we are only going to deploy the database. I will test. - Ilia Mikhailov

0