SelectStar

Prerequisites

Before attempting to monitor your MariaDB database with SelectStar, ensure it meets the following criteria:

Supported MariaDB versions
Supported storage engines
  • 10.0
  • 10.1
  • XtraDB

Connection Information

The following information is required by SelectStar in order to monitor to your MariaDB databases:

Field
API Field
Description

Database

database

Name of the database in your instance to monitor

Host

host

Hostname or IP address of the system on which your database is running

Port

port

Port on which your database is listening [default: 3306]

Enable SSL

ssl_enable

Use SSL connections to your database [default: false]

Credentials

Field
API Field
Description

Username

username

MariaDB user

Password

password

User's password

Note

If using you are using SSL to connect to your database, your SSL certificate must be copied to your collector system prior to attempting to monitor your MariaDB database with SelectStar.

Access Rights

In order to access and return certain metrics from your database, specific privileges must be granted to the designated MariaDB user:

Slave Replication Metrics

In order to access these metrics, enable the REPLICATION CLIENT privilege.

Instance Metrics

In order to access these metrics, enable the PROCESS privilege. This grants access to the following metrics:

  • Instance Adaptive Hash
  • Index
  • Buffer
  • Buffer Page I/O
  • Change Buffer
  • Compression
  • DDL
  • DML
  • File System
  • ICP
  • Index
  • Lock
  • Metadata
  • OS
  • Purge
  • Recovery
  • Server
  • Transaction
  • Tablespace