Skip to main content

Posts

Showing posts from December, 2022

Configure Galera Cluster with Mariadb 10.3 on Centos7 with HAproxy load balancer

  Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue serving. Clusters come in two general configurations,  active-passive  and  active-active . In active-passive clusters, all writes are done on a single active server and then copied to one or more passive servers that are poised to take over only in the event of an active server failure. Some active-passive clusters also allow  SELECT  operations on passive nodes. In an active-active cluster, every node is read-write and a change made to one is replicated to all. MariaDB  is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. You can read the official documentation for MariaDB at this  page .  Galera  is a database clustering solution that enables you to set up multi-master clusters using sy...