3 ms·

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

• smilliken 7y ago
  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 7y ago
    I generally couldn't agree more, but yet its the first tool in the toolbox for a lot of databases.