splunk mysql monitor

Problem Description: Monitor whether the MySQL service starts properly, start MySQL if it does not start properlyWays to judge MySQL:1) port judgment[Email protected] ~]# Netstat-lntup | grep 3306tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2288/mysqld2) Process judgment[Email protected] ~]# Ps-ef |grep mysqld

/local/zabbix/sbin/zabbix_agentd-c/usr/local/zabbix/etc/zabbix_ Agentd.conf6 , view startupVD14YYWG01:/USR/LOCAL/ZABBIX/ETC # NETSTAT–TUNLP..........TCP 0 0 172.16.202.173:10050 0.0.0.0:* LISTEN 24855/zabbix_agentd......7 , Import MYSQL the corresponding template Template_mysql.xml , Template_mysql_repl.xml import into the template. 650) this.width=650; "title=" 1.png "src=" Http://s1.51cto.com/wyfs02/M01/75/A5/wKioL1ZALEux9uBtAAA-ARDWeJY930.png " alt

MySQL Slow Log on the company line, has not been well monitored. While I was idle last week, I wrote the monitoring script, and today I specially sent out the code to share with 51 Bo friends. for script annotations and the overall idea, I'll put it behind the script and explain it to you. #!/bin/bash## This script is used to monitor MySQL slow log changes wit

Use ODBC to monitor Oracle Database (11.2.0.3) and MySQL database under Zabbix1. Monitor MySQL Database1) Installing ODBCYum-y Install UnixODBC Unixodbc-develYum Install Mysql-connector-odbc2) odbcinst-j View configuration fileUnixODBC 2.2.14DRIVERS ...:/etc/odbcinst.ini...S

Script Monitoring Database Master-Slave synchronizationSource: http://oldboy.blog.51cto.com/2561410/1632876Source:(production case): monitor MySQL master-slave synchronization is abnormal, if abnormal, send sms or mail to the administrator. Note: If there is no master-slave synchronization environment, you can use the following text in the file to read to simulate:Phase 1: Develop a daemon script to detect

Configure CACTI to monitor MySQL database statusMySQL itself is not powerful in performance monitoring, which makes many MySQL DBAs sleep at night,Fortunately, the MySQL database status is monitored through Cacti (note that monitoring is not monitoring ).With the powerful drawing function of cacti + rrdtool and dedicat

Monitor MySQL synchronization status using PythonMonitor MySQL synchronization status using Python Using Python to monitor whether the MySQL database server is accessible and whether the master-slave synchronization is interrupted is very simple. Thanks to Python for bringin

Pt-heartbeat Database master from replication, replication status, data latency is a very important indicator of the normal, then how to monitor it? Pt-heartbeat is a tool set developed by Percona to monitor the replication latency of MySQL and PostgreSQL. More mature, such as Uber and other large companies are in use. Monitoring principle Build a heartbeat

as follows: */10 * * * * root/bin/sh/root/mysql_slave.sh Remember in each MySQL from the machine to allocate a Yuhongchun user, the permission is not OK, only limited to run locally, as follows: Copy Code code as follows: Grant all privileges on *.* to "Yuhongchun" @ "127.0.0.1" identified by "yuhongchun101"; Grant all privileges on *.* to "Yuhongchun" @ "localhost" identified by "yuhongchun101"; Script D

Function: Monitor the MySQL process, the failure is restarted, if unable to start the email notification The code is as follows: The code is as follows Copy Code #!/bin/bash#/usr/bin/nmap localhost | grep 3306#lsof-i:3306mysqlport= ' Netstat-na|grep ' LISTEN "|grep" 3306″|awk-f[: ""]+ ' {print $} ' function Checkmysqlstatus () {/usr/bin/my