The page has been translated by Gen AI.

Using CDC (Ark for CDC) for heterogeneous DB migration

Using CDC (Ark for CDC) for heterogeneous DB migration

Overview

You can migrate an on‑premises database (Oracle) to the SDS Cloud DB service using the commercial solution Ark for CDC. Supports heterogeneous DB migration (between different database engines). For example, in Oracle Database, Open Source Database (ex. You can migrate to MariaDB, PostgreSQL). In particular, by using the CDC (Change Data Capture) feature, you can apply the source DB’s change data to the target DB almost in real time, minimizing application downtime. It can be utilized not only for data migration but also for real-time data integration and replication, DR system deployment, and similar purposes.

Architecture Diagram

Migration from Oracle DBMS to MariaDB using Ark for CDC
Figure. Migration from Oracle DBMS to MariaDB using Ark for CDC
  1. Apply for a virtual server to install Ark for CDC, and configure resources such as a DB Service (MariaDB) to be used as the target DB and a VPN for secure communication with the on-premises data center.
  2. Create a DB account for Ark for CDC in the source DB (Oracle) and assign permissions.
  3. Create a DB account for Ark for CDC on the target DB (MariaDB) and assign the necessary privileges.
  4. Use Ark for CDC to replicate data from the source DB (Oracle) to the target DB (MariaDB).

Ark for CDC Architecture and Main Features

[Architecture] OS&DB independent, process modularization (process monitoring support) Separate message and data transmission ports and apply a distinct protocol Real-time 1:N data replication to a standardized and efficient heterogeneous environment

  • Minimizing load on source systems via middleware (unique data per Target)
Ark for CDC Architecture
Figure. Ark for CDC Architecture

[Key Features] DB replication for this model * Support for major Target DBs * Supports various replication configurations such as 1:1, 1:N, N:1

Data stability / consistency guarantee * Transmission data encryption (SSL, HTTPS) * Data consistency check and recovery function (Compare, Repair)

high performance * Direct Log Access method * Remote replication possible with minimal network load * Minimizing source server load through M/W architecture

  • Integrated monitoring / management functions
    • CLI & GUI based monitoring feature
    • Process State and Replication Status Analysis
    • Mobile service integration

Use Cases

Heterogeneous zero-downtime migration * Zero Downtime migration possible with heterogeneous DBs

  • Real-time data integration and replication
    • Replicate by outputting only the changed data from the DBMS in real time.
    • Support for 1:1, N:1, N:N data replication and integration

DR system implementation * DR system can be built in various environments

Prerequisites

Apply for a virtual machine to install Ark for CDC, and install Ark for CDC. A VPN connection must be established in advance for secure communication with the customer’s on-premises data center. The schema must be migrated in advance. The Source DB requires installing Ark for CDC Agent, creating a DB account, and assigning permissions. Creating a DB account and assigning permissions on the target DB is required.

Constraints

Ark for CDC only supports Oracle as the SourceDB. When using Ark for CDC as a commercial solution, prior license purchase negotiations are required.

Solution implementation and quotation inquiry

Related Products

Virtual Server

  • DB Service VPN
  • VPC