MySQL Forums
Forum List  »  Replication

ndbcluster master -> innodb slave remove NO_ENGINE_SUBSTITUTION not working
Posted by: James Montgomery
Date: September 25, 2013 05:09PM

Hello,

I'm having a problem with create table command where engine=ndbcluster. The innodb replica started without NO_ENGINE_SUBSTITUTION is failing with the error:

[ERROR] Slave SQL: Error 'Unknown storage engine 'ndbcluster'' on query. Default database: 'xxxx'. Query: 'ALTER TABLE `xxxx`.`test4` ENGINE = ndbcluster', Error_code: 1286

I am using the package mcm-1.2.4-cluster-7.3.2-linux-sles11-x86-64bit.tar.gz for the cluster and the innodb replica, and I followed the instructions here to set it up: http://johanandersson.blogspot.com/2012/09/mysql-cluster-to-innodb-replication.html

Any help with this is much appreciated.


2013/10/09 update: I can create the table fine on the replica with my user on workbench with engine=ndbcluster, it just gives a warning. It seems to be the slave 'system user' that isn't respecting the removal of NO_ENGINE_SUBSTITUTION and failing when encountering a create statement with engine=ndbcluster.



Edited 2 time(s). Last edit at 10/09/2013 07:06PM by James Montgomery.

Options: ReplyQuote


Subject
Views
Written By
Posted
ndbcluster master -> innodb slave remove NO_ENGINE_SUBSTITUTION not working
2586
September 25, 2013 05:09PM


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.