Strategy for Dynamic Data and Load Balancing in Heterogeneous Database Cluster
In order to solve the problem of data and load balancing in heterogeneous database cluster,an improved range data distribution method based on computing weights is proposed,which can effectively utilize different computing resources of heterogeneous nodes and keep the workloads of the system balanced for longer time.And the online migrating algorithm is further presented when data skew happens because of workloads accessing.The experimental results show that the improved range partition method has higher throughput and better scalability than both the traditional even range and prime based hash algorithms in the heterogeneous computing environments.