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
Kafka > Hudi	Incremental	5	2.3.0/2U4G	MRS 3.2.0-LTS.1	40	1069	9.1	9291