MySQL Forums
Forum List  »  InnoDB clusters

Modify MEMORY tables with InnoDB Cluster
Posted by: Juan Ferrer Toribio
Date: March 07, 2019 07:01AM

After setup a single-primary InnoDB Cluster (MySQL 8.0.15), when I try to execute a DML query on a MEMORY table I get the following error in mysql error log:

[ERROR] [MY-011541] [Repl] Plugin group_replication reported: 'Table xxx does not use the InnoDB storage engine. This is not compatible with Group Replication.'

So my questions are,

Is it possible to modify MEMORY tables data in InnoDB Cluster? Is it is a limitation because underlying group replication uses the ROW binary log format?

There is some configuration option to enable writing on MEMORY tables? Even if these queries are not written to the binary log.

Edited 5 time(s). Last edit at 03/07/2019 09:17AM by Juan Ferrer Toribio.

Options: ReplyQuote

Written By
Modify MEMORY tables with InnoDB Cluster
March 07, 2019 07:01AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.