Load balancing of OLTP on heterogeneous database cluster

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.