What is distributed transaction?

Consider the following Microservices architecture for e-commerce website. Each of the service shown below has its own database.

In this example, when an order is placed:

  • Order is saved by order service in its DB
  • Customer payment data is updated by Payment service and saved in Payment DB
  • Stock is checked by stock serve and updated in its own DB
  • And delivery details are updated by delivery service and updated its own DB.

All these operations have to happen as part of one transaction, and if one of the operations fails, all previous operations have to rollback.

Transactions provide atomicity of multiple operations but on a single database. Here, this is not a single database, but multiple databases.

So what we need here is Distributed Transaction.

Distributed Transaction is not about some mechanism present in DB so they can manage transactions across multiple databases. But it is about how we can write our services so they take care of the transaction feature we need across multiple services/databases.

How transaction behaves in monolithic architecture?

  • In monolithic transaction is not distributed.
  • If something fails, say while updating order, all previous actions will be rollback.

What is 2 Phase commit?

Two-phase commit protocol is used for distributed transaction. It breaks a database commits into two phases.

  • Prepare
  • Commit

In this pattern, to take care of distributed transactions we need a separate service called Coordinator Service (a separate service). This service manages the commits and rollbacks to all microservices involved in a distributed transactions.

Can you explain the two phases of 2-phase commit protocol?

Prepare phase

  • Transaction starts with the coordinator sending a “PREPARE” message to all slaves (micro-services)
  • Coordinator generally sends all the nodes suggested value/change proposed by the client and solicit their response. The participants execute the transaction up to the point where they will be asked to commit.
    • Consider records being locked at this point of time on which transactions need to be committed.
    • No other request can modify the same row.
  • Each slave (micro-service) responds by sending a “READY” message back to the coordinator.
  • If a slave responds with a “NOT READY” message or does not respond at all, then the coordinator sends a global “ABORT” message to all the other slaves.
    • Only upon receiving an acknowledgment from all the slaves that the transaction has been aborted does the coordinator consider the entire transaction aborted.

Commit phase

  • Once the transaction coordinator has received the “READY” message from all the slaves, it sends a “COMMIT” message to all of them, which contains the details of the transaction that needs to be stored in the databases.
  • Each slave applies the transaction and returns a “DONE” acknowledgment message back to the coordinator.
  • The coordinator considers the entire transaction to be completed once it receives a “DONE” message from all the slaves.

Rakesh Kalra

Hello, I am Rakesh. I have more than 15 years of experience working on IT projects, where I have worked on varied complexity of projects and at different levels of roles. I have tried starting my own startups, 3 of those though none of it were successful but gained so much knowledge about business, customers, and the digital world. I love to travel, spend time with my family, and read self-development books.