梁 冰

(辽宁省河库管理服务中心(辽宁省水文局)，辽宁 沈阳 110003)

　　摘 要：随着水文数据量的不断增加及业务的不断扩展，在数据安全与访问效率上，现有数据管理及服务模式已无法满足水文现代化发展的迫切需求，为提高数据库安全与性能，对数据库性能优化理论进行深入的研究和分析,并提出基于集群的优化方案，将单实例数据库升级到数据库集群。从对敏感数据与非敏感数据进行物理隔离，建设数据审计系统，搭建数据库集群，开发数据访问接口API等4个方面进行优化，分析集群部署环境的创建，故障转移群集搭建，并创建一个集群实例，对优化方案实施前后数据库的安全与性能进行对比，经过对比发现数据库的安全与性能提升明显，对于单实例数据库升级到集群系统有一定的借鉴作用。

　　关键词：数据库集群;水文数据;数据接口;数据审计;安全性能;提升;对策

　　中图分类号：TV211.2 文献标识码：A

　　Cluster-based countermeasures for improving the security performance of hydrological data

　　LIANG Bing

　　(Liaoning Heku Management Service Center (Liaoning Hydrological Bureau), Shenyang 110003, China)

　　Abstract:With the continuous increase of hydrological data and expansion of business, the existing data management and service mode are unable to meet the urgent demands of hydrological modernization development in terms of data security and access efficiency. In order to improve the security and performance of database, the article deeply studies and analyzes the database performance optimization theory, proposes the cluster-based optimization scheme, and upgrades the single-instance database to the database cluster. It optimizes from four aspects, such as physical isolation of sensitive data and non-sensitive data, construction of data audit system, construction of database cluster, development of data access interface API, analyzes the creation of cluster deployment environment, sets up hydrological database cluster, and establishes a cluster instance, compares the security and performance of the database before and after the implementation of the optimization scheme. Through comparison, it is found that the security and performance of the database are significantly improved, which can be used for reference to upgrade single instance database to cluster system.

　　Key words: database cluster; hydrological data; data interface; data audit; security performance; improvement; countermeasures