Galera states that it only supports InnoDB. The reason is quite clear, and it is related with the way synchronous replication is implemented in Galera.
However, some storage engines are just "bridges", or they do (almost) nothing. Can anyone tell me which of these storage engines can realiably be used in Galera?
- OQGRAPH (referencing an InnoDB table)
- Mroonga (referencing an InnoDB table)
- CONNECT (TABLE_TYPE = PROXY, referencing InnoDB table)
- CassandraSE
- SphinxSE
- BLACKHOLE
- SEQUENCE
Best Answer
Galera replicates DDL statements so other storage engines that act as a proxy to InnoDB tables or external systems should work normally. The tables aren't really replicated but they would be created on each node when they are created on any node.
OQGRAPH - I saw you asking about it on the MariaDB site and as the consensus is there, theoretically it should work since the data is stored in InnoDB tables and would be replicated but it's not a common use case and you'll need to do some testing on your own.
Mroonga - same as OQGRAPH
CONNECT - This should be the same as OQGRAPH.
CassandraSE and SphinxSE - since the only information these engines use from MySQL is created with DDL statements, they should work fine.
BLACKHOLE - These are just normal tables that don't have any data to replicate so there shouldn't be any problems.
SEQUENCE - The SEQUENCE engine doesn't create any tables and is triggered by the names of tables in a query so these should work fine anywhere as long as the plugin is loaded on the server that is being queried.