MyISAM replication doesn't work?

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:
    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. 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


    • #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
        wsrep_replicate_myisam=1 and the data in myisam-tables is available in all nodes!


        • #5
          you can also convert myisam tables into innodb tables