MySQL

An overview of the MySQL integration with Seda

MySQL Metadata Extracted

Getting Started with MySQL

There are three steps to get started using MySQL with Seda:

1. Create a database user

2. Connect MySQL to Seda

3. Whitelist Seda IP Address

Create a Database User

The username and password you’ve already created for your cluster is your admin password, which you should keep for your own usage. For Seda, and any other 3rd-parties, it is best to create distinct users.

To create a new user, you’ll need to log into the MySQL database directly and run the following SQL commands:

-- Create a user named "secoda" that Secoda will use when connecting to your MySQL database. 
CREATE USER 'secoda'@'localhost' IDENTIFIED BY '<enter password here>'; 

-- Complete this query for any databases you would like Secoda to extract from
GRANT SELECT ON <database_name>.* TO 'secoda'@'localhost';

-- Complete this query for any schemas you would like Secoda to extract from
GRANT SELECT ON <schema_name>.* TO 'secoda'@'localhost';

When connecting to MySQL in Seda, use the username/password you’ve created here instead of your admin account.

Connect MySQL to Seda

After creating a MySQL user, the next step is to connect Seda:

1. In the Seda App, select ‘Add Integration’ on the Integrations tab

2. Search for and select "MySQL"

3. Enter your MySQL credentials

4. Click 'Connect'

Security

VPCs keep servers inaccessible to traffic from the internet. With VPC, you’re able to designate specific web servers access to your servers. In this case, you will be whitelisting the Seda IPs to read from your data warehouse.

Allow Seda to read into your MySQL database using the Seda IP address.