… the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project’s schedule because the… key is that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on the… on Tuesday Daniel will talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 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: 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 23 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: 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…
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… changing MySQL Replication semantics – which is – Slave database state corresponds to master database state at certain point in time. It is delayed but…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… 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 with… change. I of course could just restart MySQL but this would make replication to be delayed few more hours because of the time…
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
I generally thought about MySQL replication as being quite low overhead on Master, depending on number … and process several packets at the time we could make replication threads to be woken up in the batches. For example… the slave. If you have large amount of slaves the delay from the event executed on the master to last thread…
