EmergencyEMERGENCY? Get 24/7 Help Now!

How does MySQL Replication really work?

 | January 9, 2013 |  Posted In: Insight for DBAs, MySQL

While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really works on the high level. Or it’s been so long ago I can’t […]

Read More

Percona Toolkit by example – pt-stalk

 | January 3, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to time: a server issue arises that leaves you scratching your head. That’s when Percona Toolkit’s pt-stalk comes into play, helping you diagnose the problem by capturing diagnostic data that helps you pinpoint what’s causing the […]

Read More

Setting up XFS on Hardware RAID — the simple edition

 | December 16, 2011 |  Posted In: MySQL

There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options.  I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use cases.  This is not meant to cover every […]

Read More