galera-overview.png

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB. It is available on Linux only, and only supports the XtraDB/InnoDB storage engines (although there is experimental support for MyISAM - see the wsrep_replicate_myisam system variable).

Starting with MariaDB 10.1, the wsrep API for Galera Cluster is included by default. This is available as a separate download for MariaDB 10.0 and MariaDB 5.5.

MariaDB has one of the best and easiest solutions to do a Master-Master replication: Galera. Galera uses WSREP, which it is responsible for maintaining all the Database nodes in the cluster in sync. This means, after changing one record on node A, it is just a matter of seconds to see the change on node B.

I will talk in this article how I did this configuration using MariaDB 10.1.x. Remember you can install MariaDB under Centos 6 and 7 by using OKay's repository.

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

If you like me, and you have a lot of free disk space then it is a good idea to make money by farming it. Farming is the term we are going to use when you are renting your free space to others. Currently, for some happy reasons, I have 7 TB I can rent. In this article, I will show how to rent your space. Once you get your SIA Coins (SC), it is up to you to trade them.

mariadb-galera.jpg

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

This is one of the most common issues that could carry issues if you have a MariaDB Galera Cluster. After restarting the cluster, the nodes are not joining. If you look into your log, you may find a line like this:

It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates. To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1.

Continue reading, here there are some steps I did to recover mine.