Listing the limitations of Galera Cluster

MariaDB Galera Cluster has several limitations by design. The developers and the DBA should be aware that some of the features provided by standalone MariaDB servers are not available for the Galera nodes.

First, as we mentioned earlier, Linux is the only operating system supported by Galera.

Galera is designed to be used with the InnoDB storage engine. An experimental support for MyISAM is available but disabled by default. To enable it, the wsrep_replicate_myisam server variable must be set to 1. The Galera team discourages its use in production environments. No other storage engines can be used with Galera.

The binary log must be enabled and its format must be ROW. Statement-based or mixed replication isn't supported.

Statements that acquire explicit locks, such as SELECT … FOR UPDATE, SELECT … LOCK IN SHARE MODE, LOCK TABLES, or FLUSH TABLES … FOR EXPORT are not supported. This makes the use of MyISAM even less desirable. The SERIALIZABLE isolation...