Skip to main content

MySQL to SelectDB Real-Time Synchronization | NineData

MySQL-to-SelectDB synchronization is a common choice when transactional data needs to be moved into an analytical warehouse for reporting and faster query performance. NineData Data Replication supports full migration and incremental synchronization for this link.

When to use this workflow​

Use this workflow when you need to:

  • Build a SelectDB analytics layer from MySQL business data.
  • Keep analytical queries away from the MySQL production database.
  • Load existing MySQL rows into SelectDB and keep the target updated afterward.
  • Validate synchronization results before downstream teams use the target.

For detailed prerequisites, permissions, and task settings, see MySQL to SelectDB.

Before you begin​

Prepare the following items:

  • Access to the NineData console.
  • Connection information and accounts for the MySQL source and SelectDB target.
  • Binlog enabled on the MySQL source when incremental replication is required.
  • Required permissions on both systems.
  • Network connectivity from NineData to both systems.

Step 1: Add the source and target data sources​

  1. In the NineData console, open Data Source Management > Data Source, and then create the MySQL and SelectDB data sources.

    Create MySQL and SelectDB data sources

Step 2: Create the synchronization task​

  1. Create a replication task for the MySQL source and SelectDB target.

  2. Select the replication types required for the task.

  3. Choose the source objects and configure mapping if needed.

  4. Run the precheck, fix any failed item, and start the task after the precheck passes.

    Task details and replication views Replication type details

Step 3: Monitor the task​

After the task starts, use the task details page to monitor progress and validate the target.

  • View task details.

  • Review replication phase progress.

  • Check data comparison results.

  • Apply throttling if the task uses too many source or target resources.

    Data comparison Replication throttling

Step 4: Configure alerts​

Configure alerts so operators are notified when the task fails or replication delay becomes too high.

Configure alerts

Step 5: Modify synchronization objects​

If the replication scope changes, update the synchronization objects from the task details page.

Modify synchronization objects

Result​

After full migration completes, incremental replication keeps SelectDB aligned with new MySQL changes. When synchronization is stable and validation passes, use the SelectDB target for analytics, reporting, and downstream warehouse workloads.