Comments - Mariadb DB Replication 4 Nodes as Master to Master
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.
Yes, look at Galera Cluster.
Don't consider doing classical replication between 4 nodes. If something goes wrong it will be complicated recovery process with some risks in getting the recovery steps incorrect.
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.
Thanks for you expert advise, Is there any platform dependencies using Galera cluster ?
Using Galera Cluster we need to configure all nodes on same Operating system. If the One node is on windows platform that can also be connect with Cluster environment.
Regards Sohail Ahmed