Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
About the Author
About the Reviewers

Galera Cluster limitations

Galera Cluster has limitations that prevent it from working correctly.


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 disables query cache.

  • XA transactions (global transactions) are not supported.

  • Query logs can't be directed to a table, but can be directed to a file instead.

  • Other less common limitations exist (please refer to the full list if you want to get them...