ACID means Atomicity, Consistency, Isolation and Durability. Let’s look at each of these properties below
Atomicity – Each transaction is all or nothing
Consistency – Data should be valid according to all defined rules & remains in consistent state
Isolation – Transactions don’t affect each other
Durability – Committed data would not be lost, even when there is power failure
Distributed ACID transactions are transactions that update multiple rows in more than one shard. Three types of distributed ACID transactions are
- Single-Row ACID
It refers to the transactions which impacts only a single row.
- Single-Shard ACID
It refers to the transactions which impacts the rows within a single shard
- Distributed ACID
It refers to the transactions which impacts multiple rows spread across multiple shards on multiple nodes.
Hope this article will be helpful