… the amazing MySQL manual, especially the option and variable …Com_alter_dbblogpercona.commanual Com_alter_db_upgradeblogpercona.commanual Com_alter_eventblogpercona….replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_…
Post: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
…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, …comment form.) Now you do the following: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production.users set disabled = 1 …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication…-db and binlog-ignore-db commands. This is there a lot of people stop reading documentation, specify databases they want to replicate (or ignore… options to filter the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… the DB_TYPE. i.e. what storage engine it is. We can ignore the upper limit on number of storage engines for MySQL…. The main consequence of this bit of code is that MySQL may cause unnecessary disk IO for information it already has… InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart’s…
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′\G *************************** 1…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-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…
Comment: Why MySQL's binlog-do-db option is dangerous
July 24, 2012 By 15 Comments
…_do_db and binlog_ignore_db do not appear as advertized in the manual. The mysql config file has: binlog_do_db=mydb binlog_ignore_db=mysql binlog_ignore_db=test But when I login using ‘mysql -u -p’ and…
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
…> The target MySQL server host –ignore-databases Comma-separated list of databases to ignore –ignore-indexes Comma-separated list of indexes to ignore db_name.tbl… tables to ignore db_name.tbl_name –options-file The options file to use -p, –password=
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
…; > 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…; > 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…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… room for mistakes: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row…_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…
