The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Mr

My company will like to use mariadb for our next project as we're currently using mysql, we'll like to know how the clustering and the replication works.

Thanks

Answer Answered by Nirbhay Choubey in this comment.

MariaDB broadly supports 2 types of replication scenarios where changes are replicated to the other nodes (1) asynchronously (the classical MariaDB replication), and (2) synchronously (MariaDB Galera cluster). There is also a variant of async replication called semi-sync replication. MariaDB replication works on the same principal as MySQL. The changes from source server (or node) are logged in binary format and replicated to other node(s) where they are applied. You should be also find information about all these topics in MariaDB Knowledge base. There are also quite a few blogs covering them.

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.