MyISAM DDL events are still replicated with wsrep_replicate_myisam OFF

[Raghavendra D Prabhu]

Reporting this based on https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1161432 ,

even when wsrep_replicate_myisam is OFF, MyISAM DDL is still replicated.

[Jay Janssen (jay-janssen)]

Pretty sure ALL DDL is replicated -- not sure this is technically a bug.

[Przemek (pmalkowski)]

Indeed all DDL statements are replicated across the cluster, even ones against non-existing tables. So the DDL replication mechanism not only doesn't check the table engine, but it does not check anything, but passes any DDL statements to all nodes.

Also, the wsrep_replicate_myisam feature was added as MyISAM DML replication feature explicitly, no changes to DDL - https://bugs.launchpad.net/codership-mysql/+bug/986709.

Besides, having DDL (DCL actually) working for MyISAM is also needed for GRANT, CREATE USER, REVOKE, SET PASSWORD, etc.

So I think this is not a bug but rather could be a feature request for making DDL replication more smart.

[Valerii Kravchuk (valerii-kravchuk)]

Confirmed for Wishlist based on last comment.

[Krunal Bauskar (krunal-bauskar)]

I tried replicating MyISAM create table with wsrep_replicate_myisam = off and got following in error log with latest PXC-trunk

2015-11-17 10:20:27 4923 [Note] WSREP: Cannot replicate MyISAM DDL for test.t2 with wsrep_replicate_myisam OFF

Which looks inline with behavior. Wil mark this bug as FIX_COMMITTED.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1063