set -o pipefail

processDate="$(date -d "$1 1 days ago" +'%Y%m%d')"
CONFIG_MYSQL_BIN='mysql -uroot -pyang0328 --default_character_set=utf8 --database=test -N -A'
QUERY_CONFIG="select concat_ws('####',id,ifnull(age,999),cup_size) from girl"
DB_RESULT="$(${CONFIG_MYSQL_BIN} <<< "${QUERY_CONFIG}")"

啟動(dòng)zookeeper集群

echo "start zkServer"
for i in 1 2 3
do
ssh mini0$i "source /etc/profile;/home/hadoop/zookeeper-3.4.8/bin/zkServer.sh start"
done

mysql

mysql -u$mysql_user -h$mysql_host -p"$mysql_password" -e "use business_analysis;delete from $table where date='$yyyymmdd';\
LOAD DATA LOCAL INFILE '$resultFile' into table $table  FIELDS TERMINATED BY '\t';";

local_path="$(cd $(dirname $0);pwd)"

跳板機(jī)免密登錄服務(wù)器
執(zhí)行這個(gè)命令： echo 'eval `/usr/local/bin/ssh-attach`' >> ~/.bashrc && source ~/.bashrc
這時(shí)會(huì)要求輸入passphrase，輸入正確的passphrase
執(zhí)行這個(gè)命令： ssh -add(注意:中間帶有空格)

發(fā)送郵件命令:echo "$mailcontent" | mail -s "火車票新客引流到其他業(yè)務(wù)線的新客數(shù)據(jù)" -a $dir/cross_newuser.xlsx -c 抄送人1@qq.com -c 抄送人2@qq.com 收件人1@qq.com 收件人2@qq.com 收件人3@qq.com
檢查郵件箱中是否有滯留郵件沒(méi)發(fā)送/usr/lib/sendmail -bp
參考：https://www.cnblogs.com/toowang/p/3920465.html