| 323 | 22 | 81 |
| 下载次数 | 被引频次 | 阅读次数 |
目前MySQL数据库间的复制技术主要有异步、半同步、同步等,这几种技术存在各自的局限性和适用场景,很难满足国家电网业务对分布式事务和性能的要求。结合国内外先进的框架和技术,利用zookeeper实现MySQL数据库间复制的监控和管理,并改进MySQL数据库的线程池,参考半同步技术模型实现数据库间强一致性复制,融合以上两种技术实现复制在毫秒级、高可靠和高性能的MySQL分布式数据库集群。
Abstract：At present,the replication technology between MySQL mainly contains asynchronization,semi-synchronization and synchronization.These technologies have respective limits and suitable scenarios,and that make them hardly meet the requirements for distributed affairs and performances of State Grid Corporation of China.This paper uses zookeeper to realize the monitoring and management of replication between MySQL databases and improves the thread pool of MySQL databases,combining with the advanced framework and technology of home and abroad.It consults the semi-synchronization model to realize the strong consistence replication between the databases,and it also fuses the two above technologies to realize the replication on the millisecond,high reliability and performance MySQL distributed database groups.
[1]Flavio Junqueira,Benjamin Reed.Zoo Keeper:Distributed Process Coordination[M].O'Reilly Media,2013,12,210-333.
[2]曾大聃,周傲英.Hadoop权威指南(第二版-中文版)[M].北京:清华大学出版社,2011(1):88-89.
[3]邓鹏,李枚毅,何诚.Namenode单点故障解决方案研究[J].计算机工程,2012,38(21):25-44.
[4]Patrick Hunt,Mahadev Konar,Flavio PJunqueira,Benjamin Reed Zoo Keeper:Wait-freecoordinationfor Intem etscalesystems USENIXAnnual Technology Conference[C].2011:2-3.
[5]叶谦.Zookeeper初步调研报告[J].计算机技术与发展,2011,7(7):15-25.
[6]倪超.从Paxos到Zookeeper[M].北京:电子工业出版社,2015:43-61.
[7]Marco Aiello.leader_election[M].Distributed system.2011,1:5-9.
[8]雷明.fast paxos算法与Zookeeper leader选举源代码分析[J].计算机技术与发展,2015.3,3(04):3-20.
[9]Zoo Keeper:Because Coordinating Distributed Systems is a Zoo[J/OL]。Science,2014,3(http://zookeeper.apache.org/doc/r3.4.6//).
基本信息:
中图分类号:TP311.133.1
引用信息:
[1]张旭刚,李东辉,俞俊,等.基于zookeeper和强一致性复制实现MySQL分布式数据库集群[J].微型电脑应用,2016,32(01):77-80.
2016-01-20
2016-01-20