US 12,346,310 B2
Supporting database transactions in a distributed computing environment
Duc The Dang, San Jose, CA (US); Brian Nguyen, San Jose, CA (US); Rashi Dubey, Toronto (CA); David Kit Nam Lam, Daly City, CA (US); Rohit Basu, Brentwood, CA (US); and Phuong Thao Trung Le, San Jose, CA (US)
Assigned to Dell Products L.P., Round Rock, TX (US)
Filed by Dell Products L.P., Round Rock, TX (US)
Filed on Jun. 6, 2023, as Appl. No. 18/330,031.
Prior Publication US 2024/0411748 A1, Dec. 12, 2024
Int. Cl. G06F 9/00 (2018.01); G06F 16/23 (2019.01)
CPC G06F 16/2379 (2019.01) 18 Claims
OG exemplary drawing
 
1. A method comprising:
positioning an access service between a plurality of Kubernetes pods and a structured query language (SQL) database service, the plurality of Kubernetes pods hosting instances of microservices from a containerized application and positioned to receive requests from a load balancer that distributes the requests across the Kubernetes pods, and
the access service comprising a staging database, separate from the SQL database service, that temporarily holds SQL operations that are requested by different Kubernetes pods over different connections, but are to be atomically committed;
receiving, at the access service, a REpresentational State Transfer (REST) application programing interface (API) request from any Kubernetes pod indicating that a SQL transaction should be started;
creating an entry in the staging database to track the SQL transaction;
allowing multiple connections to be established from the plurality of Kubernetes pods to the access service over which other REST requests from any of the Kubernetes pods are sent, the other REST requests comprising details of SQL operations to be performed as part of the SQL transaction;
caching the details in the staging database;
receiving, at the access service, a REST request from any Kubernetes pod indicating that the SQL transaction should be committed; and
establishing a single connection from the access service to the SQL database service to commit the SQL transaction including the details as an atomic transaction via the single connection.