… 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…’t work the way you think they do. Consider the following scenario: you set binlog-ignore-db to “garbage” so data in the garbage…
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…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000002 | 544 | | | +——————+———-+————–+——————+ error log (snipped): InnoDB: In a MySQL replication slave the last master binlog…
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…. For example cloning Master (and dropping not replicated tables) to set up replication becomes more tricky because you need to perform…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…into it, and dropped it: master > set autocommit=0; master > begin; master >… Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog …
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: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) If you’re backing up…: 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…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using…no = 10001; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> show tables; +———————+ | Tables_in_employees | …
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 94 Comments
… it’s the small details… The “attributes IP” weren’t set for the nodes. No it looks better – somehow. The replication… empty set and the master status differs: *************************** 1. row *************************** File: mysql-bin.000050 Position: 106 Binlog_Do_DB: Binlog_Ignore_DB: And again, the function “set_master…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… for massive scalability, how to do read-write splitting without breaking the…my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql –pid-file=/…Binlog_cache_use | 468 | | Bytes_received | 1708212 | | Bytes_sent | 7796961 | | Com_admin_commands | 11893 | … snip … Then I format the second set…
