… to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql-deadlocks… 1160611) * pmp-check-file-privs didn’t throw the proper error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my…two three purposes: It limits the amount of delay any node in the cluster might have …There are two global status variables you can check to see what flow control is happening: …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… 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 different data than their master. In addition to delay…
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: 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 latency…the propagation delay was pretty good until this given query had to be replicated, in which case we could observe the replication delay …
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…, there are many aspects of MySQL replication, but my main focus will be the logistics – how replication events are written on the master… steady delay of few hundred milliseconds, but that’s about it. If you want to see where IO thread currently is, check…
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… used to store object version information so you can quickly check if version you read from the slave is current one…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL… change. I of course could just restart MySQL but this would make replication to be delayed few more hours because of the time…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… engines you’re using – DRBD does not work with MyISAM (check required) so you need to have processes to ensure your… 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…
Post: Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities
February 15, 2013 By Leave a Comment
… to pmp-check-mysql-status (bug 1048627) * pmp-check-mysql-replication-delay didn’t alert if second behing master is NULL (bug 1040528) * pmp-check-pt-table… config: define command{ command_name check_pxc_node_status command_line /usr/lib64/nagios/plugins/pmp-check-mysql-status -l $USER3$ -p $USER4…
