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 ...

Get Mastering MariaDB now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.