摘要
随着开源技术的蓬勃发展,开源数据库在很多业务场景中已经完成对商用数据库的替换,其中MySQL数据库对于Oracle数据库的替换最为常见.在分阶段替换的过程中往往存在MySQL数据库和Oracle数据库在同一套业务系统中并存,MySQL数据库需要向Oracle数据库进行数据同步的情况.同时,MySQL数据库多节点高可用集群的部署方式进一步增加了数据同步的难度.通过研究运用Oracle GoldenGate软件对MySQL集群进行数据抽取的方法,设计出一套行之有效的方案,实际解决从MySQL集群向Oracle数据库同步数据的难题,同时保证了同步过程中数据库的一致性和完整性.
With the rapid development of open source technology, open source database has completed the replacement of commercial database in many business scenarios. The substitution of MySQL database for Oracle database is the most common. In the process of staged substitution, MySQL database and Oracle database often exist in the same set of business system, and MySQL database needs to synchronize data with Oracle database. At the same time, the deployment mode of multi node and high availability cluster in MySQL database further increases the difficulty of data synchronization. By researching the method of data extraction of MySQL cluster by using Oracle GoldenGate software, we design a set of effective schemes to solve the problem of synchronizing data from MySQL cluster to Oracle database, and ensure the consistency and integrity of database in the process of synchronization.
作者
杨明珉
陈勇
YANG Ming-Min;CHEN Yong(China Mobile （ShenZhen） Limited, Shenzhen 518048, China)
出处
《计算机系统应用》
2018年第6期60-68,共9页
Computer Systems & Applications
