电信科学 ›› 2018, Vol. 34 ›› Issue (4): 136-143.doi: 10.11959/j.issn.1000-0801.2018104

• 运营技术广角 • 上一篇    下一篇

基于Goldengate的数据库异地灾备实现

宓正宇   

  1. 中国电信股份有限公司上海分公司,上海 200120
  • 修回日期:2018-02-09 出版日期:2018-04-01 发布日期:2018-05-02
  • 作者简介:宓正宇(1983-),男,中国电信股份有限公司上海分公司信息网络部工程师,主要从事IT项目管理,云计算项目、全球眼平台项目的规划、立项、实施方面的工作。

Design and implementation on remote disaster recovery system based on Goldengate

Zhengyu MI   

  1. Shanghai Branch of China Telecom Co.,Ltd.,Shanghai 200120,China
  • Revised:2018-02-09 Online:2018-04-01 Published:2018-05-02

摘要:

随着电信关键业务系统越来越受到重视,IT类需求水涨船高。IT系统应该更可靠、更快速、更易用以及更适应业务的变化发展;另一方面,重要业务平台的用户数据和业务数据的集中存放带来的安全风险也不断加大。重点阐述了 Goldengate 同步复制技术的概念和实现原理,研究了该技术的特性和优势,通过实际案例的分析,验证了采用 Goldengate 的数据复制技术的可行性,最终实现数据实时备份,确保核心数据库的安全,同时避免引入过多种类的软件,降低了运营维护的复杂度和成本投入,有利于灾备系统的恢复和实时切换。

关键词: Goldengate, 备份, 容灾, 数据库

Abstract:

As telecom business-critical systems become more and more important,the demand for IT classes has also increased.The IT system should be more reliable,faster and easier to use and to adapt better to changing business needs.On the other hand,the security risks are also increasing.The concept of synchronous replication technology and the realization theory of Goldengate was focused on,the characteristics and advantages of the technology were discussed.Through the analysis of actual cases,the feasibility of using Goldengate data replication technology was verified,the data real-time backup was realized,the core database security was ensured while avoiding the introduction of too many categories software,and the complexity of operation and cost inputs was reduced,also it is conducive to the recovery of disaster recovery system and real-time switching.

Key words: Goldengate, backup, disaster recovery, database

中图分类号: 

No Suggested Reading articles found!