…-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql-deadlocks… proper error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… to Galera is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that… allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql… small has two three purposes: It limits the amount of delay any node in the cluster might have applying cluster transactions…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… the delay indicated by the pt-heartbeat tool, if you choose), and actual 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 have…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication… the propagation delay was pretty good until this given query had to be replicated, in which case we could observe the replication delay for…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… asked about MySQL‘s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really… back. What should semi-synchronous replication be called instead? I believe that it should be called delayed-acknowledgment commits, because this is…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
Brian Aker recently published good write up about using MySQL replication. The piece I find missing however is good description of … write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically microseconds. However if there…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really… rarely copying of replication events is a slower element of the replication. There could be a network delay, causing a steady delay of few…
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: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in… queries on the master which not take time to replicate to the slave replication lag can be significant. Also even very small…
