# Percona XtraDB Cluster 5.7 and Storage Engine 'Memory' **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [April 11, 2023, 8:45am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323 "2023-04-11T08:45:59Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![soprano](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soprano](https://forums.percona.com/u/soprano)\ **Post date:** [April 11, 2023, 8:45am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/1 "2023-04-11T08:45:59Z")
Hi all, i would like to know if Storage Engine MEMORY is working with the percona xtraDB Cluster 5.7 master-master replication. I ask this because i have problems with a joomla installation when it try to execute some modifies on table, the error is “unknown storage engine ‘MEMORY’” my default\_storage\_engine is innodb and i force the storage engine to be innodb fron configuration: default\_storage\_engine = InnoDB enforce\_storage\_engine = InnoDB thanks for any advice or hint Claudio ---
**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\ **Post date:** [April 11, 2023, 8:52am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/2 "2023-04-11T08:52:57Z")
No. The Engine memory is not supported in any xtradb cluster configuration. It doesn’t matter whether it is with multiple nodes accepting writes or one writer. The problem with memory engine is that it provides no persistence. This means that the table contents disappear when the node is rebooted. ---
**Author:** ![soprano](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soprano](https://forums.percona.com/u/soprano)\ **Post date:** [April 11, 2023, 9:18am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/3 "2023-04-11T09:18:12Z")
Ok thanks for the answer, i can’t understand why joomla use it, but this is not a percona problem ---
**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\ **Post date:** [April 11, 2023, 9:25am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/4 "2023-04-11T09:25:07Z")
Some applications use memory engine for performance considerations. But very often you can use innodb engine. Try changing the table to InnoDB and verify that the performance impact is reduced. But you must make sure that joomla support properly XtraDB Cluster. There are other things that must be taken into consideration. If possible, avoid master-master configurations (unless applications are using separate databases). ---
**Author:** ![soprano](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soprano](https://forums.percona.com/u/soprano)\ **Post date:** [April 11, 2023, 12:03pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/5 "2023-04-11T12:03:21Z")
if i use SHOW TABLE STATUS; i get ONLY innodb in the Engine column, so all the tables are innodb, could be that in the UPDATE is used a memory engine rule ? Each application use a different DB, we use percona xtradb cluster from several years without problems, also with joomla, but this new version 4.x seems to arise this problem. Claudio ---
**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\ **Post date:** [April 11, 2023, 4:05pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/6 "2023-04-11T16:05:25Z")
I’m sorry, but we can’t provide you with help for Joomla. If you have a testing environment, I suggest running the update on a standalone server (no pxc) and verifying if other engines than InnoDB are used in the new version. I made a simple search and looks like some components require the MEMORY engine, but I don’t know if this is your case. ---
**Author:** ![soprano](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soprano](https://forums.percona.com/u/soprano)\ **Post date:** [April 12, 2023, 10:53am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/7 "2023-04-12T10:53:45Z")
Ok i understand that percona is not supporting this type of engine but if i check mysql\> show engines; ±-------------------±--------±---------------------------------------------------------------------------±-------------±-----±-----------+ | Engine | Support | Comment | Transactions | XA | Savepoints | ±-------------------±--------±---------------------------------------------------------------------------±-------------±-----±-----------+ | MRG\_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | PERFORMANCE\_SCHEMA | YES | Performance Schema | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | ±-------------------±--------±---------------------------------------------------------------------------±-------------±-----±-----------+ 9 rows in set (0.00 sec) it tells that it is supported instead Why ? Claudio ---
**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\ **Post date:** [April 12, 2023, 11:06am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/8 "2023-04-12T11:06:43Z")
This is a bit complex. When you run the XtraDB Cluster version, you are running standard MySQL with some extensions that control the clustering. You can start the node with clustering disabled. The Memory engine is supported by the standard component (linked and enabled by default) but is incompatible with the clustering component. There are two reasons for this engine not to be compatible with the clustering component: - It is not transactional. - It provides no durability. Clustering requires the possibility of rolling back a transaction if there is a consistency issue. As memory is not transactional, it is impossible to roll back the changes. This would break the cluster and make it inconsistent. Pep ---
**Author:** ![soprano](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@soprano](https://forums.percona.com/u/soprano)\ **Post date:** [April 12, 2023, 12:51pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/9 "2023-04-12T12:51:20Z")
Is possible for XtraDB to check the show engines command and show Support = NO in the engine list ? Else if some application check for the available engine using mysql standard commands it will think that engine is supported and permitted, then when it will use that engine the clustering will answer with unknown storage engine ‘MEMORY’. Or is there a way to know using a query which engines are actually supported by the cluster ? Claudio ---
**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\ **Post date:** [April 12, 2023, 12:58pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/10 "2023-04-12T12:58:37Z")
InnoDB is the only fully supported engine so far. ---
**Author:** ![pbirch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pbirch/32/2865_2.png) [@pbirch](https://forums.percona.com/u/pbirch)\ **Post date:** [April 13, 2023, 4:09pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-and-storage-engine-memory/21323/11 "2023-04-13T16:09:18Z")
Replication works only with InnoDB storage engine. [Percona XtraDB Cluster Limitations](https://docs.percona.com/percona-xtradb-cluster/5.7/limitation.html)