… filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there …Now you do the following: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production… that actually operate on the tables mentioned in the query itself. …
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…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog events in ‘mysql…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… temporary tables (unless they are used to populate normal tables using SQL). On the Master you can do filtering using binlog-do-db and binlog-ignore-db commands… lot of discipline and so do not work well for a lot of installations, especially as MySQL Server do not offer any enforcements…
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
… TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 956920476 -rw-rw—- 1 mysql mysql 956920476 Aug 16 00:23 mysql-bin.000156 /data/dev/mysql# mysql < FLUSH TABLES WITH… TABLES; > MYSQL File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000156 957115478 -rw-rw—- 1 mysql mysql 957115478 Aug 16 00:23 mysql-bin.000156 /data/dev/mysql# mysql < FLUSH TABLES WITH…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql…
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… Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…mysql> show master status; +————+———-+——————————————-+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | … InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…=0 –oltp-range-size=0 –mysql-table-engine=innodb –mysql-user=root –max-requests=0 –max-time=60 –mysql-db=test run On Dell R900… to binlog we’re not expecting significant improvements in transaction rate (as the load is binlog fsync bound) but we surely do not… MySQL side – may be opening binlog with O_DSYNC flag if sync_binlog=1 instead of using fsync will help ? Or may be binlog…
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…
