| 基于Mycat的分布式技术在收集与分发系统中的应用 |
| |
| 引用本文： | 刘洋,高鹏,徐娟,陈旭辉.基于Mycat的分布式技术在收集与分发系统中的应用[J].气象研究与应用,2021,42(1):90-95. |
| |
| 作者姓名： | 刘洋 高鹏 徐娟 陈旭辉 |
| |
| 作者单位： | 甘肃省气象信息与技术装备保障中心,甘肃兰州730020 |
| |
| 基金项目： | 2020年甘肃省气象局气象科学技术研究项目(MsCg2020-05)。 |
| |
| 摘 要： | 基于Mycat的分布式数据库集群,采用了Mycat+Mysql+Haproxy+Keepalived的技术架构,实现了一个高可用、高性能和高扩展的分布式数据库集群系统,并对单机版Mysql数据库和基于Mycat分布式数据库集群进行性能比较。结果表明,基于Mycat的分布式技术研发数据库集群系统具有高效性和可行性,可以解决单机版的Mysql数据库运行因硬件故障、软件错误、存储的损毁等导致主机系统异常,数据服务无法响应,数据的可用性和时效性降低的问题。
|
| 关 键 词： | Mycat 分布式 集群 数据库 性能 |
Application of distributed technology based on Mycat in collection and distribution system |
| |
| Liu Yang,Gao Peng,Xu Juan,Chen Xuhui.Application of distributed technology based on Mycat in collection and distribution system[J].Journal of Guangxi Meteorology,2021,42(1):90-95. |
| |
| Authors: | Liu Yang Gao Peng Xu Juan Chen Xuhui |
| |
| Affiliation: | (Gansu Meteorological Information and Technical Equipment Support Center,Lanzhou Gansu 730020) |
| |
| Abstract: | The distributed database cluster based on MYCAT adopted the technical architecture of Mycat+Mysql+Haproxy+Keepalived,and realized a highly available,high-performance and high expansion distributed database cluster system.The performance comparison between the stand-alone version of Mysql database and the distributed database cluster based on Mycat was carried out.The results showed that the distributed technology research database cluster system based on Mycat was efficient and feasible,which could solve the problems of host system exception,data service failure,as well as data availability and timeliness reduction caused by hardware failure,software error,and storage damage. |
| |
| Keywords: | Mycat distributed cluster database performance |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
