Help Center/ Data Replication Service/ FAQs/ Product Consulting/ Do I Need to Stop Services Running on the Source Database?
Updated on 2024-09-25 GMT+08:00

Do I Need to Stop Services Running on the Source Database?

DRS tasks are classified into three modes: full, incremental, and full+incremental. Different data flow types support different modes.

  • Full migration: This migration type is suitable for scenarios where service interruption is permitted. It migrates all objects and data in non-system databases to the destination database at one time.
  • Incremental: In this mode, incremental data generated on the source database is continuously migrated to the destination database by parsing logs.
  • Full+Incremental: This migration type allows you to migrate data without interrupting services. After a full migration initializes the destination database, an incremental migration initiates and parses logs to ensure data consistency between the source and destination databases.

Tasks in incremental or full+incremental mode will not be automatically stopped. Incremental data generated on the source database will be continuously migrated to the destination database. You can determine whether to stop the tasks. For details, see When Can I Stop a Migration Task?.

When creating a task, you can select a mode as required. You do not have to stop services on the source database. However, you need to pay attention to the impact of full and incremental backup on the database in different phases. For details, see How Does MySQL Data Synchronization Affect the Source and Destination Databases?.