Tag - latency

MySQL High Availability: Stale Reads and How to Fix Them

solutions for MySQL Stale Reads

Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue.
The Problem
Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update operation to the value (source Wiktionary).
A practical scenario is when […]

Read more

Using ioping to Evaluate Storage Performance for MySQL Workloads

ioping

In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads.
I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage latency.  
For me, the main beauty of ioping is its simplicity and […]

Read more