Two-Node Clusters

Length: 880 words; Published: June 24, 2015; Updated: October 22, 2019; Category: Topology; Type: Best Practices

When using Galera Cluster, it’s recommended that the cluster have at least three nodes. However, some DBAs would prefer to use only two nodes. This could be because their budget doesn’t allow for the cost of a third production node. Or it could be that they are putting together a cluster for testing updates and want to minimize the effort and expense of testing.

Whatever the reason for having only two nodes, there are some factors to consider, some preventive measures to take. In a two-node cluster, when there is a conflicting pair of transactions, it could lead to a split-brain situation. Also, when one node fails, the remaining node will become non-operational. This KB article will explain how to address these possibilities.

Two Scenarios

For this KB article, we’ll consider two scenarios. The first scenario involves dealing with conflicting transactions in a two-node cluster. Suppose each node executes a transaction which changes the same row in the same table at the same time. Each node will vote for its transaction as being the superior one. Normally, a third node would be called upon to cast the deciding vote. Without that tie-breaking vote, each node will commit their respective conflicting transaction. This is known as a split-brain. As more transactions occur, the data could continue to deviate, more conflicts can occur.

For the second scenario, suppose that one of the nodes in a two-node cluster, leaves the cluster, ungracefully. For instance, it crashes or loses network connectivity. When this happens, the other node becomes non-operational. It will remain so until additional information is provided by a third entity, such as another node joining or an administrator intervening.

There’s a reason for nodes becoming non-operational. If a node is separated from the cluster due to losing network connection, both nodes will think itself as being the Primary Component. Each will be unaware that the other is still running. This could cause problems once network connectivity is restored. To prevent this, the nodes become non-operational.

Recommendation—Scenario One

Let’s look at how to resolve the potential problem with the first scenario above, one in which there are conflicting transactions and no tie-breaking vote. The simplest solution is to use Galera Arbitrator. It will be a member of the cluster and thereby participate in voting, but not in the actual replication. It has its own daemon, garbd, separate from the mysqld daemon.

To use Galera Arbitrator, you can either start it at the command-line with a set of options, or use the easier method of a configuration file. You can name this configuration file whatever you want and locate it wherever you want. One possibility is to name it garbd.cnf and put it in the /etc directory, where the database configuration file is located. Below is an example of how the Arbitrator configuration file might look:



You would set the name option to match the value given in the wsrep_cluster_name option in the database configuration file. The address option would match the value given in the wsrep_cluster_address option. The log option is to set the path and name of the log file.

You’ll have to create an identical configuration file on each node, since you won’t know which node is the one that will fail. Using the configuration file, to start the Galera Arbitrator daemon, you would execute something like the following at the command-line:

garbd --cfg /etc/garbd.cnf

This will start the garbd daemon, using the options in the configuration file given. You can add more options to the command-line here. You’ll have to execute this on each node. The garbd daemons will work together as one across the network. If a node in a two-node cluster fails, the surviving node with the garbd daemon will remain operational since the node has the Arbitrator.

Recommendation—Scenario Two

To resolve the potential problem in the second scenario above, instead of using Galera Arbitrator, you can bootstrap the surviving node to form a new Primary Component. You would do this by using the pc.boostrap wsrep Provider option. To do so, log into the node using the mysql client and excute the following SQL statement:

SET GLOBAL wsrep_provider_options='pc.bootstrap=YES';

This will bootstrap the surviving node as a new Primary Component. When the other node comes back online or regains network connectivity with this node, it will recognize that it’s behind and initiate a state transfer to be synchronized.

Another solution, but a bad choice, is to configure the wsrep_provider_options parameter. You would set it to use pc.ignore_sb. This would allow it to continue to operate independently. To do so, you would log into the node with the mysql client and execute the following SQL statement:

SET GLOBAL wsrep_provider_options='pc.ignore_sb=TRUE';

The node will resume processing updates, even if it suspects a split-brain situation. Enabling pc.ignore_sb is dangerous, though, in a multi-master setup due to the risk for split-brain situations. However, it does simplify things in master-slave clusters—especially in situations with only two nodes.