MyISAM replication doesn't work?


I use XtraDB Cluster 5.5.24-23.6 with Ubuntu Lucid.
The release notes for the 5.5.23 Cluster say: of-percona-xtradb-cluster-5-5-23/

Support for MyISAM, now changes to MyISAM tables are replicated to other nodes

But after an import of some MyISAM-tables no contents of these tables will be available on the other nodes. InnoDB works without any problems.

Is there something I am missing? Or is the release note saying “structural changes to myisam will be replicated, but no content”?

Thanks for any hint!

According to the documentation, it sounds like that is working as expected. Note I have never used this, so just relaying what the documentation says:

“Currently replication works only with InnoDB storage engine. Any writes to tables of other types, including system (mysql.) tables, are not replicated. [B]However, DDL statements are replicated in statement level, and changes to mysql. tables will get replicated that way.[/B] So, you can safely issue: CREATE USER…, but issuing: INSERT INTO mysql.user…, will not be replicated.” .html

You need to enable wsrep_replicate_myisam option. Note that MyISAM support is still experimental, in particular use of non-deterministic functions may cause inconsistency.

wsrep_replicate_myisam=1 and the data in myisam-tables is available in all nodes!