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. Join this channel to get access to perks: null 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://paypal.me/lazysysad 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://www.youtube.com/watch?v=OP07bSASKVw Icinga2 Agent Installation and Configuration - https://www.youtube.com/watch?v=UGSuz_LGmHE MySQL8 Replication - https://www.youtube.com/watch?v=s4oYWBGy_FE How to Monitor MySQL or MariaDB Database Server Using Icinga2 - https://www.youtube.com/watch?v=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!!!