I'm preparing to run a MariaDB Cluster with High Availability and I'm looking for the best practices.
Years back, I used to run MariaDB in master-master mode, and there was a big issue. Whenever any of the nodes (two nodes in total) was disconnected and reconnected for a second, the whole database was inaccessible until the sync process was completed.
I did search a lot and there are multiple suggestions, which not sure which one is the best and simple solution to go for.
1. using maxscale as proxy
2. using master-slave mode
3. using master-master mode
I haven't worked with MaxScale, and I would be thankful if someone guides me if this is the best solution to go for a database with high I/O, also I know that I need to have another MaxScale + HAProxy setup to cover MaxScale failures.
The second item is not a proper solution, since if the master DB fails I need to go over some manual processes to make it as master.
The third item, could be used with Galera, but as I searched I saw many people complaining about the sync issues which I had before.
I would be thankful if someone can guide me with at least 2-3 years of experience in such a cluster.
Asked by Zareh Kasparian
(121 rep)
Feb 17, 2022, 09:06 PM
Last activity: Sep 7, 2024, 04:02 PM
Last activity: Sep 7, 2024, 04:02 PM