MySQL Forums
Forum List  »  InnoDB

Re: XA transaction isolation level and ACID properties
Posted by: Rick James
Date: April 18, 2016 10:48PM

What you need is "ACID" or whatever across _your_ system. _Your_ system is a collection of machines with virtually not communication between them, certainly no ACID. The only thing you have to work with is "XA".

A = Atomic -- all or none
D = Durable -- I'm not sure you can get that. If one machine dies, will you somehow hang onto the 'transaction'?

Your best bet is to study how to do XA, then build a multi-server XA setup of your own. This is beyond what 99.99% of MySQL users care about.

Or you could write it to _one_ server (with full ACID, etc), then propagate it to others. This implies that that one server is the "source of truth", and any hiccups in the other servers should lead to reaching back into the source of truth to fix themselves.

Another solution is to put all your servers in a Galera-based Cluster. See Percona XtraDB Server or MariaDB 10.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.