…. There are a few of ways to do it. One way is to set up replication filters on the slave, as described… GTID-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor… Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was getting a lot…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… must have group communication to replicate and establish global ordering for every transaction, and the expense of doing that for Galera is… flushing to the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement = ‘killed_troll…
Post: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
I 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… isn’t replicated, so now the root user isn’t disabled on the slave. Why? Because binlog-ignore-db doesn’t do what you think. The phrase I used earlier, “data in the garbage database isn’t replicated,” is…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… log and so replicated. On the Slave you have more options to filter 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Com_alter_db_upgradeblogpercona….replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate_wild_do…
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…_IO_Running: 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: Last_Errno: 0 Last…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… or we can do some settings Here is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir…=1 #replicate-same-server-id=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog_do_db=newcrmdb binlog-ignore-db=mysql,test #replicate_do_db=crmdb #replicate_do_db=newcrmdb #auto…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…the slave, I just stopped the replication processes. This is safe to do even when temporary tables are … | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | |…
Comment: Why MySQL's binlog-do-db option is dangerous
July 24, 2012 By 15 Comments
… database is not replicated to the slave. It is if I use binlog_do_db=percona. In this case it is replicated to the client. But this is in contrast to the manual because ‘percona’ does not match any of the binlog_do_db configs in the original setup so then the ignore_db rules are matched. Since none of those rules match, it should replicate…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…DB | Binlog_Ignore_DB | +————+———-+——————————————-+——————+ | bin.000030 | 9462 | db1,db2,db3,db1,db2,db3 | | +————+———-+——————————————-+——————+ 1 row in set (0.00 sec) *** All db in replicated…
