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.
2. The method of claim 1 , wherein the one or more database servers implement one or more distributed databases.
3. The method of claim 1 , wherein the database load balancer comprises a plurality of components distributed across one or more of the database servers.
4. A system for processing a transaction request, the system comprising:
(a) a memory for storing a plurality of instructions; and
(b) a processor coupled to the memory, said processor configured for:
(i) receiving the transaction request, wherein the transaction request is comprised of one or more operations;
(ii) analyzing the transaction request to determine the one or more operations;
(iii) determining if each of the one or more operations can be represented by a prepared transaction request form;
(iv) converting the one or more operations determined in step iii to a prepared transaction request form;
(v) associating lock information for one or more database locks with each of the one or more operations;
(vi) 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
(vii) 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 the database load balancer.
5. The system of claim 4 , wherein the one or more database servers implement one or more distributed databases.
6. The system of claim 4 , wherein the database load balancer comprises a plurality of components distributed across one or more of the database servers.