How Do Distributed Transactions Work?
Databases are now able to support distributed transactions against multiple computer hosts or applications. Distributed transactions still implement the proven ACID properties; however, it is done so across multiple data stores or systems. These systems can consist of a variety of non-classic databases such as file systems, messaging systems, databases, and other applications. The distributed transaction will typically coordinate services ensure that all aspects of the transaction are applied to the appropriate system. If any component of the transaction fails, then the transaction will be rolled back across all of the impacted systems.