云平台中MySQL数据库高可用性的设计与实现

摘要

为解决OpenStack云平台中单个节点的MySQL数据库在面临高并发访问和海量数据增长的情况下存在可靠性低、存储扩展性差、单点瓶颈等问题,设计并实现一种以Ceph分布式文件系统为存储后端的高可用MySQL数据库集群系统.通过集群技术消除基于独立服务器的单点瓶颈问题,保障业务的可靠性和高可用性,设计一套优化模型提高故障切换效率,底层的Ceph分布式文件系统为数据存储提供扩展性和安全性.实验结果表明,该MySQL高可用集群可以实现存储的扩展和节点失效情况下的故障切换,该优化模型可以有效降低故障切换时间.%To solve problems of single node MySQL database in the OpenStack cloud platform,such as low reliability,poor storage scalability and single point bottleneck in the face of high concurrent access and massive data growth,a highly available MySQL database clustering system with Ceph distributed file system as the storage backend was designed and implemented.The clustering technology eliminated single point bottleneck problem and guaranteed the reliability and high availability of services.An optimized model was designed to improve the efficiency of failover.The underlying Ceph distributed file system provided scalability and security for data storage.Experimental results indicate that the proposed high availability cluster can achieve the storage expansion and failover in case of node failure,and the proposed optimization model can effectively reduce the failover time.