MySQL - MariaDB
M
MySQL - MariaDB

tap-mysql (matatika variant)

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

Meltano Cloud Connector

MySQL - MariaDB connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.