Research On Cluster Load Balancing Algorithm Based On LVS Database

Nowadays,with the rapid development of Internet technology and communication technology,the amount of data in the network showed explosive growth,users have higher requirements on the performance and reliability of data storage.With the increase of data services in the network,the traditional single node data storage mode can not meet the requirements of people for data services,and the database server has a high demand for availability and stability.Based on this,Load balancing database cluster is an appropriate solution for its high performance and high availability.MySQL database is favored by enterprises and individual users for its low cost and simple built environment.The MySQL database would be an organic whole by using cluster technology,which improved the performance of database system and enhanced the handling capacity of concurrent tasks.The load balancing technology is the key to achieve the rational and effective task scheduling for clusters system.Load balancer can evaluate processing capacity of nodes in the cluster,scheduling tasks according to the performance of server.The key to achieve the load balancing is the using of load balancing architecture and load scheduling algorithm.According to the present situation and existing problems,our research began with the open source software Linux Virtual Server,presenting a new method for calculating weights based on the response time.The main work of this paper includes:First,we analyzed and compared the database cluster system and load balancer,researched the Linux Virtual Server combined with MySQL database cluster,analyzed the adaptability of them.Then,we achieved MySQL database cluster system that was scheduled by Linux virtual server and verified the feasibility of combination.Second,based on the above research,we tested the performance of the cluster by using load testing software and different load balancing scheduling algorithm in cluster environment.By comparing and analyzing the more suitable algorithm for database cluster load balancing on the Linux virtual server architecture,we found that WLC algorithm and WRR algorithm have better scheduling performance.Third,we analyzed the WLC scheduling algorithm and the problems in using of the algorithm.Based on the analysis of the weight calculation model of the former researcher,this thesis proposes a new weights calculation method based on response time to optimize the scheduling effect of WLC algorithm.The experiment results showed that the improvedalgorithm can effectively improve the task scheduling effect of the WLC algorithm and increase the whole throughput of the cluster system.In this thesis,we analyzed and researched the load balancing scheduling algorithm of Linux Virtual Server.Based on static scheduling environment,we presented a new strategy that could solve the problem of weight calculation.This method can improve the rationality of load balancer scheduling,achieve making full use of the hardware resources of server cluster and enhance the task processing effect of the whole database cluster.