梁 冰

(遼寧省河庫管理服務中心(遼寧省水文局)，遼寧 沈陽 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