discover功能
- 思路
discover：找到mount挂载的盘目录
自动添加：将找到的目录添加到监控项中
1.部署lamp环境
安装zabbix 3.0以上，yum安装的版本有点低
- 解决方案：使用其他yum源
rpm -ivh http://repo.webtatic.com/yum/el6/latest.rpm
yum -y install httpd php56w php56w-gd php56w-mysql php56w-bcmath php56w-mbstring php56w-xml php56w-ldap wget ntpdate net-snmp*
2.：阿里云不支持25端口发邮件
- 解决方案：使用Python脚本ssl
#!/usr/bin/env python
# coding: utf-8
import smtplib,sys
from email.MIMEText import MIMEText
from email.Utils import formatdate
from email.Header import Header
def_encoding = 'utf-8'
if sys.getdefaultencoding() !=def_encoding:
reload(sys)
sys.setdefaultencoding(def_encoding)
def sendmail(toMail,subject,body):
smtpHost = 'smtp.qq.com'
smtpPort = '25'
sslPort = '465'
fromMail = 'test@qq.com'
toMail = 'test@qq.com'
username = 'test'
password = 'test'
# subject = u'hello'
# body = u'hello,this is a mail from ' + fromMail
encoding = 'utf-8'
mail=MIMEText(body,"plain",encoding)
mail['Subject'] = Header(subject, encoding)
# mail['Subject'] = subject
mail['From'] = fromMail
mail['To'] = toMail
mail['Date'] = formatdate()
mail["Accept-Language"] = "zh-CN"
mail["Accept-Charset"] = "ISO-8859-1,utf-8"
try:
#no ssl
# smtp = smtplib.SMTP(smtpHost,smtpPort)
# smtp.ehlo()
# smtp.login(username,password)
# ssl
smtp = smtplib.SMTP_SSL(smtpHost, sslPort)
smtp.ehlo()
smtp.login(username, password)
# print mail.as_string()
smtp.sendmail(fromMail, toMail, mail.as_string())
smtp.close()
print 'OK'
except Exception as e:
print e
if __name__ == "__main__":
sendmail(sys.argv[1], sys.argv[2], sys.argv[3])
这里自己有个邮箱账户什么的自己解决吧！
discover功能
- 自动发现
个人理解：
discover：找到mount挂载的盘目录
自动添加：将找到的目录添加到监控项中
监控sql server
PerfCounter = MSSQLLOCKS,"\SQLServer:Locks(_Total)\Number of Deadlocks/sec",15
PerfCounter = Lock_Timeouts,"\SQLServer:Locks(_Total)\Lock Timeouts/sec",15
PerfCounter = Lock_Requests,"\SQLServer:Locks(_Total)\Lock Requests/sec",15
类似，可百度PerfCounter
代理proxy安装
1.安装数据库
2.导入数据库数据，库名为zabbix_proxy，导入数据（和搭建server一样）
3.编译安装zabbix-server：./configure --sysconfdir=/usr/local/zabbix/ --enable-proxy --enable-agent --with-net-snmp --with-mysql --with-ssh2
4.导入数据库文件（只要一个就OK）：mysql zabbix_proxy <schema.sql
5.修改zabbix_proxy.cnf配置文件
ProxyMode=0 ##默认参数值，proxy代理主动模式
Server=IP ##主动模式下，主动请求这个IP，获得监控配置信息
ServerPort=10051 ##proxy代理端口
Hostname=xxx ##这个要名字随便取，但是不能重复，web端设置时需要
然后就是db设置
6.启动代理：zabbix-proxy
7.web设置
首先要配置代理
44287dff-c7be-46d3-9659-21348ec5776a.png
然后将agent端放到代理下面：添加主机选择
image.png
等他变绿
agent到proxy配置
server：配了了server端的IP，和proxy的IP
serveractive：配置的是proxy的ip+端口号
LogFile=/tmp/zabbix_agentd.log
Server=
ListenPort=10049
ServerActive=ip:10051
Hostname=MMMM_master
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix /usr/bin/mysql -N | awk '{print $$2}'
数据库监控
1.给数据库创建一个zabbix用户
grant REPLICATION CLIENT on *.* to 'zabbix'@'localhost' identified by '123456';
2.在my.cnf配置文件[client]写入信息
[client]
user=zabbix
password=123456
3.监控模块
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix /usr/bin/mysql -N | awk '{print $$2}'
UserParameter=mysql.ping,HOME=/var/lib/zabbix /usr/bin/mysqladmin ping | grep -c 'mysqld is alive'
UserParameter=db_status,echo "show slave status\G" | HOME=/var/lib/zabbix /usr/local/mysql/bin/mysql -N|grep -c Yes
UserParameter=db_time,echo "show slave status \G" | HOME=/var/lib/zabbix /usr/local/mysql/bin/mysql|grep Seconds_Behind_Master|awk '{print $2}'|awk '{sum += $1};END {print sum}'
这些是例子，前端添加模块就不写了，注意/usr/local/mysql/bin/mysql路径
