June 19, 2013

Post: Fighting MySQL Replication Lag

… quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means if…

Post: MySQL 5.6: Improvements in the Nutshell

…improvements available in MySQL 5.6 …background Purge Threads – Improved Purge lag control (now works) – Split …Group Commit for Binary Log – Fight Cache Coherence and False…Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row based ReplicationReplication