SYSTEM FOR DYNAMICALLY VARYING TRAFFIC ROUTING MODES IN A DISTRIBUTED CLUSTER AND METHOD THEREFOR

摘要

A system for dynamically varying traffic routing modes in a distributed database system is presented. A database system comprises a load balancer and a database partitioned into a first and second shard. Coupled to the load balancer are a first plurality of database servers and a second plurality of database servers. Each of the first plurality of database servers contains a copy of the first shard of the database. Each of the second plurality of database servers contains a copy of the second shard of the database. Each server in the first plurality of database servers sends queries to a server in the second plurality of database servers using a round-robin system in which servers in the second plurality of database servers take turns processing incoming queries, as a method of distributing load among the multiple servers. Other embodiments also are disclosed.

主权项

1. A system comprising:
a load balancer; a database partitioned into at least a first shard and a second shard; a first plurality of database servers coupled to the load balancer, each database server in the first plurality of database servers hosting a copy of the first shard of the database; and a second plurality of database servers coupled to the load balancer, each database server in the second plurality of database servers hosting a copy of the second shard of the database; a centralized data store arranged to maintain a list of each database server in the first plurality of database servers and each database server in the second plurality of database servers; wherein:
the load balancer is arranged to send incoming instructions to a database server selected from the first plurality of database servers or the second plurality of database servers, using load balancing techniques;a first order in which each database server in the first plurality of database servers is accessed is created;a second order in which each database server in the second plurality of database servers is accessed is created;each database server in the first plurality of database servers is configured to process at least one first instruction of the incoming instructions and send queries of the first shard of the database to a database server in the first plurality of database servers based on the first order; andeach database server in the second plurality of database servers is configured to process at least one second instruction of the incoming instructions and send queries of the second shard of the database to a database server in the second plurality of database servers based on the second order.