SYSTEM AND METHOD FOR IMPLEMENTING A DATABASE IN A HETEROGENEOUS CLUSTER

摘要

A system and method for implementing a 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. Queries are sent to a database server in the first plurality of database servers based on a suitability score of the database server determined by characteristics of each server and a current status of each server, where the query is sent to the server in the first plurality with the highest suitability score. 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;wherein:
the load balancer is arranged to:
retrieve server information for each database server in the first plurality of database servers and for each database server in the second plurality of database servers;determine a suitability score for each database server in the first plurality of database servers and for each database server in the second plurality of database servers based on the server information; andsend incoming instructions to a selected database server from the first plurality of database servers or the second plurality of database servers, using load balancing techniques; 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 only a first specific database server in the first plurality of database servers based on the suitability score of the first specific database server; and each 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 only a second specific database server in the second plurality of database servers based on the suitability score of the second specific database server.