Re: XA transaction isolation level and ACID properties

[Rick James]

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
C...
I...
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.