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.
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, DELETE, and PROCESS 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
Create a MySQL SSH Destination on Kondado
Set up a MySQL or MariaDB destination on Kondado using an SSH tunnel (bastion server) for secure database connectivity.
Prepare your SSH tunnel server
Ensure your intermediate bastion server is accessible to Kondado's IPs and can reach your database on port 3306. Review security requirements for IP allowlisting before proceeding.
Configure database permissions and settings
Create a database user with DROP, INSERT, CREATE, ALTER, SELECT, DELETE, and PROCESS permissions. Disable sql_require_primary_key and STRICT_TRANS_TABLES settings, as these are commonly enabled by default on cloud providers like Digital Ocean.
Add the MySQL SSH destination on Kondado
Log in to the Kondado platform, navigate to the destinations page, click "New Destination," and select MySQL SSH.
Enter SSH tunnel server details
Fill in the Server Address, Server port, Server user, and paste the Server PEM Key text for your bastion server that will tunnel connections to your database.
Enter database connection details
Provide the Database address, Database port (usually 3306), Database User, Database Password, and Database name (dbname). Click save to create your destination.
