Not the answer you need?
Register and ask your own question!

MyISAM replication doesn't work?

Os-TOs-T EntrantInactive User Role Beginner
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</pre>

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!

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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. However, DDL statements are replicated in statement level, and changes to mysql.* tables will get replicated that way. 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
  • ayurchenayurchen Contributor Inactive User Role Beginner
    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.
  • Os-TOs-T Entrant Inactive User Role Beginner
    Thanks!
    wsrep_replicate_myisam=1 and the data in myisam-tables is available in all nodes!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.