Why is Information Displayed in the DTS Console Overlapped?
If information in the DTS console is overlapped, the issue is caused by a small zoom ratio in most cases. We recommend that you set the zoom ratio to 100% for normal display.
Does the global binlog_format = ROW Configuration Take Effect Immediately After I Set it for a Source MySQL Database?
If the source database is a MySQL database and you need to run an incremental data migration or synchronization task, the value of binlog_format must be ROW. Otherwise, precheck fails. If you have set global binlog_format = ROW for the source database but the existing sessions still use a non-row-based logging mode, disconnect your business from the database and then reconnect to it.
Perform the following steps to set the global binlog_format = ROW configuration:
Connect your client to the MySQL server.
Run set global binlog_format = ROW; to set the global variable binlog_format = ROW.
Run select @@global.binlog_format; to check whether the variable configuration is successfully set.
To ensure that the variable takes effect after the database is restarted, add binlog_format=ROW to the startup configuration file of the MySQL database. Then, restart the database during off-peak hours.
Does the binlog_row_image = FULL configuration take effect immediately after I set it for a source MySQL database?
If the source database is a MySQL database and you need to run an incremental data migration or synchronization task, you must add the binlog_row_image = FULL configuration. Otherwise, precheck fails. If you set the global binlog_row_image = FULL configuration for the source database but the existing sessions still use a mode other than FULL, disconnect your business from the database and then reconnect to it.
Perform the following steps to set the global binlog_format = ROW configuration:
Connect your client to the MySQL server.
Run set binlog_row_image = FULL; to set the global variable binlog_row_image = FULL.
Run show global variables like 'binlog_row_image'; to check whether the variable configuration is successfully set.
To ensure that the variable takes effect after the database is restarted, add binlog_row_image=FULL to the startup configuration file of the MySQL database. Then, restart the database during off-peak hours.
What impacts will be brought on running DTS tasks if I increase the bandwidth of a DTS instance?
When increasing the bandwidth of a DTS instance, the network becomes unavailable. If the network interruption duration is short and the binlogs are not cleared, the tasks are interrupted and can be restored. If the network interruption duration is long and the system has cleared the binlogs of the source database based on the binlog clear strategy you set, the tasks cannot be restored.
How Can I Use DTS to Migrate/Synchronize Data from Multiple Sources to the Same Destination?
DTS supports many-to-one data migration and synchronization. That is, DTS can migrate and synchronize data from different instances and different tables to the same table.
Notes:
Before you migrate data from multiple tables to the same destination table, you must check whether the server of destination database instance has sufficient storage space. It is recommended that the remaining storage space of the destination database instance is at least 1.5 times of the data volume to be migrated.
DDL statements are not supported for data synchronization. If you use DDL statements for data synchronization, data synchronization may fail.
How Can I Use DTS to Migrate/Synchronize Data from a Database Instance to Multiple Destination Instances?
DTS supports one-to-many data migration and synchronization. That is, DTS can migrate and synchronize data from the same source database instance to multiple destination instances.
Notes:
To migrate or synchronize data from the same source database instance to multiple destination instances, you must create multiple data migration or synchronization tasks. Therefore, the workload on the source database instance increases. Before you create tasks, assess the workload on the source database instance and minimize the task count.
How Can I View Operation Logs in DTS?
DTS allows you to view operation logs. Currently, only task management operations are logged. To view operation logs, log in to the DTS console and click Operation Logs in left-side navigation pane.
Can I Restart a Completed Task?
A completed task cannot be restarted.
If you need to migrate or synchronize data on the same link again, create a new task.
Does DTS Provide a One-click Reverse Feature?
The current version of DTS does not provide a feature for reversing data migration direction. For MySQL-to-MySQL synchronization links, DTS provides the one-click primary-standby switchover feature.
If the Source is a MySQL Database Instance, Can a Data Synchronization Task Continue to Run After Primary/Standby Switchover?
If global transaction identifier (GTID) is enabled for the MySQL database instance, DTS can continue to run tasks to achieve data integrity after primary/standby switchover.
What Are the Differences Between the Data Synchronization Modes?
DTS supports the following data synchronization modes: entire database synchronization and partial object synchronization.
If you select to synchronize the entire database, DTS synchronizes all objects from the source database to the destination database and remain the same object names. If you enable incremental DDL synchronization, DTS synchronizes the new tables and objects that are added to the source database after the full data synchronization task is complete to the destination database.
If you select to synchronize some objects, you can specify the objects that you want to synchronize and configure object name mapping. In this mode, DTS does not synchronize the new objects that are added to the source database after the full data synchronization task is complete to the destination database.