The page has been translated by Gen AI.

Heterogeneous DB Migration using CDC (Ark for CDC)

Heterogeneous DB Migration using CDC (Ark for CDC)

Overview

You can migrate On-premises Database (Oracle) to SDS Cloud DB service using the commercial solution Ark for CDC. It supports heterogeneous DB migration (between different database engines). For example, you can migrate from Oracle Database to Open Source Database (e.g., MariaDB, PostgreSQL). In particular, using the CDC (Change Data Capture) feature, you can apply the changed data from the Source DB to the Target DB in near real-time, minimizing application downtime. It can be used not only for data migration but also for real-time data integration and replication, DR system construction, and other purposes.

Architecture Diagram

Ark for CDC-based Oracle DBMS to MariaDB Migration
Figure. Ark for CDC-based Oracle DBMS to MariaDB Migration
  1. Apply for and set up the DB Service (MariaDB) to be used as the Target DB, a Virtual Server to install Ark for CDC, and a VPN for secure communication with the on-premises data center.
  2. Create a DB account for Ark for CDC to use on the Source DB (Oracle) and assign the necessary permissions.
  3. Create a DB account for Ark for CDC to use on the Target DB (MariaDB) and assign the necessary permissions.
  4. Use Ark for CDC to replicate data from the Source DB (Oracle) to the Target DB (MariaDB).

Ark for CDC Architecture and Key Features

[Architecture]

  • Independent of OS and DB, with process modularization (supports process monitoring process)
  • Separation of message and data transmission ports, with separate protocol application
  • Standardized and efficient real-time 1:N data replication in a heterogeneous environment
  • Minimization of source system load through middleware (target-specific unique data)
Ark for CDC Architecture
Figure. Ark for CDC Architecture

[Key Features]

  • Heterogeneous DB replication

    • Support for major Target DBs
    • Support for various replication configurations (1:1, 1:N, N:1, etc.)

  • Data stability and consistency guarantee

    • Data transmission encryption (SSL, HTTPS)
    • Data consistency check and recovery function (Compare, Repair)

  • High performance

    • Direct Log Access method
    • Network load minimization for long-distance replication
    • Minimization of source server load through M/W architecture

  • Integrated monitoring and management function

    • CLI and GUI monitoring functions
    • Process status and replication status analysis
    • Mobile service linkage

Use Cases

  • Zero-downtime heterogeneous migration

    • Possible to migrate to a heterogeneous DB with zero downtime

  • Real-time data integration and replication

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

  • DR system construction

    • Possible to construct a DR system in various environments

Prerequisites

  • Apply for and install Ark for CDC on a Virtual Machine.
  • A VPN connection for secure communication with the customer’s on-premises data center must be established in advance.
  • The schema must be migrated in advance.
  • Ark for CDC Agent installation and DB account creation and permission assignment are required on the Source DB.
  • DB account creation and permission assignment are required on the Target DB.

Limitations

Ark for CDC only supports Oracle as the Source DB. When using Ark for CDC as a commercial solution, a license purchase agreement must be made in advance.

Solution Construction and Quote Inquiry

Related Products

  • Virtual Server
  • DB Service
  • VPN
  • VPC