I am having a problem in mysql replication.
I have a mysql raw data snapshot and my master host have 2 binary logs (binlog.01, binlog.02 - start to log after snapshot was created)
What I want to do is copy raw data snapshot to slave host, execute binlog.01 using mysqlbinlog utility and then at change master to master host point to binlog.02 at the start postion 1.
When slave process the both of binary logs completely, I use mk-table-checksum to check the replication and I get a dozen of inconsistent message.
However, with another method, I try to copy raw data snapshot to slave host again, change master to master host point to binlog.01 at start position 1 - without process any mysqlbinlog command - I realized that I does not get any inconsistent message when using mk-table-checksum anymore.
I want to know that why database is inconsistent when using mysqlbinlog. Please, any help would be appreciated.