The Design And Implement Of A Database Cluster Based On MySQL Database

With the development of Internet technology, massive data access make traditional database management systems have been overwhelmed, and as the core of the application system, database plays a very important role in the IT system of the enterprise, a single device cannot guarantee the continuous running of the system The single node failure will seriously affect the normal operation of the entire system, and even bring huge economic losses.The database cluster is an effective mechanism to improve the throughput of database systems and reduce the response time of the database. Generally, it is used to solve the single-node bottleneck problem of data access in network services. Load balancing technology is the key factor to determine the performance and scalability of the entire database cluster. Excellent load balancing algorithm can efficiently distribute the load to the different nodes in the cluster and minimize the impact of a single node failure in the cluster.Cluster technology has been widely applied on the Internet and also cluster architecture has a lot of maturely designed models. During the study it was found that there are three key points in designing a cluster model:single service interface for client, load balancing and data consistency. Solving these problems is key to build high performance, high availability and extendibility cluster systems. Commercial database clusters have provided some mature solutions, but due to technology blockade of foreign companies, the purchase and maintenance costs are high for enterprises. MySQL database is popular with companies for it is open source as well as free. Building high available database cluster system with MySQL can effectively control IT costs.In this paper, the author analyzed technical features in current Web service cluster, studied several system architectures of commercial database cluster and designed a high availability database cluster model. The model provides a single interface by virtual IP and uses optimized consistency hashing load balance algorithm, which provides a good hashing and scalability and minimized the impact caused by failure of the cluster nodes. Meanwhile, it provides double heat-computer backup on the load balance module to improve system availability. Data consistency is ensured by using MySQL Replication technology which can make the updates on the Master synchronize to each node in cluster.The model has been implemented in the test machines. It provides stable service and achieves the desired effect. It has effective failover, load balancing and data synchronization and the design can be used in commercial areas by further optimizing.