Updated on 2024-03-28 GMT+08:00

Real-Time Synchronization

Precautions

The performance indicators provided in this section are for reference only. The actual environment is affected by factors such as the performance of the source or destination database, network bandwidth, data model, and service model.

Specifications

Based on the performance of data flow types, there are five types of specifications: micro, small, medium, large, and ultra-large. Table 1 lists the performance upper limit of each specification.

Table 1 Performance upper limit

Specifications

Reference Values of Maximum Performance (Rows/Second)

Micro

300

Small

3,000

Medium

7,500

Large

10000

Ultra-large

20000

  • The performance of each specification is affected by factors such as the networks, source and destination database performance, and latency. The values in the table are for reference only.
  • DRS measures the performance of different specifications using the full (with flow control disabled) and incremental synchronization tasks as the standard.
  • The maximum performance (row/second) is measured by the number of transactions synchronized per second. The statement types include BEGIN, COMMIT, DML (INSERT, DELETE, and UPDATE), and DDL. You can view the destination database write frequency (apply_rows_rate) monitoring metric on Cloud Eye.
  • DRS allows you to upgrade specifications only for single-AZ synchronization tasks. Task specifications cannot be upgraded for dual-AZ tasks or downgraded. For details, see Changing Specifications.
  • If you want to compare values for a DRS task, select large or ultra-large specifications when creating the DRS task.

Testing Models

Create a full+incremental real-time synchronization task for two RDS for MySQL instances. Table 2 shows the instance configurations.

Table 2 Instance specifications

Parameter

Source RDS for MySQL instance

Destination RDS for MySQL instance

Flavor

c6.4xlarge.4 (general-enhanced II)

c6.4xlarge.4 (general-enhanced II)

Instance specifications

Ultra-high I/O

Ultra-high I/O

Storage type

16 vCPUs|64 GB

16 vCPUs|64 GB

Storage space

300 GB

300 GB

Maximum connections

18,000

18,000

Maximum QPS

3,325

3,325

Maximum IOPS

114,152

114,152

Test model:

  • The number of test tables is 20.
  • All test tables have primary keys.
  • The record size is 1 KB.
  • Each transaction contains two DML operations and one COMMIT operation. The ratio of INSERT, UPDATE, and DELETE operations is 1:1:1.

Multiple Specifications

DRS real-time synchronization allows you to select specifications for some specified data flow tasks.

Table 3 Data flow types that support multiple specifications

Synchronization Direction

Data Flow

Multiple Specifications

Specification Upgrade

To the cloud

MySQL->MySQL

Supported

Supported only for single-AZ tasks

To the cloud

MySQL->PostgreSQL

Supported

Supported only for single-AZ tasks

To the cloud

MySQL -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

To the cloud

MySQL -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

To the cloud

MySQL->GaussDB(DWS)

Supported

Supported only for single-AZ tasks

To the cloud

MySQL->GaussDB(for MySQL)

Supported

Supported only for single-AZ tasks

To the cloud

MySQL->MariaDB

Not supported

Not supported

To the cloud

PostgreSQL->PostgreSQL

Supported

Supported only for single-AZ tasks

To the cloud

PostgreSQL->GaussDB(DWS)

Not supported

Not supported

To the cloud

PostgreSQL -> GaussDB Primary/Standby

Not supported

Not supported

To the cloud

PostgreSQL -> GaussDB Distributed

Not supported

Not supported

To the cloud

DDM->MySQL

Supported

Supported only for single-AZ tasks

To the cloud

DDM->GaussDB(DWS)

Supported

Supported only for single-AZ tasks

To the cloud

DDM->DDM

Supported

Supported only for single-AZ tasks

To the cloud

Oracle->GaussDB(DWS)

Supported

Supported only for single-AZ tasks

To the cloud

Oracle->PostgreSQL

Supported

Supported only for single-AZ tasks

To the cloud

Oracle->MySQL

Supported

Supported only for single-AZ tasks

To the cloud

Oracle->GaussDB(for MySQL)

Supported

Supported only for single-AZ tasks

To the cloud

Oracle -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

To the cloud

Oracle -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

To the cloud

Oracle->DDM

Supported

Supported only for single-AZ tasks

To the cloud

DB2 for LUW -> GaussDB Primary/Standby

Not supported

Not supported

To the cloud

DB2 for LUW -> GaussDB Distributed

Not supported

Not supported

To the cloud

DB2 for LUW->GaussDB(DWS)

Not supported

Not supported

To the cloud

TiDB->GaussDB(for MySQL)

Not supported

Not supported

To the cloud

Microsoft SQL Server->GaussDB(DWS)

Not supported

Not supported

To the cloud

Microsoft SQL Server -> GaussDB Primary/Standby

Not supported

Not supported

To the cloud

Microsoft SQL Server -> GaussDB Distributed

Not supported

Not supported

To the cloud

Microsoft SQL Server->Microsoft SQL Server

Not supported

Not supported

To the cloud

MongoDB->DDS

Supported

Supported only for single-AZ tasks

To the cloud

MariaDB->MariaDB

Supported

Supported only for single-AZ tasks

To the cloud

MariaDB->MySQL

Not supported

Not supported

To the cloud

MariaDB->GaussDB(for MySQL)

Not supported

Not supported

To the cloud

GaussDB(for MySQL)->GaussDB(for MySQL)

Supported

Supported only for single-AZ tasks

From the cloud

MySQL->MySQL

Supported

Supported only for single-AZ tasks

From the cloud

MySQL->Kafka

Supported

Supported only for single-AZ tasks

From the cloud

MySQL->CSS/ES

Supported

Supported only for single-AZ tasks

From the cloud

MySQL->Oracle

Supported

Supported only for single-AZ tasks

From the cloud

MySQL->MariaDB

Not supported

Not supported

From the cloud

DDM->MySQL

Supported

Supported only for single-AZ tasks

From the cloud

DDM->Oracle

Supported

Supported only for single-AZ tasks

From the cloud

DDM->Kafka

Supported

Supported only for single-AZ tasks

From the cloud

DDS->MongoDB

Supported

Supported only for single-AZ tasks

From the cloud

DDS->Kafka

Supported

Supported only for single-AZ tasks

From the cloud

PostgreSQL->PostgreSQL

Supported

Supported only for single-AZ tasks

From the cloud

PostgreSQL->Kafka

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> MySQL

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> Oracle

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> Kafka

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> GaussDB(DWS)

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Primary/Standby -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed -> MySQL

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed -> Oracle

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed -> GaussDB(DWS)

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed -> Kafka

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB Distributed->GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB(for MySQL)->MySQL

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB(for MySQL)->GaussDB(DWS)

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB(for MySQL)->Kafka

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB(for MySQL)->CSS/ES

Supported

Supported only for single-AZ tasks

From the cloud

GaussDB(for MySQL)->Oracle

Supported

Supported only for single-AZ tasks

From the cloud

MariaDB->MariaDB

Supported

Supported only for single-AZ tasks

From the cloud

Microsoft SQL Server->Kafka

Not supported

Not supported

Self-built -> Self-built

MySQL->Kafka

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

MySQL->CSS/ES

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

MySQL -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

MySQL -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

Oracle->Kafka

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

Oracle -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

Oracle -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

PostgreSQL->Kafka

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Primary/Standby -> MySQL

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Primary/Standby -> Oracle

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Primary/Standby -> Kafka

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Primary/Standby -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Primary/Standby -> GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Distributed -> MySQL

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Distributed -> Oracle

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Distributed -> Kafka

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Distributed->GaussDB Primary/Standby

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

GaussDB Distributed -> GaussDB Distributed

Supported

Supported only for single-AZ tasks

Self-built -> Self-built

DB2 for LUW -> GaussDB Primary/Standby

Not supported

Not supported

Self-built -> Self-built

DB2 for LUW -> GaussDB Distributed

Not supported

Not supported

Self-built -> Self-built

Microsoft SQL Server->Kafka

Not supported

Not supported