tencent cloud

Feedback

Data Migration Specification

Last updated: 2024-04-30 17:05:38

    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.
    Specification
    Performance Limit (RPS)
    small
    2000
    medium
    5000
    large
    6000
    xlarge
    7000
    2xlarge
    > 7000

    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.

    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
    
    Contact Us

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

    Technical Support

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

    7x24 Phone Support