EmergencyEMERGENCY? Get 24/7 Help Now!

When MySQL Lies: Wrong seconds_behind_master with slave_parallel_workers > 0

 | January 27, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL error code 1215

In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_workers > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying. To be more specific, I’m talking about bugs #84415 and #1654091. The Issue MySQL will not report the correct slave lag if you have slave_parallel_workers […]

Read More

Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

 | March 13, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona XtraDB Cluster, Technical Webinars

My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available here for playback along with the slides). I didn’t have time to answer many of the questions during the session and so in this post I answer all of them. Thanks to everyone who attended! Q: […]

Read More

MySQL 5.6’s new replication features: Benefits, Limitations and Challenges

 | October 21, 2013 |  Posted In: MySQL, Technical Webinars

On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges). The webinar, appropriately titled, “New Replication Features in MySQL 5.6: Benefits, Limitations, and Challenges“, is scheduled for Oct. […]

Read More