Skip to main content

MariaDB

Pre-requisites

Check the supported versions

DBmarlin supports most versions of MariaDB from 10.0 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions

Before adding a target MySQL instance in the UI you should first create a dbmarlin user in the target database instance.

CREATE USER dbmarlin IDENTIFIED BY 'securepassword';
GRANT SELECT,PROCESS,SHOW DATABASES on *.* to 'dbmarlin'@'dbmarlinserver';
GRANT REPLICATION CLIENT ON *.* to 'dbmarlin'@'dbmarlinserver';
FLUSH privileges;
info

Replace dbmarlinserver above with the IP or hostname of the server where you installed DBmarlin.

Adding the Database Target

This is done through the User Interface using the Add Database screen

SkySQL

We have certified that DBmarlin works with MariaDB SkySQL which is the cloud hosted DBaaS (database-as-a-service) from MariaDB. The SkySQL CA certs required are bundled with 1.11 of DBmarlin so no manual steps are required to import certificate files. Setting up a sensor is just like any other, except for one extra TLS parameter ?enabledTLSProtocols=TLSv1.2 which you can add to the Connection string under Advanced mode. See our SkySQL blog for more.