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.
Asked
Active
Viewed 132 times
-1
-
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 Apr 19 '18 at 12:49
-
What version of MySQL? Are you using Galera Cluster? – Rick James May 06 '18 at 22:53
1 Answers
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.