By Topic

Load balancing of OLTP on heterogeneous database cluster

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

The purchase and pricing options are temporarily unavailable. Please try again later.
2 Author(s)
Weihua Gong ; Dept. of Comput. Sci. & Technol., Huazhong Univ. of Sci. & Technol., Wuhan ; Yuanzhen Wang

Load balancing is an important factor to achieve better performance for heterogeneous database cluster. In order to evaluate the impact of all kinds of resources in heterogeneous nodes on different types of applications, the weighted load index that take both the utilization of different resources and the types of workloads into consideration are introduced based on a load balancer architecture. And an efficient and dynamic load balancing scheme is proposed for OLTP workloads to maximize the utilization of distributed resources and achieve better performance, which need not collect the feedback of load information from the lower nodes and effectively keeps from the data skew. The simulation results for OLTP services gained by TPC-C tool show that the dynamic weighted balancing policy keeps the heterogeneous cluster well balanced and leads to sublinear throughput speedup

Published in:

Advanced Communication Technology, 2006. ICACT 2006. The 8th International Conference  (Volume:3 )

Date of Conference:

20-22 Feb. 2006