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 MariaDB instance in the UI you should first create a dbmarlin user in the target database instance (you can choose to use a name other than dbmarlin if you prefer).
CREATE USER dbmarlin IDENTIFIED BY 'securepassword';
GRANT SELECT,PROCESS,SHOW DATABASES on *.* to 'dbmarlin'@'dbmarlinserver';
GRANT REPLICATION CLIENT ON *.* to 'dbmarlin'@'dbmarlinserver';
FLUSH privileges;
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.