May 22, 2012

Post: Why MySQL's binlog-do-db option is dangerous

May 14, 2009 By 12 Comments

… see a lot of people filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there are uses for these, they… set disabled = 1 where user = “root”; You just broke replication, twice. Once, because your slave is going to execute the first…

Filed Under: Insight for DBAs Tagged With: ,