#!/bin/bash file=/opt/last_traffic.txt default_intface=`route |grep default |awk '{print $NF}'` now_traffic=`grep "$default_intface" /proc/net/dev|grep $default_intface |awk '{print $10}'` ip=`curl -s ip.sb` function push_data(){ inuremental=$(( $now_traffic - $last_traffic )) mysql -h pro-zabbix-db.cqq9nr0jx2m3.us-west-1.rds.amazonaws.com -u net_user -pazZ@1JuI3UGgb6MB5q8T -D net_traffic -e "insert into net_traffic_any (ip,traffic,tag,platform) value('$ip','$inuremental','skyvpn','do_top')" if [ $? == 0 ];then echo $now_traffic > $file fi } if [ -e $file ];then # 非新建主机,采集目前网卡流量-上次采集流量 last_traffic=`cat $file` if [ "$last_traffic" -gt "$now_traffic" ];then # 网卡流量重置 last_traffic=0 push_data else push_data fi else # 新建主机,采集初始网卡流量 last_traffic=0 push_data fi