基于MySQL Cluster和Keepalived实现数据同步和故障转移的实验研究
|
摘要
随着互联网技术的高速发展以及高速度写的特性,数据库集群方案逐渐成为了处理数据的必备方案。但是由于技术上的壁垒和成本较大等原因,商用数据库集群方案往往对于中小型企业并不友好。而开源的MySQL集群方案,以其性能优良,经济成本小,操作简便等特点,逐步成为中小企业,甚至一些大型互联网公司搭建自己数据库系统的首选。但是MySQL集群方案本身就纷繁多样,处理数据的能力,数据同步及故障转移的高可用性也参差不齐。Keepalived是一个由C语言编写的项目,主要目标是提供负载均衡和高可用的Linux服务。Keepalived依赖于Linux Virtual Server内核提供的四层负载均衡,实现了动态自适应和维护,能够检测负载均衡池中的主机的健康状态。本实例研究通过搭建MySQL Cluster和Keepalived数据库集群系统,证明其可以实现数据同步和故障转移。
With the rapid development of Internet technology and the characteristics of high-speed writing, database cluster scheme has gradually become a necessary solution for data processing. However, due to technical barriers and high costs, commercial database cluster schemes are often not friendly to small and medium-sized enterprises.With its excellent performance, low cost and easy operation, MySQL cluster has gradually become the first choice for small and medium-sized enterprises, even some large Internet companies to build their own database system.However, MySQL cluster scheme itself is complex and diverse, and the ability to process data, data synchronization and high availability of failover are also uneven.Keepalived is a project written in C language. Its main goal is to provide load balancing and highly available Linux services. Keepalived relies on the four-tier load balancing provided by the Linux Virtual Server kernel, realizes dynamic adaptation and maintenance, and can detect the health status of the host in the load balancing pool. Case studies show that MySQL Cluster and Keepalived can achieve data synchronization and fault transfer.
With the rapid development of Internet technology and the characteristics of high-speed writing, database cluster scheme has gradually become a necessary solution for data processing. However, due to technical barriers and high costs, commercial database cluster schemes are often not friendly to small and medium-sized enterprises.With its excellent performance, low cost and easy operation, MySQL cluster has gradually become the first choice for small and medium-sized enterprises, even some large Internet companies to build their own database system.However, MySQL cluster scheme itself is complex and diverse, and the ability to process data, data synchronization and high availability of failover are also uneven.Keepalived is a project written in C language. Its main goal is to provide load balancing and highly available Linux services. Keepalived relies on the four-tier load balancing provided by the Linux Virtual Server kernel, realizes dynamic adaptation and maintenance, and can detect the health status of the host in the load balancing pool. Case studies show that MySQL Cluster and Keepalived can achieve data synchronization and fault transfer.
引文
[1]钱景辉,廖锂.基于Keepalived的动态浮动IP集群实现[J].化工自动化及仪表.2012(7).
[2]刘维志.数据库应用的高可用性及实现技术研究[J].信息系统工程.2013(4).
[3]牛亚伟,林昭文,马严等.数据流信息从MySQL到HBase的迁移策略的研究[J].软件,2015,36(11):01-05.
[4]于雪平,孟丹.数据库应用的高可用性及实现技术[J].计算机应用研究,2004(5).
[5]廖琴,文成玉.MySQL数据库高可用性的研究与实现[J].科技风,2016(18):100.
[6]高梅.浅谈Oracle数据库高可用性解决方案[J].福建电脑,2006(2).
[7]季菁苇.计算机数据库技术在信息管理中的应用研究探讨[J].软件,2018,39(6):160-163.
[8]张天珍.基于数据库条件下购物网站建设评估与研究[J].软件,2015,36(3):75-82.
[9]史尤昭.数据挖掘技术研究与应用[J].软件,2015,36(11):38-42.
[10]王伟.基于复杂网络的大型软件复杂性度量[J].软件,2015,36(11):92-95.
[11]陈晓燕,张鲲.数据库系统原理课程教学改革探索[J].软件,2018,39(3):102-105.
[12]谢华成,马学文.MongoDB数据库下文件型数据存储研究[J].软件,2015,36(11):12-14.
[13]张琪.大数据背景下软件测试的挑战与展望[J].软件,2018,39(6):181-183.
[2]刘维志.数据库应用的高可用性及实现技术研究[J].信息系统工程.2013(4).
[3]牛亚伟,林昭文,马严等.数据流信息从MySQL到HBase的迁移策略的研究[J].软件,2015,36(11):01-05.
[4]于雪平,孟丹.数据库应用的高可用性及实现技术[J].计算机应用研究,2004(5).
[5]廖琴,文成玉.MySQL数据库高可用性的研究与实现[J].科技风,2016(18):100.
[6]高梅.浅谈Oracle数据库高可用性解决方案[J].福建电脑,2006(2).
[7]季菁苇.计算机数据库技术在信息管理中的应用研究探讨[J].软件,2018,39(6):160-163.
[8]张天珍.基于数据库条件下购物网站建设评估与研究[J].软件,2015,36(3):75-82.
[9]史尤昭.数据挖掘技术研究与应用[J].软件,2015,36(11):38-42.
[10]王伟.基于复杂网络的大型软件复杂性度量[J].软件,2015,36(11):92-95.
[11]陈晓燕,张鲲.数据库系统原理课程教学改革探索[J].软件,2018,39(3):102-105.
[12]谢华成,马学文.MongoDB数据库下文件型数据存储研究[J].软件,2015,36(11):12-14.
[13]张琪.大数据背景下软件测试的挑战与展望[J].软件,2018,39(6):181-183.