… 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: 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 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: 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: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… for a future version of MySQL. A global transaction ID lets you determine a server’s replication position reliably, among other benefits… works. Everyone who runs replication should be running pt-heartbeat already to get a reliable indicator of actual replication delay. This avoids the…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** …16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important… shard your data properly so you would not have to replicate everything 
There are also cases when storage size becomes the… for example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query or 5…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… forward in our plans to create excellent free tools for MySQL administrators. There is one really big thing to talk about… in your Nagios so you don’t get alerts about replication lagging and restart the tool because you killed it with… out of it with query failures, deadlocks, high/changing load, replication delay, servers shutting down and restarting, and so on — and it…
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
… 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… – As I already wrote these cause delay in replication even if they work on completely different (but replicated) data sets. Sometimes you do…
