I have setup replication using mysql utilities. Slave can able to read and execute master's position and binlog files perfectly. seconds_behind_master is also 0. But data is not reflecting into slave. what could be the reason ?
Anybody help e please
Mysql slave status is completely perfect but data is not reflecting
MySQLreplication
Related Question
- MySQL row-based-replication HA_ERR_KEY_NOT_FOUND… which record is it
- Mysqlfailover command – No slave is listed in health status
- Mysql – Unexpected SLAVE STATUS after CHANGE MASTER
- MySQL – Fix Replication Slave Hanging After SET @@SESSION.GTID_NEXT= ‘ANONYMOUS’
- MySQL – Slave Doesn’t Find Binary Log from Slave
- MySQL 5.7 Replication – How to Fix Data Inconsistency When Slave Status is OK
- MySQL thinks Master & Slave have same server-id, but they don’t
Best Answer
Do you use a maria-DB 10 Server with version below 10.0.18? Do your relay-log files contain any transactions? There was a bug which could lead to sich problems.