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

Ashfaq Muhammad
  • 99

1 Answers1

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.

Ashfaq Muhammad
  • 99