tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServiceProduct IntroductionSpecification DescriptionData Migration Specification
Data Migration Specification
Download PDF
Last updated: 2024-12-30 15:33:31
Data Migration Specification
Last updated: 2024-12-30 15:33:31
Download PDF

Parameter Description

When purchasing a DTS task, users need to select the specification of the task. Different specifications correspond to different transfer performances. Transfer performance is represented by RPS.
RPS represents the number of rows per second that DTS incrementally migrates from the source database to the target database. For example, if 2000 rows of data are incrementally migrated from the source database to the target database per second, then the RPS is 2000.

Specification

The following specifications are available for the data migration link.
Note：
The RPS (Requests Per Second) may be influenced by several factors including the configuration of the source database, network latency, and the complexity of the data in the source database. The following RPS performance reference for DTS (Data Transfer Service) is based on a benchmark of 1KB per data record. Utilizing larger data records in actual scenarios may result in a decrease in RPS.
Specification
Performance Limit (RPS)
small
2000
medium
5000
large
6000
xlarge
7000
2xlarge
11000

Test Model

Test procedure: Create an incremental migration task between two TencentDB MySQL instances, conduct stress testing on the source database MySQL, and monitor the performance of incremental data migration.
Instance
MySQL Instance Configuration
Reference Limit Performance
Source Database
Instance Specifications: 16-core 32000 MB
Memory: 200 GB
Maximum QPS: 12000
Maximum IOPS: 32000
Target Database
Instance Specifications: 16-core 32000 MB
Memory: 200 GB
Maximum QPS: 12000 Maximum IOPS: 32000
Test Model:
Number of test tables is 20. Each table has about 2 million records. Each record is about 1 KB.
All test tables have a primary key.
Each Transaction generally contains two DML operations, one is COMMIT, with the ratio of INSERT, UPDATE, DELETE being 1:1:1.
Note：
The test results in this section are based on a benchmark of 1KB per data record. In practical applications, larger data records may result in a decrease in Requests Per Second (RPS).

Test Results

After stress testing the small, medium, and large specifications, the results show that the RPS provided by DTS can be achieved under all specifications. Even in scenarios with the maximum network latency, the RPS performance can reach the upper limit in cross-region (China to global) migration results.
Migration Region Type
Maximum Network Latency
Minimum Network Latency
Specification
RPS
Intra-region (China): Guangzhou > Guangzhou
3.46 ms
2.14 ms
small
2000
2.51 ms
2.21 ms
medium
5000
10.1 ms
2.20 ms
large
6000
Cross-region (China): Guangzhou > Beijing
37.6 ms
33 ms
small
2000
68.2 ms
33.2 ms
medium
5000
48.2 ms
36.4 ms
large
6000
Intra-region (Global): Singapore > Singapore
697 μs
240 μs
small
2000
376 μs
273 μs
medium
5000
241 μs
2.11 ms
large
6000
Cross-region (global): Singapore > Silicon Valley
200 ms
174 ms
small
2000
201 ms
175 ms
medium
5000
204 ms
175 ms
large
6000
Cross-region (China to global): Guangzhou > Silicon Valley
255 ms
162 ms
small
2000
309 ms
151 ms
medium
5000
174 ms
152 ms
large
6000
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon