Modify MEMORY tables with InnoDB Cluster
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.
Subject
Views
Written By
Posted
Modify MEMORY tables with InnoDB Cluster
613
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.