GuidesData Sync

Data Sync Quick Start

Tacnode provides efficient data synchronization services, enabling easy and rapid data import/export to and from the platform. It supports data sources such as MySQL, Postgres, Kafka and more, facilitating data synchronization and migration.

Feature Highlights

  • Synchronization for single tables, multiple tables, databases, and instances
  • Operations like field clipping, field mapping, and type conversion
  • Synchronization of sub-libraries and sub-tables to a designated logical table
  • Accommodates DDL changes, such as adding new tables and fields

Quick Start

Consider the synchronization between MySQL and Tacnode.

Network Connectivity

Typically, RDSs from cloud vendors require a whitelist configuration before access. Below are the public IP addresses necessary for data synchronization. Please add them to the RDS whitelist using the cloud vendor's prescribed method.

Cloud VendorRegionPublic IP
AWSaws-oregon54.188.106.226

Data Import Job

Select [Data Sync] -> [Data Import] from the left navigation panel, then click the [Data Import Job] button located in the upper right corner.

In the pop-up window, enter the job name and choose the data source type MySQL.

Nectwork Configuration

On the left, input the MySQL connection method and click the [Test Connection] button to check for a successful connection. On the right, choose the target Nodegroup and select [Test Connection] again to verify the connection. Source and target connections usually function if "Connection Successful" is displayed.

Select Objects

Check Data Sync Select Objects for a fast way to select or filter synchronization objects.

Map Objects

The default mapping method for this job is to map the MySQL Database table to the public schema of a Nodegroup. Refer to Data Sync Map Objects for details.

Set Policy

Start a Job

Once the job configuration is finalized, press the [Finish] button to initiate the job.

After the startup finishes, you can check the job status. See Job Operation for further details.

On this page