干旱气象

• 业务技术应用 • 上一篇    下一篇

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

乔梁1,3许竹霞1孙林花1孔小怡1乔雅敏2   

  1. 1.甘肃省气象信息与技术装备保障中心,甘肃兰州730020;2.甘肃省气象局应急与减灾处,
    甘肃兰州730020;3.兰州大学,甘肃兰州730000
  • 出版日期:2017-06-26 发布日期:2017-06-26
  • 作者简介:乔梁(1989- ),男,甘肃酒泉人,硕士研究生,助理工程师,主要从事气象信息数据维护与开发. E-mail:455020268@qq.com
  • 基金资助:

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

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

  • Online:2017-06-26 Published:2017-06-26

摘要:

甘肃省国家自动气象站、区域自动气象站实时气象数据的共享服务由单一数据库服务器承担,在汛期用户访问频繁时,经常因为查询量过大,造成数据库表无法正常访问、数据无法入库,给用户带来不便,也为数据库维护带来负担。针对此类情况,本文采用将数据实时同步到多台数据库服务器中,通过负载均衡设备,将多台数据库服务器组建为数据库集群,实现用户对数据库集群的负载均衡访问,从而达到对用户的访问分流至数据库集群的节点服务器上,减缓对单一数据库服务器的访问压力,保障汛期实时气象数据的实效性及稳定性。

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

Abstract:

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.

Key words: load balancing, database cluster, data synchronization, real-time meteorological data