How does two-phase commit work, and what are its limitations?

Sample answer preview

Two-phase commit, often abbreviated 2PC, is a protocol for achieving atomic commits across multiple nodes in a distributed system. It ensures that either all participants commit a transaction or all abort, maintaining consistency across nodes.