… above. [root@sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the coordinates above…” to the snapshot state when it was taken. We will do this using lvconvert’s –merge option, to merge the state…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
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…. 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…
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: 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…
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: 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…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… tables using SQL). On the Master you can do filtering using binlog-do-db and binlog-ignore-db commands. This is there a lot of people… the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do-* counterparts and which are as easy to break. So I generally would not recommend using these. There are also replicate-do…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… | Binlog_Do_DB | Binlog_Ignore_DB | +————+———-+——————————————-+——————+ | bin.000030 | 9462 | db1,db2,db3,db1,db2,db3 | | +————+———-+——————————————-+——————+ 1 row in set (0.00 sec) *** All db…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… –mysql-user=root –max-requests=0 –max-time=60 –mysql-db=test run On Dell R900 with CentOS 5.2 and… to binlog we’re not expecting significant improvements in transaction rate (as the load is binlog fsync bound) but we surely do not… be opening binlog with O_DSYNC flag if sync_binlog=1 instead of using fsync will help ? Or may be binlog pre-allocation…
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…: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table…
