Database load reducing system and load reducing program
First Claim
1. A database load alleviation system comprising:
- a plurality of database servers; and
a load alleviation device which manages the plurality of database servers, wherein the load alleviation device comprises;
a query interpretation unit which interprets received queries, and judges whether the queries enable load balancing of the database servers;
a query distribution unit which sequentially distributes and transmits to the database servers, those queries judged by the query interpretation unit to enable load balancing;
a replication unit which replicates those queries judged by the query interpretation unit not to enable load balancing; and
a query transmission unit which transmits to all managed database servers, queries replicated by the replication unit.
1 Assignment
0 Petitions
Accused Products
Abstract
An object of the present invention is to provide a database load alleviation system and load alleviation program which balance load by interpreting queries and distributing queries which enable load balancing to database servers. In a database load alleviation system, a query-interpretive load balancer 1 interprets queries received from a user terminal 10, and judges whether the queries enable load balancing. Queries enabling load balancing are each distributed in sequence to one among the database servers 2-1 to 2-n in accordance with a load balancing algorithm, to balance the load. On the other hand, in the case of queries which do not enable load balancing such as a query which performs data writing, the query is replicated, and replicas are transmitted to all database servers 2-1 to 2-n, to maintain database consistency.
-
Citations
5 Claims
-
1. A database load alleviation system comprising:
-
a plurality of database servers; and
a load alleviation device which manages the plurality of database servers, wherein the load alleviation device comprises;
a query interpretation unit which interprets received queries, and judges whether the queries enable load balancing of the database servers;
a query distribution unit which sequentially distributes and transmits to the database servers, those queries judged by the query interpretation unit to enable load balancing;
a replication unit which replicates those queries judged by the query interpretation unit not to enable load balancing; and
a query transmission unit which transmits to all managed database servers, queries replicated by the replication unit. - View Dependent Claims (2, 3, 4)
-
-
5. A load alleviation program, in a database load alleviation system comprising a plurality of database servers and a load alleviation device which manages the plurality of database servers, causing a computer to execute:
-
a function of interpreting received queries and judging whether the queries enable load balancing of the database servers;
a function of distributing and transmitting those queries judged to enable load balancing in sequence to the database servers in accordance with a load balancing algorithm;
a function of replicating those queries judged not to enable load balancing; and
a function of transmitting replicated queries to all managed database servers.
-
Specification