基于Haproxy+Mycat的枸杞园数据收集分发系统  

A Data Collection and Distribution System for Goji Berry Orchard Based on Haproxy+Mycat

作　　者：伍丹 曹梦川 杜朋轩 WU Dan;CAO Mengchuan;DU Pengxuan(Ningxia Polytechnic,Yinchuan Ningxia 750021,China)

机构地区：[1]宁夏职业技术学院,宁夏银川750021

出　　处：《长江信息通信》2024年第7期97-99,共3页Changjiang Information & Communications

基　　金：智慧枸杞园关键技术集成创新示范及采收机械配套研究(2021BEF02001)。

摘　　要：文章针对智慧枸杞园对种植地环境及枸杞生长状况海量数据的收集分发需求,以及在原单点数据库模式下的服务器频繁宕机,数据处理能力、响应性能急速下降,数据丢失等问题,设计并实现了集成负载均衡软件Haproxy、数据库中间件Mycat、主从数据库的分布式数据收集分发系统。经过测试,系统可实现数据自动同步、读写分离功能,并具备高可用性及负载均衡能力。从而保障收集到完整、可靠、有效的数据集合,为后续研究奠定精准有效的数据基础。The paper focuses on the demand for collecting and distributing massive data of plant-ing environment and growth status in smart goji berry plantations,aims to solve the problems of frequent server crashes,rapid decline in data processing and response performance,and data loss in the mode of original single node database.A distributed data collection and distribution sys-tem integrating load balancing software Haproxy,database middleware Mycat,and master-slave databases is designed and implemented.After testing,the systcm can achieve automatic data syn-chronization,read-write separation,and has high availability and load balancing capabilities.Thus cnsuring the collection of complete,reliable,and effective data sets,laying a precise and effective data foundation for subsequent research.

关 键 词：智慧枸杞园 数据收集分发 自动同步 读写分离 高可用性 负载均衡 

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