Choosing a platform for MySQL cluster, what do you recommend?

Question

MySQL

Good afternoon.

At the moment I am choosing the means to create a mysql cluster for 3 machines.
I am considering two options: MySQL InnoDB Cluster (Master-Slave) and Mariadb + Galera4 (Master-Master).

MariaDB is preferable because the existing product already works with this DBMS, but it strains the requirement for the mandatory presence of a PrimaryKey (there is a table without it) and the need to make auto-increment fields with a step greater than 1. Well, I'm afraid of the Master-Master scheme, it seems less reliable.

MySQL InnoDB Cluster is nice because it has dealt with replication before and everything works without problems, well, there seems to be no difficulties with tables, except for the need to test the work of existing software with MySQL. Well, it seems quite convenient to install MySQL Router on the same computer as the software.

I would love to hear feedback on using both solutions and possibly suggestions for other options.

Answer 1

I didn't work with "MySQL InnoDB Cluster" - I won't say anything
Galera and just master-slave: there are now a pack of galleys from percona and master slaves of all vendors in the sale.
The galley does not matter which vendor - if you do not touch it, it works fine. it is better to put haproxy in front of the gallery (separately or where the application lives) - so that the connections go by default to one node and there are checks that the node is in synch with others, and an additional node in case of problems with the one to which the connections go by default.
Master-slave The question remains - what will your application do if the master has fallen?
Documentation and utilities I like more from Percona.
The PrimaryKey requirement is a galley mechanism and there's nothing you can do about it.
Also, choosing Galera does not matter from whom - read about how the cluster recovery occurs if one of the nodes has lost all data, about the types of SST and the availability of the donor node.