This topic describes the specifications of each data synchronization channel and provides performance testing results.

Precautions

The performance indicators provided in this document are only used for reference and are not used as a criterion for product SLA evaluation.

Terms

  • specification: DTS provides data synchronization channels that are configured with different specifications. The performance of these channels depends on the number of synchronized records.
  • RPS: the number of SQL statements that are synchronized per second, including BEGIN operation, COMMIT operation, DML statements (INSERT, UPDATE, and DELETE operations), and DDL statements.

Specifications of data synchronization channels

DTS offers four specifications for data synchronization channels based on their maximum performance: micro, small, medium, and large. The synchronization performance of each specification can reach the maximum performance if the following conditions are met:
  • The pressure on the source instance must be greater than or equal to the maximum performance that corresponds to each specification.
  • The destination instance does not have bottlenecks in write performance and supports the performance pressure that corresponds to each specification.
  • The network latency between the DTS server and the source or destination instance is less than or equal to 2 milliseconds.
Specification Maximum performance (RPS)
micro Less than 200
small 200 to 2,000
medium 2,000 to 5,000
large Unlimited
Note The online running performance of the large specification depends on the network environment and the performance of the source and destination instances.