基于主从同步的MySQL负载均衡设计与部署

Design and Deployment of MySQL Load Balancing Based on Master-slave Synchronization

随着信息化技术的迅猛发展,为了持续为各类PC端、移动端用户提供可靠服务,数据存储的要求也发生了巨大变化,数据存储在向负载均衡、高可用性等方面发展。本研究在Linux环境下,通过MyCat为MySQL数据库配置主从同步,实现数据的读写分离,从而实现服务器的负载均衡。同时,在教考分离平台中,配置一主两从的部署方式,读写分离的优势明显,效果显著。

With the rapid development of information technology,in order to continuously provide reliable services for all kinds of PC and mobile users,the requirements of data storage are also changing greatly.Data storage is developing towards load balancing and high availability.Under the Linux environment,the master-slave synchronization is configured for MySQL database through MyCat to realize the separation of data reading and writing,so as to realize the load balance of the server.At the same time,in the teaching and examination separation platform,the deployment mode of one master and two slaves is configured,which has obvious advantages and remarkable effects.