Method and system for load balancing a distributed database

摘要

A method of processing a transaction request at a database load balancer. The method comprises receiving the transaction request, where the transaction request is comprised of one or more operations; analyzing the transaction request to determine the one or more operations; associating one or more database locks with each of the one or more operations; analyzing one or more of the database locks to determine the one or more sequence numbers associated with each of the one or more operations; and transmitting the one or more operations with the associated database locks and the sequence numbers to one or more databases servers accessible to the database load balancer.

主权项

1. A method of processing a transaction request, the method comprising:
(a) receiving the transaction request, wherein the transaction request is comprised of one or more operations; (b) analyzing the transaction request to determine the one or more operations; (c) determining if each of the one or more operations can be represented by a prepared transaction request form; (d) converting the one or more operations determined in step (c) to a prepared transaction request form; (e) associating lock information for one or more database locks with each of the one or more operations; (f) analyzing one or more of the database locks to determine one or more sequence numbers associated with each of the one or more operations; and (g) transmitting the one or more operations with the associated lock information and the one or more sequence numbers to one or more database servers accessible to a database load balancer.