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 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;

Enable performance_schema​

The performance_schema in MySQL provides detailed performance information which DBmarlin can use. It performance_schema is not found you will only have a subset of the performance data available in DBmarlin.

Tables such as threads, events_statements_summary_by_digest, events_statements_history_long, data_locks and data_lock_waits are used by DBmarlin to get SQL Statistics and Blocking Session information.

How to enable performance_schema​

  1. Edit the Configuration File

    Open your MariaDB config file (usually /etc/my.cnf or /etc/mysql/my.cnf, or a file under /etc/mysql/conf.d/). Add or modify the following under the [mysqld] section:

    [mysqld]
    performance_schema=ON
  2. Restart the Database

    sudo systemctl restart mysql
  3. Verify It’s Enabled

    SHOW VARIABLES LIKE 'performance_schema';
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.