计算机与数字工程2016，Vol.44Issue(4)：687-690,729,5.DOI:10.3969/j.issn.1672-9722.2016.04.028
云环境 MMM 数据库集群双主多从架构模型构建磁
Model Design of Double-Master and Multi-slave Architecture for Database Cluster of Master-Master Replication Manager for MySQL Based on Clouds
摘要
Abstract
As the running of Hunan rural integrated services platform of national rural and agricultural information demonstration province and the fundamental platform of the Hunan agriculture IOT ,new requirements are proposed by big data operation and safety for agriculture .For the requirement ,an optimization model is proposed of master‐master replication manager for MySQL on Linux cluster for RedHat and MySQL .Three design models are mainly components of the model , including ,the front layer to realize the main switch from MySQL‐Proxy ,the data service layer to integrate the service node , monitoring and single image ,the share data layer to realize remote data synchronization ,backup and disaster recovery .The tests have proved that not only the problem of the performance bottleneck of the whole database cluster can be solved by in ‐creasing servers by the way ,but also the effective service can be achieved through a large of reading and writing under not in ‐creasing server hardware performance .The model can enhance the agricultural data security ,robustness and reliability under the cloud .关键词
双主多从架构/数据库集群/读写分离/负载均衡/地址漂移Key words
master-master replication manager for MySQL/database cluster/MySQL-Proxy/load balance/address drift分类
信息技术与安全科学引用本文复制引用
刘波,胡景光,黄天天..云环境 MMM 数据库集群双主多从架构模型构建磁[J].计算机与数字工程,2016,44(4):687-690,729,5.基金项目
国家科技部科技支撑计划课题（编号2012BAD35B05，2012BAD35B07）；湘西南农村信息化服务湖南省重点实验室开放基金课题（编号XAI20150326）；2014湖南省教育厅科研一般项目（编号14C0542）；2015年度湖南农业大学“大学生创新性实验计划项目（编号XCX14063）；2015年湖南农业大学团委科技创新立项项目（编号制作发明类201502）资助。 （）
