… the bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can… pretty good tutorial on creation for setting up BLACKHOLE Based Replication Filtering so I will not go into much of details but…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication hierarchy and specific things about it, such as replication filters, versions, whether replication is running, how far behind…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…, that’s a certain recipe for a /dev/null email filter. Avoid ratios and thresholds as much as possible, because they… failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server_id… was executed. Then that event is replicated to the slaves (the I/O slave thread filters out only the events with a….1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-same…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is easy to filter out events) so you can see whenever there are any suspicious events in the replication traffic. An interesting…
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 …: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production.users set disabled = 1 where user = “root”; You just broke replication, …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… all queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE… same as replication load. This gives us replication capacity of 1/0.37 = 2.70 This method should work with original MySQL Server…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in… Multi-Master is implemented for many applications Parallel Replication could be implemented simply by filtering transactions and writing to number of binary…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… goes on par with MySQL Statement Based Replication – it is also well too easy to use MySQL features which break replication. The failover node… do with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is…
