New Questions for the FAQ

This page is where we record ideas for new Frequently Asked Questions (i.e., the FAQ). The questions are entered here, perhaps in rough form, in the same categories of the FAQ. We will answer that later, when we have more time or more information.

If you have any suggestions for new FAQs, please email us at library@galeracluster.com.

General Questions

In simple terms, what is Galera?

Level: Intermediate; Interested: DBAs; Category: General

A plugin that allows synchronous multi-master replication for InnoDB tables. It works differently from the standard MySQL replication, which provides Master and Slave structure. The Galera Cluster replication is able to manage true parallel read and write to any cluster node, managing conflicts using a Global Transaction ID mechanism.

Is Galera Cluster difficult to install, configure, use, and maintain?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Advantages & Disadvantages of Galera?

Level: Intermediate; Interested: DBAs; Category: General

Among the advantages: synchronous data replication across all nodes; scalability; high availability; auto failover with the database serving requests as long as one node remains active; all nodes are masters so you could read/write on any node. On the other hand there are some limitations to be considered: the replica provided by Galera Cluster currently is available only for InnoDB tables; it does not support explicit lock tables statement (LOCK TABLES, FLUSH TABLES); all tables must have a primary key in order to replicate correctly the DELETE queries and get the same display order for the SELECT queries on all nodes; you will notice an increase in latency for write transactions linearly with the increase of the number of nodes. However there are solutions to minimize the effects of these limitations.

How Synchronous is Galera Cluster?

Level: Intermediate; Interested: DBAs; Category: General

Some answer. (see https://stackoverflow.com/questions/49430029)

Learning & Training Questions

Are there on-line videos, screencasts or webinars in which I can learn about Galera?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Assistance Questions

No new questions in this category.

Installation & Migration

Which database software will work with Galera? Are they only relational database system, or will a NoSQL system function with Galera?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Usage Questions

How do I make a backup, and will it effect performance?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Can nodes for a Galera Cluster be installed in containers such as Docker and how would they interact with each other?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

What kind of organization would use Galera Cluster? What size and type?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Why three nodes?

Level: Intermediate; Interested: DBAs; Category: General

To prevent a peculiar condition called split-brain. Galera Cluster uses a “quorum” mechanism every time suspects a problem on a node and so decide whether or not to exclude it from the cluster. In a 2-node cluster there would not be the majority to make these kinds of decisions. Moreover if a node is excluded, on his return on the cluster, another node may not be available to transfer data because it is busy with an another data alignment. Whereas two of the members are involved in this operation, the presence of the third continues to serve client requests.

What is SST and IST?

Level: Intermediate; Interested: DBAs; Category: General

There are two different way to get data replica. The State Snapshot Transfer is used to replicate the entire database, e.g. when you add a node to the cluster for the first time. The Incremental State Transfer is used to align smaller portions of the database and uses an internal caching mechanism. After the first State Snapshot Transfer, Galera Cluster prefers to use Incremental State Transfer because it is faster.

Administrative Questions

What if I decide I don’t like Galera and want to migrate to something else?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

How stable is Galera? Does it fail easily?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Is there a method by which I can be notified of nodes failing, of the entire cluster down?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Is it difficult to add a new node to a cluster? How much trouble is it to take a node down for maintenance and then rejoin the cluster?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

What’s involved in start a cluster after it’s been down?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

How are nodes that were temporarily off-line caught up with the cluster? How are new nodes jump started? (IST, SST, rsync)?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.

Galera Trivia

Why is Codership, the maker of Galera based in Finland? Why are so many software companies and programmers from Scandinavia?

Level: Intermediate; Interested: DBAs; Category: General

Some answer.