使用Oracle Active Data Guard实现PMS2.0数据库读写分离初探  

Preliminary study on using Oracle ADG to achieve read-write separation on PMS2.0 database

作　　者：吴尚[1] 王萍[1] 胡聪[1] 张永梅[1] 张靖[1] 郑重珩 Wu Shang;Wang Ping;Hu Cong;Zhang Yongmei;Zhang Jing;Zheng Zhongheng(Information and Communications Branch,State Grid Anhui Electric Power Company,Hefei 230061,China)

机构地区：[1]安徽省电力公司信息通信分公司,安徽合肥230061

出　　处：《无线互联科技》2018年第9期43-44,53,共3页Wireless Internet Technology

摘　　要：文章研究了使用Oracle Active Data Guard实现PMS2.0数据库读写分离。生产管理系统PMS是电力信息系统中重要的核心业务系统,随着数据量不断快速增长,数据库的I/O吞吐量以及资源的耗用愈发凸显性能瓶颈,造成业务用户并发操作延时甚至失败。传统的单节点数据库或ORACLE RAC集群已无法应对。根据目前成熟的业界解决方案,采用读写分离的方式,可以有效解决这个问题。This paper studies on using Oracle ADG to achieve read-write separation on PMS2.0 database.Production Management System(PMS)is an important core business system in power information system.With the rapid growth of data volume,the I/O throughput and resource consumption of database increasingly highlight the performance bottleneck,resulting in concurrent operation delay or even failure for business users.The traditional single-node database or ORACLE RAC cluster architecture is no longer available.According to the current mature industry solutions,to apply read-and-write separation can solve effectively these issues.

关 键 词：ORACLE数据库 PMS2.0业务 读写分离 活动数据卫士 性能优化 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]