Galera Cluster limitations

Galera Cluster has limitations that prevent it from working correctly.

Tip

Do not go live in production if you haven't checked that your application is in compliance with the limitations listed.

The following are the limitations:

  • Galera Cluster only fully supports InnoDB tables. TokuDB is planned but not yet available and MyISAM is partially supported.
  • Galera Cluster uses primary keys on all your tables (mandatory) to avoid different query execution orders between all your nodes. If you do not do it on your own, Galera will create one. The delete operation is not supported on the tables without primary keys.
  • Locking/unlocking tables and lock functions are not supported. They will be ignored if you try to use them.
  • Galera Cluster ...

Get MariaDB High Performance 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.