MariaDB Monitoring Template
Telegraf Plugins used:
- MySQL Input Telegraf Plugin
- InfluxDB 2.0 Output Telegraf Plugin
Included Resources:
- 1 Telegraf Configuration:
'mysql-mariadb' - 1 Dashboards:
'MySQL - MariaDB' - 1 Label:
'mysql' - 1 Bucket:
'mariadb'
Quick Install
If you have your InfluxDB credentials configured in the CLI, you can install this template with:
https://raw.githubusercontent.com/influxdata/community-templates/master/mysql_mariadb/mysql_mariadb.yml
MariaDB monitoring dashboard
MariaDB Server is one of the most popular open source relational databases created by the original developers of MySQL. It is a community-based, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License.
Why Monitor MariaDB?
MariaDB can be used with your web application, for stand-alone applications ranging from enterprise transactional and analytical systems down to mobile devices, embedded with other software. As the backbone to these use cases, it is imperative that you keep your MariaDB instance functioning and performant. Therefore, monitoring your MariaDB is key.
When monitoring your MariaDB instance, you should look for slow-running queries, bottlenecks, error rate, query execution performance and more. These metrics will inform you where and how to diagnose any issue you encounter and may even provide you with enough information to prevent issues.
How to use the MariaDB Monitoring Template
Once your InfluxDB credentials have been properly configured in the CLI, you can install the MariaDB Monitoring Template using the Quick Install command. Once installed, the data for the dashboard will be populated by the included MySQL Telegraf configuration, which includes the relevant MariaDB Input. Note that you might need to customize the input configuration to better serve your needs, including by specifying a new input value. All of this will depend on how your organization is currently running MariaDB.
To find out more information about environmental variables within the MySQL Telegraf configuration, consult the following link.
Key MariaDB metrics to monitor
Some of the most important MariaDB monitoring metrics that you should proactively monitor include:
- Connections
- Active Threads
- Uptime
- Current Queries
- Network Traffic
- Table Locks
- Select Types
- Temporary Objects
- Handlers
- Counters
- Query Cache Memory
- Query Cache Activity
Related Resources
Infrastructure and application monitoring
The solution to monitor your entire infrastructure stack, including servers, containers, databases and cloud services.
MySQL Telegraf Plugin
Collect and graph statistics from your MySQL monitoring database to keep it performant.
Create your own InfluxDB template
Learn how to create InfluxDB Templates to Make Operations Workflows and Use Cases Scalable and Reliable.