GuidesData Sync

Data Sync Quick Start

Tacnode's Data Sync service provides efficient data synchronization capabilities, enabling easy and rapid data import/export to and from the platform. This quick start guide demonstrates how to create a synchronization job using MySQL as an example.

Feature Highlights

  • Flexible Scope: Synchronize single tables, multiple tables, entire databases, or complete instances
  • Data Transformation: Perform field filtering, field mapping, and type conversion
  • Shard Consolidation: Merge sub-databases and sub-tables into designated logical tables
  • Schema Evolution: Automatically handle DDL changes, including new tables and fields

Quick Start Example: MySQL to Tacnode

This example demonstrates synchronizing data from MySQL to Tacnode.

Step 1: Network Connectivity

Most cloud RDS services require IP whitelisting for external access. Add the following public IP addresses to your RDS whitelist according to your cloud provider's configuration method:

Cloud ProviderRegionPublic IP
AWSOregon (aws-oregon)54.188.106.226

Step 2: Create Data Import Job

  1. Navigate to Data SyncData Import in the left sidebar
  2. Click the Data Import Job button in the upper right corner

  1. In the dialog box, enter a descriptive job name and select MySQL as the data source type

Step 3: Configure Network Connection

  1. Source Configuration: Enter your MySQL connection details on the left panel and click Test Connection to verify connectivity
  2. Target Configuration: Select your target Nodegroup on the right panel and click Test Connection to verify connectivity

Both connections should display "Connection Successful" when properly configured.

Step 4: Select Objects

Choose which databases, schemas, and tables to synchronize. For detailed selection options and filtering capabilities, see Data Sync Select Objects.

Step 5: Map Objects

Configure how source objects map to destination objects. The default mapping places MySQL database tables into the public schema of your target Nodegroup. For advanced mapping options, see Data Sync Map Objects.

Step 6: Set Synchronization Policy

Configure synchronization behavior, including how to handle data conflicts and DDL changes.

Step 7: Launch the Job

  1. Review your configuration and click Finish to create the job
  2. Select appropriate resource allocation for your synchronization needs

  1. Monitor job status on the overview page

After the job starts successfully, you can monitor its progress and status. For detailed job management information, see Data Sync Job Operations.

On this page