I'm foggy on exactly how replication works. Here's my scenario.
Today (April 6th) I realized that our replication slave had an error caused by a failed "CREATE USER" command on March 20. Since then, no replication has happened.
This leaves a six day or so gap where
expire_logs_days would have expired logs on the master, and the slave was not replicating.
I was able to skip the error and get replication going again. It all caught up according to
SHOW SLAVE STATUS\G.
How can I check that things are replicated correctly, beyond "spot checks?" For example, the number of posts on master/slave are identical, that's encouraging.
But when I run, for example, this query on each database, I do not get the same answers:
select count(*) from table where datestamp >= '2016-03-24 00:00:00' AND datestamp <= '2016-03-24 23:59:59';
Should I be concerned that data is missing/incorrect? Is there a reason why the timestamps would be off between databases?
I'd prefer not to have to re-set up the replication, but am prepared to do so.