基于Keepalived和Mycat的MySQL数据库高可用性设计与实现  

Design and Implementation of High Availability of MySQL Database Based on Keepalived and Mycat

作　　者：廖卓 姚敏 余筱 黄俊铭 LIAO Zhuo;YAO Min;YU Xiao;HUANG Junming(China Mobile Internet Co.,Ltd.,Guangzhou 510640,China)

机构地区：[1]中移互联网有限公司,广东广州510640

出　　处：《现代信息科技》2022年第11期27-29,33,共4页Modern Information Technology

摘　　要：为实现移动认证平台MySQL数据库主从架构的故障自动切换,提升系统恢复效率,设计了一套基于Keepalived和Mycat的数据库高可用方案。该方案的核心思想是通过独立的健康检测程序探测数据库运行状态,当策略判断主用数据库异常时,通过控制Keepalived切换虚拟IP来实现代理Mycat的主备切换,从而实现数据库切换。实验结果表明该方案可有效降低数据库故障切换时间。In order to realize the automatic failover of MySQL database master-slave architecture and improve the system recovery efficiency,a set of database high availability scheme based on Keepalived and Mycat is designed.The core idea of this scheme is to detect the running state of the database through an independent health detection program.When the strategy judges that the main database is abnormal,it realizes the master and standby switching of the agent Mycat by controlling the Keepalived switch virtual IP,so as to realize the database switching.Experimental results show that this scheme can effectively reduce the database failover time.

关 键 词：MYSQL数据库 Keepalived Mycat 高可用 故障切换 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]