Adding Simplicity – An Engineering Mantra: 2PC or not 2PC, Wherefore Art Thou XA?
But what if you really do need to update multiple databases. You have information that must be captured. Surely distributed transactions are the only safe way to do this. And why would you not want to leverage them anyway? Well, one reason is that while distributed transactions are an easy way to insure data integrity, they are a terrible way to insure high performance and availability.