王 容，宮博亞 ，孔祥意

(水利部信息中心(水利部水文水資源監測預報中心)，北京 100053)

　　摘 要：隨著水文數據量的不斷增加及業務的不斷擴展，在數據安全與訪問效率上，現有數據管理及服務模式已無法滿足水文現代化發展的迫切需求，為提高數據庫安全與性能，對數據庫性能優化理論進行深入的研究和分析,并提出基于集群的優化方案，將單實例數據庫升級到數據庫集群。從對敏感數據與非敏感數據進行物理隔離，建設數據審計系統，搭建數據庫集群，開發數據訪問接口API等4個方面進行優化，分析集群部署環境的創建，故障轉移群集搭建，并創建一個集群實例，對優化方案實施前后數據庫的安全與性能進行對比，經過對比發現數據庫的安全與性能提升明顯，對于單實例數據庫升級到集群系統有一定的借鑒作用。

　　關鍵詞：水情信息;數據交換;信息系統;升級完善;優化設計;全國

　　Upgrade and optimization design of national hydro-regime information exchange system

　　WANG Rong , GONG Boya, KONG xiangyi

　　(Information Center(Hydrological Monitor and Forecast Center),the Ministry of Water Resources,

　　Beijing 100053,China)

　　Abstract: In order to improve the exchange timeliness of national hydro-regime information, aiming at the problems of data storage delay, statistical stagnation, system crash and so on in the hydro-regime information exchange system during peak period, the technologies and methods of multi-thread parallel processing, independent control of micro service, multi-dimensional file exchange statistics and so on are proposed for optimization design of the four core layer modules of system information sending, information receiving, statistical analysis and information monitoring. Based on the core module service miniaturization, the primary and secondary threads are reconstructed under each micro service, and some threads run in parallel. According to micro service and multi-dimensional thread, file exchange statistics mode is constructed, which reduces the direct interaction with database, so as to improve the efficiency of information sending, receiving, and statistical analysis, and the friendliness of management and maintenance. The two-year test shows that the hydro-regime information exchange system greatly improves the large amount of data exchange ability, significantly improves the efficiency of sending and warehousing, basically has no data delay during morning peak, and fully guarantees the hydro-regime information service.

　　Key words: hydro-regime information; data exchange; information system; upgrading and perfection; optimization design; nationwide