Monitoring mariaDB through SNMP
Ahoy List Members, I hope you are well. Is there a good guide that explains how to set up monitoring mariaDB via SNMP? Cheers, Noah
Well there is this blog https://www.fromdual.com/monitoring-your-mariadb-database-with-snmp Though use --batch and --skip-column-names on mariadb client rather than needing grep/cut/sed things: VALUE=$(mariadb --user=root --batch --skip-column-names -e 'SELECT variable_value FROM information_schema.global_status WHERE variable_name LIKE "threads_running"') On Mon, 4 Nov 2024 at 03:36, Noah via discuss <discuss@lists.mariadb.org> wrote:
Ahoy List Members,
I hope you are well. Is there a good guide that explains how to set up monitoring mariaDB via SNMP?
Cheers,
Noah
_______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
Hello, I use the script from Percona: https://github.com/percona/percona-monitoring-plugins/blob/master/cacti/scri... In snmp.conf you need to add a line like this: extend mysql /usr/local/sbin/snmp/mysql ...where /usr/local/sbin/snmp/mysql just starts ss_get_mysql_stats.php using php. Then your SNMP monitoring software needs to understand the data. I use LibreNMS with a corresponding app plugin. Best regards, Peter On 04/11/2024 06:20, Daniel Black via discuss wrote:
Well there is this blog https://www.fromdual.com/monitoring-your-mariadb-database-with-snmp
Though use --batch and --skip-column-names on mariadb client rather than needing grep/cut/sed things:
VALUE=$(mariadb --user=root --batch --skip-column-names -e 'SELECT variable_value FROM information_schema.global_status WHERE variable_name LIKE "threads_running"')
On Mon, 4 Nov 2024 at 03:36, Noah via discuss <discuss@lists.mariadb.org> wrote:
Ahoy List Members,
I hope you are well. Is there a good guide that explains how to set up monitoring mariaDB via SNMP?
Cheers,
Noah
_______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
participants (3)
-
Daniel Black
-
Noah
-
Peter