… 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: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… this year; these always sell out early, so don’t delay to register! Here are the sessions we’re currently scheduled… Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL…
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 should have dynamic durability settings
April 8, 2008 By 4 Comments
… be decided for each transaction separately in session context. What MySQL Could do to take it further is to implement couple… replication is asynchronous anyway you do not have to flush logs for each transaction. Replication option could be implemented to utilize delayed commit for the replication thread. This is surely not…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… for in memory tables. So first MySQL versions did not bother naming variables … corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts configuration. Technically … related. expire_logs_days This is replication/binlogging related options – when to delete …
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: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… your scaling path – it becomes very easy to overload the replication, especially as it has to serialize transactions on the slave… MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated… you correct counters while being very efficient. By doing these delayed updates you can not only reduce number of updates, say…
