摘要
目的:完成HIS的软硬件升级,解决SQL数据库下HIS负荷过重的问题。方法:数据库升级后,由3台服务器组成集群环境,利用SQL2014的AlwaysOn完成HIS数据库的读写分离,将HIS中的各类查询及报表做负载均衡。结果:极大地提升了HIS的性能和安全。结论:利用SQL2014自带的AlwaysOn,无须借助第三方软件,对于提升HIS性能是十分安全、可靠的。
Objective: To solve the problem of overload of HIS under SQL database, we had upgraded the hardware and software of HIS. Methods: Using the HA cluster formed by three servers after the database of HIS upgraded, we have compeleted the Read/Write Splitting of HIS database and created the load balacing on kinds of query and report of HIS. Results: The safety and performance of HIS have enhanced greatly. Conclusion: It is very safe and reliable for improving the performance of HIS using Always On of SQL2014 without the third party software.
作者
丁晔
DING Ye(Jiangsu Cancer Hospital, Jiangsu Institute of Cancer Prevention and Control, Cancer Hospital Affiliated to Nan jing Medical University, Nanjing 210009, Jiangsu Province, P.R.C.)
出处
《中国数字医学》
2018年第5期55-56,54,共3页
China Digital Medicine