MyISAM replication doesn't work?

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

I use XtraDB Cluster 5.5.24-23.6 with Ubuntu Lucid.
The release notes for the 5.5.23 Cluster say:
http://www.mysqlperformanceblog.com/2012/05/14/announcement- 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!

2

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.”

http://www.percona.com/doc/percona-xtradb-cluster/limitation .html

3

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.

4

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