[hobs]

Generally you get two phase commit involved here, or an asynch mirror that you can restore over if there's failure.

[smilliken]

Two phase commit makes a promise it can't keep. CAP theorem is not amused.

It's slow, complex, a leaky abstraction, and ahould be avoided for better consistency models.

[hobs]

I generally couldn't agree more, but yet its the first tool in the toolbox for a lot of databases.