
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
MySQL - MariaDB connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.