The Library

Frequently Asked Questions

This page lists several frequently asked questions on Galera Cluster and related matters. They include questions you might have before deciding to use Galera. There are some questions on how to install and migrate to Galera, as well as how to get assistance and learn about Galera.

The questions are grouped by a few categories:

Just below each question is further categorization of the question: the minimum experience level of the person who might be interested—if you are new to database clusters, you might want to skip the Intermediate ones; and the type of person who might be interested in such a question (for example, DBAs, business managers).

_images/training1.jpg

What is Galera Cluster?

Level: Intermediate; Interested: DBAs; Category: General

Galera Cluster is a write-set replication service provider in the form of the dlopenable library. It provides synchronous replication and supports multi-primary replication. Galera Cluster is capable of unconstrained parallel applying (that is, “parallel replication”), multicast replication and automatic node provisioning.

The primary focus of Galera Cluster is data consistency. Transactions are either applied to every node or not at all. Galera Cluster is not a cluster manager, a load balancer, or a cluster monitor. What it does is keep databases synchronized, provided they were properly configured and synchronized in the beginning.

Why use Galera Cluster instead of Basic MySQL Replication?

Level: Newcomer; Interested: DBAs, Business Managers; Category: General

Galera Cluster uses a multi-primary method of replication. It allows you to write to any node in a cluster; writes on any node are synchronized to all nodes. Standard MySQL replication uses one primary and multiple replicas: although you can read data from any node, you can write only on the primary.

With Galera and multi-primary replication, any write is either committed to all nodes in the cluster, or rolled back. With standard MySQL and primary-replicas replication, writes to the primary might not be synchronized to one or more replica, but users could continue to read from an out-of-sync replica.

With Galera, if one primary fails, the cluster continues and users can continue to write and read on other nodes. With standard MySQL replication, if the primary fails, users cannot write until it is restored or replaced - which can involve manual intervention and take good bit of time.

Can Galera be used with AWS (Amazon Web Services)?

Level: Newcomer, Intermediate; Interested: DBAs, Business Managers; Category: General

Yes, it works just fine. Through Amazon’s EC2 environment, you can create multiple instances, virtual servers running the Linux operating system–any distribution is fine. After the instances are created, you would log into each instance and install MySQL or MariaDB and Galera, as well as configure them. On AWS, you will have to set inbound security rules to allow the instances to communicate with each.

For more details on installing Galera, see Installing Galera.

How much does Galera Software Cost?

Level: Newcomer; Interested: Business Managers; Category: General

Galera Cluster software is free to download and use, along with MySQL and MariaDB software for the database component of a cluster. There are no licensing fees.

The only expense might be the cost of personnel who are in charge of managing a cluster. You might also decide to engage Codership to provide support (see Question on Support).

Which Large Organizations are using Galera Cluster?

Level: All; Interested: DBAs, Business Managers; Category: General

Since 2009, there are thousands of Galera Cluster users and over 1.5 million downloads. Enterprises choose Galera Cluster because it provides most robust solution against data loss, MySQL and MariaDB high availability and scalability.

Because of client confidentiality, we can’t name the largest organizations that are using Galera, but there are a few that have agreed to endorsing us. Check out our References page for just a few.

How can I Try Galera to see if I Like It?

Level: All; Interested: DBAs; Category: General

Since the software is free, it costs you only a little bit of time to try the software. To start, you might want to set up three new servers to be part of a cluster. If you have an account with Amazon’s AWS, you could create three instances in there system, just for testing Galera. See the Question on Using AWS.

If you want to see how well it performs, you might copy your existing databases to your test cluster. See Data Migration for more details on how you might do that. You can also use a benchmark tool like, sysbench (see How to Benchmark Performance) to test Galera.

How Popular is Galera Cluster? Will I be able to Find People we Need?

Level: All; Interested: Business Managers; Category: Training

Galera Cluster is becoming de-facto-standard for MySQL high availability and scalability solution. In 2016, Galera Cluster downloads passed over 1,000,000.

Major companies all over the world have implemented Galera to protect their data and secure their application and service availability. Galera Cluster is included in Debian Linux distributions and it is the most used high-availability solution for OpenStack Cloud platform, according to their survey.

How can I or my Staff Learn to Configure and Use Galera?

Level: All; Interested: DBAs, Business Managers; Category: Learning

The Galera Cluster Documentation is the best source for detailed information on Galera. It includes a guide for Getting Started Guide. Several members of the Galera staff occasionally make presentations at conferences around the globe.

For comprehensive training courses on Galera and related software (for example, load balancers), check the web sites of our partners (for example, MariaDB, FromDual, Severalnines). For a list of all of them, along with links to their sites, see the Support Partners

What Skills should I or my Staff have Before Learning Galera?

Level: Newcomer, Intermediate; Interested: DBAs; Category: Learning

At a minimum, you should know well a relational database system. In particular, advanced knowledge of MySQL or MariaDB would be best. This is because Galera is an extension of these relational database systems.

Since Galera uses only the InnoDB tables, knowing how get the most of the InnoDB storage engine will server you well when resolving problems that may occur with transactions and when tweaking a database for better performance.

Lastly, experience using standard MySQL Replication would make learning Galera Cluster easy. Galera Cluster is similar, but much better.

Which of our Staff should be Experts on Galera?

Level: All; Interested: DBAs, Business Managers; Category: Training

Since end-users won’t do anything different from what they already do when adding and changing data in the database, there’s nothing new for them to know. As for database developers, they mostly need to be aware that they can use only InnoDB tables. They can’t use other storage engines. If they do not already, they might want to learn about the features of InnoDB so they can take advantage of them (for example, transactions).

Using Galera Cluster will very much be in the purview of DBAs. They need to know how to create a Galera Cluster, how to add and remove nodes from a cluster. Most importantly, they need to be able to restart a cluster properly so data isn’t at risk.

Galera Cluster isn’t difficult to maintain, but your DBAs need to know the software well and be confident in their abilities to resolve problems that might occur to be able to ensure high availability of your databases, the consistency and durability of the data. For critical situations, though, you might do well to have a support contract with us at Codership (see Question on Support).

Are there Tutorial Articles Written about Galera?

Level: Newcomer, Intermediate; Interested: DBAs; Category: Learning

You can find many articles on Galera and related software on our blog. These are mixed in with information on conferences and press releases, so you will have to scroll through the list of articles. Some of our partners regularly publish articles on various aspects of Galera: MariaDB, Severalnines, and FromDual Articles.

Do Developers and others Users Need to Know Anything about Galera?

Level: All; Interested: DBAs, Business Managers; Category: Training

In a way, Galera is a behind-the-scene feature. It is seamless and very much hidden from users. A developer may access any node in a Galera cluster to change table schemata.

Developers just need to be mindful to use only InnoDB tables. You can guard against this by setting the --default-storage-engine option and enforce_storage_engine to InnoDB. Be sure to disable enforce_storage_engine, though, when upgrading the database software.

Users would insert or change data in a database in the same as they would on a stand-alone database server not using Galera or replication. There is no extra login requirements, interfaces, or methods to use a database running on Galera Cluster. Users will be unaware that you are using Galera Cluster—other than maybe noticing that your database is much more dependable.

Does Codership Offer Support?

Level: All; Interested: DBAs, Business Managers; Category: Support

Codership offers 8/5 and 24/7 support to keep your Galera Cluster installation running. Our support staff includes the core developers of Galera technology. As a result, we’re able to pinpoint and resolve problems, quickly and efficiently.

Annual Galera support subscription include:

  • Unlimited support tickets;
  • Hot bug fixes;
  • Security releases;
  • New Releases of the software;
  • Contact by email, Skype or telephone;
  • Remote system login;
  • Named support contacts (Galera developers):
  • Zendesk support portal and ticket management; and
  • 8-hour response time for 8/5, 4-hour response time for 24/7

For a quote on the cost of support, write us at info@codership.com or use our on-line form to send us a message.

You can also engage one of our Support Partners. We are very particular as to who we allow to become one of our Support Partner: they’re well qualified, very responsive, and dependable.

Is it Possible to get Codership to Assist Us in Migrating to Galera?

Level: All; Interested: DBAs, Business Managers; Category: Consulting

Yes, we can help you remotely or in person. Our staff at Galera have years of hands-on experience with database replication and clustering, both in development and management. Putting our expertise to use will help you to avoid trial and error, save you time and money, as well as help you to make the right choices for your project. We’re available for both short-term and long-term consulting projects

Consulting is usually done remotely. However, if you require in-person, on-site work, there will be extra charges (such as travel and accommodation expenses).

Are there Forums for Asking for Assistance with Galera?

Level: Newcomers; Interested: DBAs; Category: Assistance

There are a few forums on Galera and related software. On these forums, you can post questions to the community. It may take a little time, but you will usually receive responses to your posts.

We have a forum in which the community, as well as our staff monitor and post responses: Codership Forum. Some of our partners maintain forums on Galera: FromDual Forum.

You can also post questions on forums unaffiliated with Codership or our partners: Stack Exchange (DBA Section), Stack Overflow,

If I’m now using MySQL Standard Replication, will it be Easy to Switch to Galera?

Level: Newcomer; Interested: DBAs; Category: Installation

It is potentially easy. There are a few things to consider, changes you may need to make.

First, you will have to migrate all of your tables to InnoDB. Although MySQL and MariaDB offer multiple storage engines, Galera only allows InnoDB tables. You’ll also have to address how changing to InnoDB will affect your applications.

Next, you should also migrate each server to the same version of MySQL or MariaDB, and to the latest versions. This may affect the schema of your tables, as well as your data and applications.

Last, you may want to make some changes to your hardware. For one, if you have only two servers, you should add a third. Although it is not necessary, it is recommended that all servers used be the same or fairly equal in resources.

Basically, if you are already using the latest database software and only InnoDB tables, implementing Galera will be very easy. Otherwise, implementing Galera will require some thought and effort. However, the result will mean a much better cluster: all servers will be the same for easier maintenance and better performance; they’ll be running the latest software, which will provide advantages; and the data will be better protected and will have high availability.

How are Upgrades Made to a Cluster?

Level: Intermediate; Interested: DBAs; Category: Upgrading

Periodically, updates will become available for Galera Cluster–for the database server itself or the Galera Replication Plugin. To update the software for a node, you would redirect client connections away from it and then stop the node. Then upgrade the node’s software. When finished, just restart the node.

For more information on upgrade process, see Upgrading Galera Cluster.

Do we have to Adjust our Databases or Custom Applications (for example, PHP Programs)?

Level: Intermediate; Interested: DBAs, Developers; Category: Migrating

If you are already using MySQL or MariaDB, along with some custom applications—such as programs written in PHP, Perl, Ruby, or another language, that interface with your databases—you shouldn’t have to make any changes to your software.

If you are currently using standard MySQL Replication, and your applications connect with specific nodes for writes and others for reads, you probably won’t have to do that. Instead, you can write and read to the same nodes. As for load balancing, you could add a load balancer like MaxScale and then direct all traffic to the load balancer and it will direct the traffic for the best performance.

Is Galera Installed Separately from the Database Software?

Level: Newcomer; Interested: DBAs; Category: Installation

Starting with version 10.4 of MariaDB, Galera software is included in the server installation. See the Installing MariaDB Galera Cluster related to installing Galera, version 4. Previous version of MariaDB did require you to install separately Galera. The same document will explain this.

If you’d prefer to use MySQL, see Installing MySQL Galera Cluster for information on how to install MySQL and Galera software. Galera is not yet incorporated into MySQL.

What’s the Minimum and Maximum Number of Servers in a Galera Cluster?

Level: Newcomer; Interested: DBAs; Category: Installation

The minimum number of nodes required for a cluster is two. However, a minimum of three nodes is recommend. In a two-node cluster, if one node fails or is taken down for maintenance, the other node will stop since another node is required. There is a work around for two-node cluster issues: see Two-Node Clusters.

As for the maximum number of nodes, there is none. However, a single cluster in excessive of ten nodes may experience lag from the synchronizing of so many nodes across a network or the internet. This can be mitigated based on your network configuration, but then other factors come into play.

What Type of Server or Equipment is Recommended for a Galera Cluster?

Level: Newcomer; Interested: DBAs; Category: Installation

Galera runs only on Linux and similar Unix-like operating systems. Physically, any server on which Linux can be installed, may be used as a node in a Galera cluster. Galera and the storage engine, InnoDB make good use of RAM and Swap Space. So, the more memory you can allocate, the better. Since a cluster runs across a network, get the fastest, best ethernet cards you can get.

The best equipment you can afford to buy, the better. If you are using virtual servers like those through Amazon’s AWS, you do not need to be concerned about most of these equipment factors. You will just need to allow your servers enough memory and storage space.

However you build your server nodes, it is best that they be equal in all ways: physical and virtual equipment; operating system configuration; software installation.

Does Galera Balance Loads?

Level: Advanced; Interested: DBAs; Category: Performance

For high-traffic clusters, to prevent one node from being overwhelmed with write and read queries, you may want to use a load balancer. Galera Cluster does not include this feature. However, we could use MariaDB’s MaxScale, ProxySQL, or some other such load balancer.

MaxScale is a database proxy that can extend the high availability, scalability, and security of your database server and cluster. It also simplifies application development by decoupling it from underlying database infrastructure. It will work with both MariaDB and MySQL.

How are Failovers Managed?

Level: Advanced; Interested: DBAs; Category: Maintenance

Galera Cluster is a true synchronous multi-primary replication system, which allows the use of any or all of the nodes as primary at any time without any extra provisioning. What this means is that there is no failover in the traditional MySQL primary-replica sense.

The primary focus of Galera Cluster is data consistency across the nodes. This does not allow for any modifications to the database that may compromise consistency. For instance, the node rejects write requests until the joining node synchronizes with the cluster and is ready to process requests.

The results of this is that you can safely use your favorite approach to distribute or migrate connections between the nodes without the risk of causing inconsistency.

For more information on connection distribution, see Deployment Variants.

Are making Back-ups of Databases Difficult?

Level: Intermediate; Interested: DBAs; Category: Maintenance

Making a backup of the databases in a Galera cluster is easy and simple. One simple method would be to remove one node from the cluster–without shutting down the mysqld daemon. From there, you can use mysqldump to make a logical backup, or whatever backup software you prefer. It will have little or no effect on overall performance of the cluster. When you are finished, simply reconnect the node to the cluster. The other nodes will quickly provide what’s needed for it to be insync with the cluster. For more information on using mysqldump with Galera, see mysqldump.

The problem with such a simple backup method, though, is that it lacks a Global Transaction ID (GTID). You can use backups of this kind to recover data, but they are insufficient for use in recovering nodes to a well-defined state. Plus, some backup procedures can block cluster operations during the backup.

Including the GTID in a backup requires a different approach. To do this, you can invoke a backup through the state snapshot transfer mechanism. For more information on this method, see Backing Up Cluster Data.

Which InnoDB Isolation Levels does Galera Cluster Support?

Level: Advanced; Interested: DBAs; Category: Performance

You can use all isolation levels. Locally, in a given node, transaction isolation works as it does natively with InnoDB.

The SERIALIZABLE level cannot be guaranteed in the multi-primary use case because Galera Cluster Replication does not carry a transaction read set. Also, SERIALIZABLE transaction is vulnerable to cluster wide conflicts. It holds read locks and any replicated write to read locked row will cause the transaction to abort. Hence, it is recommended not to use it in Galera Cluster.

For more information, see Isolation Levels.

How are DDL’s Handled by Galera?

Level: Advanced; Interested: DBAs; Category: Maintenance

For DDL statements and similar queries, Galera Cluster has two modes of execution:

  • Total Order Isolation: A query is replicated in a statement before executing on the primary. The node waits for all preceding transactions to commit and then all nodes simultaneously execute the transaction in isolation.
  • Rolling Schema Upgrade: Schema upgrades run locally, blocking only the node on which they are run. The changes do not replicate to the rest of the cluster.

For more information, see Schema Upgrades.

Is GCache a Binary Log?

Level: Advanced; Interested: DBAs; Category: Performance

The Write-set Cache, which is also called GCache, is a memory allocator for write-sets. Its primary purpose is to minimize the write-set footprint in RAM. It is not a log of events, but rather a cache.

  • GCache is not persistent.
  • Not every entry in GCache is a write-set.
  • Not every write-set in GCache will be committed.
  • Write-sets in GCache are not allocated in commit order.
  • Write-sets are not an optimal entry for the binlog, since they contain extra information.

Nevertheless, it is possible to construct a binlog out of the write-set cache.

Should the Binary Log be Enabled with Galera?

Level: Intermediate; Interested: DBAs; Category: Maintenance

Standard MySQL replication uses the binary log for replicating. However, Galera does not use the binary log. Nevertheless, there may be situations in which you might want to use point-in-time recovery methods to restore tables or data since the last backup.

You might also want to attach an asynchronous replica to one of your nodes, using standard MySQL replication and set it on a delay, using time delayed replication (present in MySQL and MariaDB Server). This can also help with recovering tables and data lost since the last backup was made.

What typically Causes a Cluster to Stop?

Level: Intermediate; Interested: DBAs, Business Managers; Category: Maintenance

Although it does not happen often, there are several reasons a Galera Cluster might crash. Below is a list of them, grouped by type of cause:

Physical Server & Related Causes

  • The nodes are out of disk space;
  • The operating systems are swapping or have a high I/O Wait

Storage Engine Causes

  • The InnoDB storage engine crashes;
  • Using MyISAM tables, which is still experimental;
  • Creating or dropping tables that do not have a primary key

Configuration Problems

  • Incompatible Changes to Parameters in the MySQL Configuration File;
  • Setting binlog_format to only MIXED, instead of ROW. Only ROW format is supported.

Galera in General

  • Excessive deadlocks during heavy load when writing the same set of rows;
  • There isn’t a Primary Component;
  • The cluster is out of quorum;
  • A bug with Galera software

What are the Limitations of Galera?

Level: Intermediate; Interested: DBAs, Business Managers; Category: Maintenance

Galera Cluster is a superb replication system when using MySQL or MariaDB for your databases. However, it does have some limits for which you may want to be aware before migrating to it.

First, it runs only on Linux and Unix-like operating systems. There isn’t a Windows version. Within the database server, other than the system tables, which use MyISAM, only InnoDB tables are allowed. InnoDB is used because it is an excellent transactional storage engine. All tables must have an explicit primary key, either a single or a multi-column index.

For more details on limitations, see Differences from a Stand-Alone MySQL Server.

Does the Slowest Node Affect the Performance of Other Nodes?

Level: Intermediate; Interested: DBAs; Category: Performance

Integral to Galera Cluster replication, the cluster will wait for all of the nodes in the cluster to return the status of certification test before committing transactions or rolling them back. Because of this, a node that is inundated with traffic will delay that node from replying to the cluster and delay the other nodes as they wait for it to report.

To alleviate this problem, you would make sure that all of the servers the same physically (that is, amount of RAM, types of network interfaces), or at least have close the same amount of resources available. You would also use a load balancer (for example, MariaDB MaxScale, ProxySQL) to make sure one node is not overloaded with traffic.

Why is the Software Called Galera?

Level: Newcomer; Interested: DBAs, Business Managers; Category: Background

The word galera is the Italian word for galley. The galley is a class of naval vessel used in the Mediterranean Sea from the second millennium B.C.E. until the Renaissance. Although it used sails when the winds were favorable, its principal method of propulsion came from banks of oars.

In order to manage the vessel effectively, rowers had to act synchronously, lest the oars become intertwined and became blocked. Captains could scale the crew up to hundreds of rowers, making the galleys faster and more maneuverable in combat.

For more information on galleys, see Wikipedia.

How is Galera Licensed and is it Open-Source?

Level: Newcomer; Interested: DBAs, Business Managers; Category: Background

The Galera software is licensed under the GNU General Public License, version 2 (see GPL vs. 2). It is open-source software, which can be found at GitHub (see Codership Github).

How did Galera Start?

Level: Newcomer; Interested: DBAs, Business Managers; Category: Background

Having worked for years with databases and with data clustering environments, the founders all knew each other. Every now and then they would meet and talk about the technology, about their work. In particular, they discussed the shortcomings and pitfalls of the existing solutions available.

During these discussions, one thing became apparent: They all shared a need to produce something better, something that ”just works”. In May 2007, they released Galera Cluster for MySQL, their new, fast and scalable data replication and clustering solution for open source databases.

Who Owns and Develops Galera Software?

Level: Newcomer; Interested: DBAs, Business Managers; Category: Background

Galera Cluster software is the intellectural property of Codership Oy of Finland. The primary owners of Codership are actively involved in the executive management and development of the software. For more information on copyrights and other legal aspects, see Legal Notice.