MySQL Replication issues
I might sound clue less here as i am :) , I am having problem with mysql replication, i.e. replication seems to be missing in some random occasion.
My structure looks like:
1) Master 2) slave (without SSL) 3) Slave (with SSL)
what goes wrong is in some occasion, data are not replicated to slave. First my question, was if i someone is updating slaves. And i took off all privilege from all user other than read. which itself contradicts because both slave are not replicated and user's do not have permision on both slave.
binlog-ignore-db = mysql binlog-ignore-db = test replicate-ignore-db = mysql replicate-ignore-db = test
Manual Test: I created new database, created table, new filed all was replicated to both slave. Updated works, altered works and delete works.
But in some occasion when it misses out randomly i am unable to troubleshoot or narrow down problem area.
FYI, dont have skip-error in place.