🔌Add a MySQL connector

Connector features

You can use the Toucan MySQL connector to connect to a mySQL cluster with a basic authentication and/or a chain certificate and access tables with a SQL query or by using our no-code form .

With this connection, you can fetch data from your mySQL to fill your charts and dashboards.

Changelog

July 25 - This data connector is supported for connection and NativeSQL by our new Data Execution system

Configuring a MySQL connection

Follow the steps described in Add a connector, choose MySQL and fill out the form with the following info:

Field	Format / Type	Description	Example
Name (mandatory)	String	Use it to identify your connection	MySQLConnection
Host (mandatory)	String	The domain name or IP address of your database server	"db.example.com" or "192.168.1.100"
Port (mandatory)	String	The listening port of your database server	3306
User (mandatory)	String	Your login user	myuser
Password (mandatory)	String	Your login password (this value will be stored as a secret)	secretpassword123
Charset (optional)	String	Character encoding for the connection	"utf8mb4" (default value)
Charset Collation (optional)	String	The charset's collation for server connections	"utf8mb4_unicode_ci"
Connect Timeout (optional)	Integer	Connection timeout in seconds	30
SSL Mode (optional)	Enum	SSL Mode for MySQL server connection Options: VERIFY_IDENTITY, VERIFY_CA, REQUIRED	VERIFY_CA
SSL CA	String	CA certificate content in PEM format	-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----
SSL Cert	String	X509 certificate content in PEM format	-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----
SSL Key	String	X509 certificate key content in PEM format	-----BEGIN PRIVATE KEY-----\nMIIE...\n-----END PRIVATE KEY-----
Retry Policy (optional)	Boolean	Boolean allows to configure a retry policy if the connection is flaky. max attempts: maximum number of retries before giving up max_delay: in seconds, above the connection is dropped wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)	Integer	Slow queries' cache expiration time in seconds

• Click on the TEST CONNECTION button then SAVE the connection

  After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Create a dataset from a MySQL connection

This data connector is supported in

• code/SQL mode for our current Data Execution system

• both modes with our new Data Execution System

To create a dataset from MySQL, click on the "create from icon", you will then be able to:

• Select the Database

• Select the Schema

• Select Table or Views

• Only keep columns you need

For more info, see the dedicated section Create a new dataset from a dataset

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".