ndbcluster master -> innodb slave remove NO_ENGINE_SUBSTITUTION not working

[James Montgomery]

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.