MySQL connection

MySQL is a popular open-source relational database management system (RDBMS) that is used for managing and storing data in various applications and websites. MySQL provides reliability, scalability, and performance, making it a top choice for database applications.

You can seamlessly integrate and use MySQL within the Data Integration data integration platform.

MySQL compatible configurations

The following MySQL database services are compatible with Data Integration:

• On-premise MySQL
• Amazon RDS/Aurora MySQL

MySQL compatibility versions

River modes	Versions supported	Support for managing schema drift
Standard Extraction	All Versions	Yes
Change Data Capture (CDC)	MySQL 5.6 and Above, or MySQL 8.0 and Above	Yes

Establishing a connection

Before setting up a connection, ensure that you have your MySQL database credentials, and whitelist the Data Integration’s IP addresses on your database firewall.

Step 1: whitelist IP addresses

• Ensure that Data Integration IP addresses are whitelisted in your database firewall.
• If using the EU server, there are four IP addresses to whitelist. Refer to the Data Integration IP Whitelist for more details.

Note: Ensure that Data Integration IP addresses are whitelisted in your database firewall.

Step 2: Define connection credentials

1. Click Connections and select + New Connection.
2. Choose MySQL.
3. In Mysql connection pop-up, enter the following details:
   • Host: Your MySQL database host.
   • Port: The port number for the MySQL connection.
   • Database: Your database name.
   • Username: Your MySQL database username.
   • Password: Your MySQL database password.

Establishing an SSH connection

If your MySQL database is hosted on an on-premises server, use SSH tunneling for a secure connection.

Step 1: Configure SSH tunnel server

• Set up your SSH tunnel server to enable connections from Data Integration IP addresses.
• Ensure the SSH tunnel can connect to your MySQL database using the internal IP address.

Step 2: Define SSH options

In the SSH Options section, configure the following details:

• SSH Hostname: The hostname of your SSH tunnel server.
• SSH Port: Set to 22 by default.
• Username: The username used to authenticate the SSH connection.
• Password: (Optional) If required by the SSH server.
• SSH PEM Key: Upload the private key for SSH authentication (recommended).
• PEM Key Password: If your PEM key is password-protected, provide the password.

Enabling SSL for secure connections

SSL (Secure Sockets Layer) is a cryptographic protocol that secures and encrypts data transmission. If your database requires an SSL connection:

1. Go to the SSL Options section.
2. Upload your SSL Key File in the designated field. For more details on SSL configuration, refer to our SSL Connection topic.

Test the connection

After defining all credentials and settings:

1. Test the connection to ensure everything is configured correctly.
2. If the connection test is successful, Save your connection.