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 Vendor | Region | Public IP |
---|---|---|
AWS | aws-oregon | 54.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.