MySQL SSH

MySQL is an open source relational database that powers many applications and is one of the most popular databases in the world. By using MySQL as a data destination on the Kondado platform, you can create your Data Warehouse using both MySQL and MariaDB.

SSH pipeline differs from traditional pipeline in that it connects to the database through an intermediate server, also called a tunnel or bastion.

If you want to use the MySQL destination directly (without an intermediate SSH server) see this article

Before adding the database, make sure that the intermediate server is accessible to our IPs that are listed here and that the intermediary server can access the database on the port that will be used (generally 3306), then follow the steps below:

1) Login to the Kondado platform

2) Navigate to add destinations page click “New Destination” and select the MySQL SSH destination

3) Fill in your database information as shown below:

Name: This is the internal description of your destination on the Kondado platform

Server Address: The address of the intermediary server that will access your database

Server port: The passthru server port that will access your database

Server user: The passthru server user who will access database

Server PEM Key: The text of the file with the PEM key for passthru server access

Database address: The server address of your database

Database port: The port of your database (usually 3306)

Database User: The username Kondado will use to enter data into your database. This user must have DROP, INSERT, CREATE, ALTER, SELECT and DELETE permissions

Database Password: The database user's password

Database: the name of the database (dbname)

Click save and your new destination will be created!

ATTENTION

a) The sql_require_primary_key parameter must be disabled – it is common for clouds like Digital Ocean to leave it enabled

b) Settings such as STRICT_TRANS_TABLES that require values in all columns (default value constraint) must be disabled