# MyISAM replication doesn't work?

**URL:** <https://forums.percona.com/t/myisam-replication-doesnt-work/2437>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [June 11, 2012, 7:51am UTC](https://forums.percona.com/t/myisam-replication-doesnt-work/2437 "2012-06-11T07:51:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Os-T](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@Os-T](https://forums.percona.com/u/Os-T)\
**Post date:** [June 11, 2012, 7:51am UTC](https://forums.percona.com/t/myisam-replication-doesnt-work/2437/1 "2012-06-11T07:51:05Z")

</div>

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-](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!

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [June 11, 2012, 11:04am UTC](https://forums.percona.com/t/myisam-replication-doesnt-work/2437/2 "2012-06-11T11:04:56Z")

</div>

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](http://www.percona.com/doc/percona-xtradb-cluster/limitation) .html

---

<div class="post-metadata">

**Author:** ![ayurchen](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@ayurchen](https://forums.percona.com/u/ayurchen)\
**Post date:** [June 11, 2012, 11:14am UTC](https://forums.percona.com/t/myisam-replication-doesnt-work/2437/3 "2012-06-11T11:14:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Os-T](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@Os-T](https://forums.percona.com/u/Os-T)\
**Post date:** [June 12, 2012, 5:00am UTC](https://forums.percona.com/t/myisam-replication-doesnt-work/2437/4 "2012-06-12T05:00:33Z")

</div>

Thanks!  
wsrep\_replicate\_myisam=1 and the data in myisam-tables is available in all nodes!