… 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…. The other configuration options I mentioned work similarly. The binlog-do-db and binlog-ignore-db statements are particularly dangerous because they keep statements from…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-bin.index binlog-ignore-db=chrome_vin binlog-ignore-db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog-ignore-db=us_incentives_extract #binlog-ignore-db=vehicles #binlog-ignore-db=voiceshot…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog… Com_alter_db_upgradeblogpercona.commanual …
Comment: Why MySQL's binlog-do-db option is dangerous
July 24, 2012 By 15 Comments
… where binlog_do_db and binlog_ignore_db do not appear as advertized in the manual. The mysql config file has: binlog_do_db=mydb binlog_ignore_db=mysql binlog_ignore_db=test…’ does not match any of the binlog_do_db configs in the original setup so then the ignore_db rules are matched. Since none…
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
… mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 956920476 -rw-rw—- 1 mysql mysql 956920476… mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 957115478 -rw-rw—- 1 mysql mysql 957115478…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… binlog-do-db and binlog-ignore-db commands. This is there a lot of people stop reading documentation, specify databases they want to replicate (or ignore… the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do-* counterparts and which are…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000002 | 544 | | | +——————+———-+————–+——————+ error log (snipped): InnoDB: In a MySQL replication slave the last master binlog file InnoDB…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) If you’re…_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog_do_db=newcrmdb binlog-ignore-db=mysql,test #replicate_do_db=crmdb #replicate_do_db=newcrmdb #auto-increment-increment…-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog events in ‘mysql-bin.000007…’s see what’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name…
