… 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: 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: Infinite Replication Loop
October 10, 2011 By 2 Comments
… statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop is… 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…
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: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… 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… for MySQL as they use for PostgreSQL for example instead of investing time to learn about MySQL Replication or just looking to keep MySQL…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded … 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…
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, …
