What Are the Differences Between Real-Time Migration, Real-Time DR, and Real-Time Synchronization?

Scenario

Real-time migration is applicable to 1:1 database migration scenarios, including migration between different cloud platforms, from on-premises databases to cloud databases, or on cloud databases across regions.

Real-time synchronization is suitable for scenarios where data in databases needs to be synchronized for a long time, such as database aggregation (many-to-one), database splitting (one-to-many), heterogeneous database conversion, and data synchronization filtering.

Real-time DR is used for logical DR of MySQL databases, including disaster recovery between on-premises databases and cloud databases, or between databases across cloud platforms.

Characteristics

1. Homogeneous databases are migrated as a whole.
2. Tables, data, indexes, views, stored procedures, functions, database accounts, and database parameters can be migrated.
3. You can choose to migrate all objects, tables, or databases based on your service requirements.

1. Homogeneous and heterogeneous databases are synchronized to maintain continuous data flow between different applications.
2. Tables and data can be synchronized to meet various flexibility requirements.
3. Objects can be synchronized at the table level or database level.

1. Data disaster recovery between homogeneous databases can be performed.
2. The remote primary/standby switchover can be achieved.
3. Instance-level disaster recovery is supported. You cannot select databases or tables as objects.

Supported databases

For details, see Migration Overview.

For details, see Synchronization Overview.

For details, see DR Overview.

Functions and features

Users can be migrated.

Users cannot be migrated.

By default, all users are migrated. You cannot select the users to be migrated.

Parameters can be compared.

Parameters cannot be compared.

Parameters can be compared.

Migration objects cannot be edited in the incremental phase.

Synchronization objects can be edited in the incremental phase, and added or deleted dynamically.

Disaster recovery objects cannot be edited in the incremental phase.

Object name mapping is not supported.

Object names mapped to the destination database can be changed, so the names of tables and databases in the source and destination databases can be different.

Object name mapping is not supported.

Data processing is not supported.

Data processing is supported. You can add rules, such as data filtering and column processing, for selected objects.

Data processing is not supported.

Primary/Standby switchover is not supported.

Primary/Standby switchover is not supported.

Primary/Standby switchover is supported.

Billing

Only pay-per-use billing is supported.

Both pay-per-use and yearly/monthly billing modes are supported.

Both pay-per-use and yearly/monthly billing modes are supported.

Remarks

Different data flows support different functions and features. For details, see Precautions.

Different data flows support different functions and features. For details, see Precautions.

Different data flows support different functions and features. For details, see Precautions.