On Thu, Apr 16, 2015 at 7:58 AM, Marcel Ruiz Forns <mforns(a)wikimedia.org> wrote:
Here are three valid events that were apparently
inserted correctly, but
don't appear in the db.
http://pastebin.com/8wm6qkkE
(they are performance events and contain no sensitive data)
Thanks. If possible, can we have:
- The exact INSERT statements issued by the MySQL consumer
- The UUID values generated for those records
I followed the master-slave replication lag for some
hours, and perceived a
pattern in the lag: It gets progressively bigger with time, more or less
with a 10 minute increase per hour, reaching lags of 1 to 2 hours. At that
point, the data gap happens and the replication lag goes back to few minutes
lag. I could only catch a data gap "live" 2 times, so that's definitely
not
a conclusive statement. But, there's this hypothesis that the two problems
are related.
Just for clarity, may I ask how are you testing this?
-s