Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
Mark Atwood
Consistency, Availability, and Partition Tolerance. Pick two.
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.

Tags: , ,
Current Location: Home, Capitol Hill, Seattle WA

2 comments or Leave a comment
From: technoshaman Date: October 7th, 2007 01:36 am (UTC) (Link)

Well, yeah. Obvious from the way "partition tolerance" is defined, the data by definition is going to be inconsistent until and unless the partition is removed. If one is worried about it, one uses multiple redundant data paths; this is how Arpanet was originally designed.

*shrug* looks kinda like a study in the obvious to me. But then I'm a sysadmin, not a DBA.
From: journalcatalog Date: October 7th, 2007 12:23 pm (UTC) (Link)

LJ Rating

We have placed your journal to the world best journals catalog to increase its pagerank and
popularity. You can view your listing here: http://blog.ubscribe.com/show.php?flet=f&page=2#fallenpegasus
To confirm the listing please either put a link to the catalog in your journal or add this user to your
friends list. Ignore this message if not interested and we'll remove the listing.
2 comments or Leave a comment