I had a auto-increment duplication issue for master-master replication. Then, I set:
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 99999;
This skips 9999 queries. Then I did:
SHOW SLAVE STATUS\G Slave_IO_Running: Yes Slave_SQL_Running: Yes
And it seems to be running OK.
But, of course, since I skipped 99999 statements...if I make a change on Database 1, it will not reflect it on Database 2...until 99999 statements are passed. Correct?
Well...I created a script to automatically insert 999999 rows into a dummy table. This should be more than enough , right? And my 2 databases should be in sync again???
But, I am on my 3 millionth row, and it doesn't seem to be working. My Database 2 still does not have these 3 million rows that I just created on Database 1.