How to use SQL Queries to Monitor MySQL or MariaDB Database Server Using Icinga2

In this video, you will learn how to use SQL queries to monitor the MySQL database server using the check-mysql-health plugin in Icinga.

The SQL mode of the check-mysql-health plugin allows you to send that exact SQL query to your database.

PLEASE SUBSCRIBE 🙂
PLEASE HIT LIKE IF IT HELPED 🙂

GIVE SUPPORT – https://www.patreon.com/lazysysad
BUY ME A COFFEE – https://www.buymeacoffee.com/lazysysad
PAYPAL – https://www.paypal.com/donate/?hosted_button_id=K4RQ3LAWHGVS6

I’ll assume you already have an Icinga and a MySQL database server set up.
I won’t cover the installation of Icinga master and Icinga agent in this video, so please check out my other videos in the description below for those procedures.

But I recommend that you follow my previous video on how to monitor a MySQL database so you can fully understand the configuration that I already have in this video.

LINKS:
Icinga2 Master Installation and Configuration – https://youtu.be/OP07bSASKVw
Icinga2 Agent Installation and Configuration – https://youtu.be/UGSuz_LGmHE
MySQL8 Replication – https://youtu.be/s4oYWBGy_FE
How to Monitor MySQL or MariaDB Database Server Using Icinga2 – https://youtu.be/joztxRqUu8s
check_mysql_health – https://labs.consol.de/nagios/check_mysql_health/

Steps:
YouTube has restrictions on putting code in the description.
Go to https://www.patreon.com/posts/how-to-use-sql-76789978 for easy copy and paste and full written step by step.

Chapters:
00:00 Intro
00:57 Grant MySQL permission
01:23 Host Object Definition for single database
02:18 Apply Service Rule for single database
04:44 Warning and critical threshold
05:56 Grant MySQL permission
06:29 Apply Service Rule for multi database
07:15 Host Object Definition for multi database
09:57 Outro

Drop me your feedback and comments below.

That’s all for now.

If this video helped you in any way, please like share and subscribe!

Thank you!!!