Tables Cannot Sync Among Galera Clustering Nodes

Comments

3 comments

  • Avatar
    testjetco

    There is already a 2-node cluster in SIT, MariaDB version 10.3.10.  Galera clustering was adopted.

    After installation and cluster up and running, we don't stop it.  Yesterday, I have checked all the tables' row count.  Some tables are sync with same no. of records between the two nodes, but some are not! 

  • Avatar
    testjetco

    The issue is caused by db engine.  Some tables were defined as MyISAM, which is not compatible with Galera clustering.  After changing them to InnoDB, clustering sync works.

  • Avatar
    testjetco

    For tables not sync issue in SIT, it was caused by the same reason.  Some tables were defined as MyISAM at the very beginning.  Then ppl performed transactions.  Later we discovered that the engine we used was wrong.  Then we updated the engine to InnoDB.  So row counts were not matched among nodes. 

    Now all the tables are InnoDB.  And we sync them again.  Keep monitoring and see whether there are discrepanies.

Please sign in to leave a comment.

Powered by Zendesk