MySQL Data Source Configuration Guide

Overview

MySQL is a widely used open-source relational database management system. By configuring a MySQL data source, you can achieve efficient data synchronization and integration, supporting various data operations and analysis tasks.

Parameter Configuration

When configuring a MySQL data source, you need to provide the following information to ensure a successful connection to the database:

Data Source Name: Specify a unique and easily recognizable name for your data source, such as MySQLSource01.
JDBC Connection URL: Fill in the JDBC connection URL of the MySQL database, usually in the format jdbc:mysql://host:port/dbname. For example, if your database is on the host server, the port is 3306, and the database name is db01, the URL would be jdbc:mysql://host:3306/db01.
Username: Enter the username used to connect to the MySQL database, such as user01.
Password: Provide the database password corresponding to the username, such as password.
Data Source Description: (Optional) Add descriptive information for the data source to help you or other administrators understand the purpose or characteristics of the data source.

Connection Configuration

For connection configuration, you can choose one of the following two methods:

Direct Connection: Ensure that the connection information you entered is accessible over the public network. If the source has an IP access whitelist enabled, make sure the outbound IP address of the data integration service has been added to the whitelist. For specific IP addresses, please contact technical support.
Via SSH Tunnel: To enhance security, you can choose to connect to datasource via an SSH tunnel. Enable this option and provide the following SSH tunnel-related configuration information:
- SSH Server Address: Provide the IP address or domain name of the SSH server.
- SSH Port: Specify the port number on which the SSH server is listening, usually 22.
- Username: Provide the login username for the SSH server.
- Password: Provide the password corresponding to the SSH server login username.

Notes

Ensure that all provided connection information is accurate and that the MySQL service is accessible.
Protect your database credential information to avoid leakage to unauthorized personnel.
Regularly check and update your data source configuration to adapt to changes in the database structure or new security requirements.
Monitor the running status of data synchronization tasks to promptly identify and resolve any potential issues.

After completing the configuration, you can select this MySQL data source in data synchronization tasks to perform data import or export operations.