摘要
目前MySQL数据库间的复制技术主要有异步、半同步、同步等,这几种技术存在各自的局限性和适用场景,很难满足国家电网业务对分布式事务和性能的要求。结合国内外先进的框架和技术,利用zookeeper实现MySQL数据库间复制的监控和管理,并改进MySQL数据库的线程池,参考半同步技术模型实现数据库间强一致性复制,融合以上两种技术实现复制在毫秒级、高可靠和高性能的MySQL分布式数据库集群。
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.
出处
《微型电脑应用》
2016年第1期77-80,共4页
Microcomputer Applications
