Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Real-Time Jobs)/ Real-Time Migration Performance Test Data
Updated on 2025-07-25 GMT+08:00

Real-Time Migration Performance Test Data

The performance metrics of the real-time data migration link are for reference only. The performance at your site may be affected by factors such as the data source performance at the source or destination, network bandwidth, latency, and the data and service model. It is recommended that you check the speed with a small amount of data before migration.

Scenario

  • The migration resource group has 64 CUs (the Flink version is 1.15).
  • In the performance test, all tables contain 50 million rows of data. When the source is MySQL or Oracle, a table contains 14 columns. When the source is PostgreSQL, a table contains 16 columns.

Test Results

Table 1 shows the performance test results of common links.

Table 1 Test results of different links

Link

Migration Scenario

Concurrency

Source Version/Specifications

Source Version/Specifications

Table Columns

Length of a Row

(Bytes)

Job Input Rate

(MB/s)

Job Byte Rate

rec/s

MySQL > DWS

Incremental

1

MySQL 8.0/2U4G

DWS 8.1.3/4U32G

14

152

0.8

5535

Full and incremental

1

MySQL 8.0/2U4G

DWS 8.1.3/4U32G

14

152

0.9

5851

Incremental

5

MySQL 8.0/2U4G

DWS 8.1.3/4U32G

14

152

2.2

15303

Full and incremental

5

MySQL 8.0/2U4G

DWS 8.1.3/4U32G

14

152

2.8

19396

MySQL > Hudi

Incremental

1

MySQL 8.0/2U4G

MRS 3.2.0-LTS.1

14

152

1.3

8749

Full and incremental

1

MySQL 8.0/2U4G

MRS 3.2.0-LTS.1

14

152

1.4

9312

Incremental

5

MySQL 8.0/2U4G

MRS 3.2.0-LTS.1

14

152

2

13460

Full and incremental

5

MySQL 8.0/2U4G

MRS 3.2.0-LTS.1

14

152

3.6

24824

MySQL > Kafka

Incremental

1

MySQL 8.0/2U4G

2.3.0/2U4G

14

152

2.8

19287

Full and incremental

1

MySQL 8.0/2U4G

2.3.0/2U4G

14

152

2.6

17133

Incremental

5

MySQL 8.0/2U4G

2.3.0/2U4G

14

152

3

20303

Full and incremental

5

MySQL 8.0/2U4G

2.3.0/2U4G

14

152

9

61750

MySQL > Doris

Incremental

1

MySQL 8.0/2U4G

1.2.3/4u16g

14

152

1.1

7391

Full and incremental

1

MySQL 8.0/2U4G

1.2.3/4u16g

14

152

1.1

7335

Incremental

5

MySQL 8.0/2U4G

1.2.3/4u16g

14

152

1.8

12408

Full and incremental

5

MySQL 8.0/2U4G

1.2.3/4u16g

14

152

3.5

24108

Oracle > DWS

Incremental

1

Oracle 11g/8U32G

DWS 8.1.3/4U32G

14

152

0.9

4065

Full and incremental

1

Oracle 11g/8U32G

DWS 8.1.3/4U32G

14

223

1.2

5532

Incremental

5

Oracle 11g/8U32G

DWS 8.1.3/4U32G

14

223

1.3

6083

Full and incremental

5

Oracle 11g/8U32G

DWS 8.1.3/4U32G

14

223

6.3

29928

Oracle > Hudi

Incremental

1

Oracle 11g/8U32G

MRS 3.2.0-LTS.1

14

223

0.9

4164

Full and incremental

1

Oracle 11g/8U32G

MRS 3.2.0-LTS.1

14

223

1.7

7861

Incremental

5

Oracle 11g/8U32G

MRS 3.2.0-LTS.1

14

223

1

4734

Full and incremental

5

Oracle 11g/8U32G

MRS 3.2.0-LTS.1

14

223

2.7

12797

Oracle > Kafka

Incremental

1

Oracle 11g/8U32G

2.3.0/2U4G

14

223

1.2

5696

Full and incremental

1

Oracle 11g/8U32G

2.3.0/2U4G

14

223

2.8

13184

Incremental

5

Oracle 11g/8U32G

2.3.0/2U4G

14

223

1.2

5552

Full and incremental

5

Oracle 11g/8U32G

2.3.0/2U4G

14

223

7.8

37123

PostgreSQL > DWS

Incremental

1

PostgreSQL 16.8/2U4G

DWS 8.1.3/4U32G

16

175

1.1

5256

Full and incremental

1

PostgreSQL 16.8/2U4G

DWS 8.1.3/4U32G

16

175

1

4365

Incremental

5

PostgreSQL 16.8/2U4G

DWS 8.1.3/4U32G

16

175

1.4

6567

Full and incremental

5

PostgreSQL 16.8/2U4G

DWS 8.1.3/4U32G

16

175

2.4

11142

PostgreSQL > Hudi

Incremental

1

PostgreSQL 16.8/2U4G

MRS 3.2.0-LTS.1

16

175

1.3

5958

Full and incremental

1

PostgreSQL 16.8/2U4G

MRS 3.2.0-LTS.1

16

175

1.2

5554

Incremental

5

PostgreSQL 16.8/2U4G

MRS 3.2.0-LTS.1

16

175

1.7

7700

Full and incremental

5

PostgreSQL 16.8/2U4G

MRS 3.2.0-LTS.1

16

175

1.9

8584

Kafka > Hudi

Incremental

1

2.3.0/2U4G

MRS 3.2.0-LTS.1

40

1069

4.3

4154

Incremental

5

2.3.0/2U4G

MRS 3.2.0-LTS.1

40

1069

9.1

9291