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.
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.
The hostname or IP address of the MySQL/MariaDB server.
The port number to use for the connection.
The username to use for authentication.
The password to use for authentication.
The name of the database to connect to.
The class to use for the cursor.
The server ID to use for replication.
A list of databases to include or exclude from replication.
Whether to use global transaction identifiers for replication.
The storage engine to use for the connection.
Whether to use SSL encryption for the connection.
The path to the SSL CA certificate file.
The path to the SSL certificate file.
The path to the SSL key file.
The internal hostname to use for the connection.
A list of SQL statements to execute when the connection is established.
Address of the bastion host, this is the host we'll connect to via ssh
Port to connect to bastion host
A base64 encoded Private Key for authentication to the bastion host w/ key pair auth
Private Key Password, leave None if no password is set
Username to connect to bastion host
Password to connect to bastion host w/ basic auth
Extract, Transform, and Load MySQL - MariaDB data into your data warehouse or ours.