-1

We are replicating 1db to other clusters but It is not replicating all the tables. I do not know what is the issue. It always shows replication status synchronized.

2
  • You could look here for a relatively painless way to change all your tables to the InnoDB engine. In MySQL 8, the system tables have been changed from MyISAM to InnoDB.
    – Vérace
    Commented Apr 19, 2018 at 12:49
  • What version of MySQL? Are you using Galera Cluster?
    – Rick James
    Commented May 6, 2018 at 22:53

1 Answer 1

0

Currently replication works only with the InnoDB storage engine. Any writes to tables of other types, including system (mysql.) tables are not replicated (this limitation excludes DDL statements such as CREATE USER, which implicitly modify the mysql. tables — those are replicated). There is however experimental support for MyISAM - see the wsrep_replicate_myisam system variable)

Reference link.

If you are using innodb as default db engine then use innodb with all tables.

It is the possible cause:

ALTER TABLE tableName ENGINE = InnoDB;

You can fix in this way. Run above on master server.

1
  • Caution: This Answer assumes Galera Cluster (PXC) is in use.
    – Rick James
    Commented May 6, 2018 at 22:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.