Help Center/ Data Replication Service/ Best Practices/ Real-Time Synchronization/ From On-premises Oracle to GaussDB Primary/Standby/ Purpose
Updated on 2024-07-15 GMT+08:00
View PDF
Share

Purpose

Description

This practice uses UGO syntax migration and DRS real-time synchronization to synchronize on-premises Oracle to Huawei Cloud GaussDB. You can create a full+incremental synchronization task to synchronize data from the source Oracle to the destination GaussDB.

Problems

  • With the rapid increase of enterprise workloads, traditional databases have poor scalability and distributed databases are required.
  • Building traditional databases require purchasing and install servers, systems, databases, and other software. Its O&M is expensive and difficult.
  • The performance of complex queries for traditional databases is poor.
  • It is hard for traditional databases to smoothly synchronize data with no downtime.

Migration Principles

In this practice, UGO is used to migrate heterogeneous database schemas, and DRS is used to only synchronize data. The principles are as follows:

  1. UGO is used to synchronize basic objects.
  2. DRS is used to perform full synchronization and suspend the task after the task enters the incremental phase.
  3. UGO is used to synchronize common indexes.
  4. DRS is used to resume incremental synchronization. After data is synchronized, stop services on the source end for data comparison to ensure data consistency. Then, you need to stop the DRS task.
  5. Finally, UGO is used to migrate triggers, events, jobs, foreign keys, and sequences, and services are migrated to GaussDB.

Service List

  • Virtual Private Cloud (VPC)
  • GaussDB
  • Database and Application Migration UGO (UGO)
  • Data Replication Service (DRS)
  • Data Admin Service (DAS)

Notes on Usage

  • The resource planning in this document is for demonstration only. Adjust it as needed.
  • The end-to-end test data in this document is for reference only.
  • Full synchronization is used to migrate data. Incremental synchronization is used to synchronize data between the source and destination databases in real time.

Prerequisites

  • You have registered with Huawei Cloud and completed account authentication.
  • Your account balance is greater than or equal to $0 USD.
  • You have set up an on-premises Oracle database for testing.
  • You have obtained the IP address, port number, account, and password of the Oracle database to be migrated.