… filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there … you do the following: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production…database is to configure replicate-wild-ignore-table=garbage.%. There are…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…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…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… On the Master you can do filtering using binlog-do-db and binlog-ignore-db commands. This is there a…and so do not work well for a lot of installations, especially as MySQL Server do not… are also replicate-do-table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB…Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table:…
Comment: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 12 Comments
…, there is also –replicate-do-table and –replicate-wild-do-table which have different behaviour than –binlog-do-db See http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html#option_mysqld_replicate-do-table http://dev.mysql.com…
