…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: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
… way you think they do. Consider the following scenario: you set binlog-ignore-db to “garbage” so data in the garbage database (which doesn… form.) Now you do the following: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production.users set disabled = 1 where user = “root…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…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…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…filtered or partial MySQL Replication (as of version MySQL 5.0) – there…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…and dropping not replicated tables) to set up replication becomes more …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…, and dropped it: master > set autocommit=0; master > begin; …Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog events in ‘mysql…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…MySQL binlog file position 0 98, file name ./mysql-bin.000002 —round 2— show master status; +——————+———-+————–+——————+ | 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
… for mistakes: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00…_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: 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…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
… an 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…=”ignore” \n default-resource-stickiness=”1000″ \n last-lrm-refresh=”1328620089″ property $id=”mysql_replication” \n replication_info=”10.20.0.21|mysql…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…mysql/mysql.sock user=mysql server-id=1 #replicate-same-server-id=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog_do_db=newcrmdb binlog-ignore-db=mysql…
