Comments - Mariadb DB Replication 4 Nodes as Master to Master

1 year, 2 months ago Markus Mäkelä

One thing to note is that Galera is not a true multi-master solution and the main benefit of it are the resilience and auto-recovery of the cluster. Writes should still only happen on one node at a time to prevent conflicts on commit. Using something like MaxScale can make this easier as it automatically spreads the read workload to all nodes while still focusing writes to a single node.

A solution for write scaling would be something like MariaDB Xpand that is designed for parallel writes.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.