MySQL - MariaDB Connect

MySQL - MariaDB data into your data warehouse in minutes

Collect MySQL - MariaDB data into your data warehouse or ours. The Matatika pipelines will take care of the data collection and preparation for your analytics and BI tools.

Automate MySQL - MariaDB from a single space with no code

MySQL and MariaDB are popular open-source relational database management systems.

MySQL and MariaDB are powerful and flexible database management system that allows users to store, organize, and retrieve data efficiently. It is widely used in web applications and is known for its reliability, scalability, and ease of use. MySQL and MariaDB support a wide range of programming languages and platforms, making it a popular choice for developers and businesses of all sizes. It offers features such as transaction support, replication, and clustering, and can be used for a variety of applications, from small personal projects to large enterprise systems. Overall, MySQL/MariaDB is a versatile and reliable database management system that is widely used in the industry.

Settings

Host

The hostname or IP address of the MySQL/MariaDB server.

Port

The port number to use for the connection.

User

The username to use for authentication.

Password

The password to use for authentication.

Database

The name of the database to connect to.

Cursor Class

The class to use for the cursor.

Server ID

The server ID to use for replication.

Filter DBs

A list of databases to include or exclude from replication.

Use GTID

Whether to use global transaction identifiers for replication.

Engine

The storage engine to use for the connection.

SSL

Whether to use SSL encryption for the connection.

SSL CA

The path to the SSL CA certificate file.

SSL Certificate

The path to the SSL certificate file.

SSL Key

The path to the SSL key file.

Internal Hostname

The internal hostname to use for the connection.

Session SQLs

A list of SQL statements to execute when the connection is established.

SSH Tunnel Host

Address of the bastion host, this is the host we'll connect to via ssh

SSH Tunnel Port

Port to connect to bastion host

SSH Tunnel Private Key

A base64 encoded Private Key for authentication to the bastion host w/ key pair auth

SSH Tunnel Private Key Password

Private Key Password, leave None if no password is set

SSH Tunnel Username

Username to connect to bastion host

SSH Tunnel Password

Password to connect to bastion host w/ basic auth


View source code

MySQL - MariaDB data you can trust

Extract, Transform, and Load MySQL - MariaDB data into your data warehouse or ours.

Interested in learning more?

Get in touch