Brewer's Conjecture: "Consistency, Availability, and Partition Tolerance. Pick two."
Database ACID is something nice to wish for, but for real loads in real environments, it's not there to be had. Suck it up, move on, and do something else.
Reference:
Brewer's Conjecture and the Feasibility of Consistent Available Partition-Tolerant Web Services.