基于负载均衡的数据库集群对气象数据的共享服务  

Shared Service of Meteorological Data Based on Database Cluster of Load Balancing

作　　者：乔梁[1,2] 许竹霞[1] 孙林花[1] 孔小怡 乔雅敏[3] 

机构地区：[1]甘肃省气象信息与技术装备保障中心,甘肃兰州730020 [2]兰州大学,甘肃兰州730000 [3]甘肃省气象局应急与减灾处,甘肃兰州730020

出　　处：《干旱气象》2017年第3期516-521,共6页Journal of Arid Meteorology

基　　金：2016年甘肃省气象信息与技术装备保障中心科技创新基金(201616)资助

摘　　要：甘肃省国家自动气象站、区域自动气象站实时气象数据的共享服务由单一数据库服务器承担,在汛期用户访问频繁时,经常因为查询量过大,造成数据库表无法正常访问、数据无法入库,给用户带来不便,也为数据库维护带来负担。针对此类情况,本文采用将数据实时同步到多台数据库服务器中,通过负载均衡设备,将多台数据库服务器组建为数据库集群,实现用户对数据库集群的负载均衡访问,从而达到对用户的访问分流至数据库集群的节点服务器上,减缓对单一数据库服务器的访问压力,保障汛期实时气象数据的实效性及稳定性。The real-time meteorological data sharing service of national and regional automatic weather stations in Gansu Province was undertaken by the single database server. When flood season was coming,the users＇ access became frequently and the query volume increased quickly,so the database table could not access normally,and the real-time data couldn＇t be put in storage,which was inconvenient to users and brought big trouble for maintenance. Aiming at such situation,this paper synchronized the real-time data to many database servers through load balancing device to organize the database cluster so as to achieve load balancing for access,which achieved user＇s access shunt to database cluster node on the server to reduce access pressure of a single database server,and could ensure effectiveness and stability of the real-time meteorological data during flood season.

关 键 词：负载均衡 数据库集群 数据同步 实时气象数据 

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