Jepsen wrote an amazing analysis of MySQL consistency (or lack thereof). You should read it. I’ll wait.
“Imagine the soft chords of a heart-tugging piano lament have begun to play. A montage of transactional anomalies appears on your screen. Internal anomalies. Lost updates. Dirty writes. Jepsen is looking into the camera, holding a database.”