Overview

MariaDB is the community-developed fork of MySQL, created after Oracle’s acquisition of MySQL and maintained as a compatible replacement. Its practical significance is distribution packaging: Red Hat Enterprise Linux, Rocky, Debian and most other major Linux distributions ship MariaDB as the default MySQL-compatible database. That means a large share of packaged Linux applications, appliance back ends and internally built tools that describe themselves as running on MySQL are in fact running on MariaDB.

The ReadyWorks connector connects directly to a MariaDB server over the network using the mysql.php driver, the same driver the Oracle MySQL connector uses, with a username and password. A job carries a SQL statement in its Data Selection field, ReadyWorks runs it, and the result set is written to the destination staging table with one column per selected column.

In a ReadyWorks context this is how you read application data on a Linux estate without waiting for the application team to build an export. Ticketing, licensing, monitoring and internal asset tools that store their data in MariaDB can be queried directly and joined to device and identity data in the data fabric.

The connector is inbound only. It reads query results and writes staging tables, and it issues no writes to the source database.

NOTE: This connector and the Oracle MySQL connector run the same driver. Choosing the one that matches what the server actually runs keeps the connection list an accurate picture of the estate, which matters when someone later has to work out what a job reads.

Connector Properties

Authentication Methods

One method ships: a direct network connection with a database username and password.

NOTE: The connection form has no field for TLS, certificate verification or a CA bundle. Place the ReadyWorks server and the MariaDB server on a network path you trust, or front the connection with a tunnel.

Method 1: Username / Password (MariaDB_user)

Connect to a MariaDB Server

Username / Password connects to the MariaDB server named in Source Server on the port given in Source Server Port (the default is 3306), authenticates with the supplied credentials, and selects the database named in Source DB Name. All five fields are required. The password is stored encrypted.

Connection Configuration Fields (5)

No authentication recipe is stored. The driver script authenticates natively using the fields above.

Inbound Job Fields Enabled (13)

These are the job-level settings exposed for a MariaDB extract. Data Selection holds the SQL statement.

Inbound Job Templates (1)

One inbound template ships as a worked example. It arrives disabled and carries a placeholder query, so it is a pattern to copy rather than a job to enable.

Job Template Configuration

Settings

Job Parameters and Enumeration

MariaDB SQL Table Data

Data Selection: SELECT * FROM {tablename}

Outbound Job Templates (0)

This connector ships no outbound templates and does not support outbound jobs.