Data synchronization includes structure synchronization, full data synchronization, and incremental data synchronization. In structure synchronization, the structures of the objects in the source database are synchronized to the destination database. In full data synchronization, the existing data of the source destination is synchronized to the destination database. In incremental data synchronization, the incremental data generated during the synchronization process is synchronized to the destination database. This way, data consistency is ensured between the source database and the destination database. The data synchronization feature helps you synchronize data between different data sources in real time. This makes it suitable in various business scenarios such as active geo-redundancy, geo-disaster recovery, local disaster recovery, and real-time data warehousing.
Synchronization Types
| Synchronization Type | Description |
|---|---|
| Structure synchronization | DTS synchronizes the structures of the objects to be synchronized from the source database to the destination database. Tables, views, triggers, stored procedures, and other objects can be synchronized. |
| Full Data Sync | DTS synchronizes the existing data in the tables to be synchronized from the source database to the destination database. |
| Incremental Data Sync | DTS synchronizes the incremental data in the tables and databases to be synchronized to the destination database, including DML and certain DDL operations. |
Supported Database Types
Currently, DTS data synchronization tasks support the following database types.
| Source Database Type | Destination Database Type | Synchronization Type |
|---|---|---|
| RDS MySQL 5.7/8.0 and self-managed MySQL 5.6/5.7/8.0 | RDS MySQL 5.7/8.0 and self-managed MySQL 5.7/8.0 | A combination of structure synchronization, full data synchronization, and incremental data synchronization, and a combination of structure synchronization and incremental data synchronization |