Single phase transaction commits for distributed database transactions

摘要

A distributed database system may perform a single phase commit for transactions involving updates to multiple databases of the distributed database system. A client request may be received that involves updates to multiple database of the distributed database system. The updates may be performed at a front-end database and a back-end database. Log records indicating the updates to the front-end database may be sent to the back-end database. The log records and the updates performed at the back-end database may be committed together as a single phase commit at the back-end database. In the event of a system failure of the front-end database, log records may be requested and received from the back-end database. A restoration of the front-end database may be performed based, at least in part, on the received log records.

主权项

1. A system, comprising:
a plurality of nodes configured to implement a distributed data warehouse service, comprising:
a front-end database;a back-end database;a front-end service module, configured to:
receive a client request involving one or more updates to the front-end database and the back-end database;direct the performance of the one or more updates consistently across the front-end database and the back-end database, comprising:
send the one or more updates to the front-end database and the back-end database to be performed;receive one or more log records indicating updates performed at the front-end database from the front-end database;send the one or more log records indicating updates performed at the front-end database to the back-end database; andsend a commit request to perform a commit of the one or more log records sent to the back-end database from the front-end service module and the updates performed at the back-end database together as a single phase commit at the back-end database.