Cut

echo 17k |md5pass |cut -b -30
$1$hk3dZJlr$BSeATtNIqRizk2Me6f​

root / liuqi1752932

admin / admin


# 这个是我们定义的负载均衡的配置
listen mysql-lb1
# 绑定的IP和端口 haproxy服务器一个网卡IP
bind 10.169.216.172:3306
# 模式是TCP
mode tcp
# 通过mysql连接去检测mysql是否可以访问 创建用户haproxy_check 密码为空,权限usage
option mysql-check user haproxy_check
# 负载均衡算法是 轮询
balance roundrobin
# 下面两个就是后端被访问的server
server mysql_1 10.24.220.70:3306 weight 1 check
server mysql_2 10.169.214.33:3306 weight 1 check


_____________________________________________________

set global max_connect_errors=1000;

mysqladmin flush-hosts
_____________________________________________________

scp -P 10022 mysql.sum maguirun@192.168.0.1:/home/maguirun/`ifconfig em2 |grep -o '192\+\.168\+\.0\+\.[0-9]\+'`.mysql​

______________________________________________________

./databox-mysql-s1/endpoints.json:192.168.0.48
/usr/local/mysql/bin/mysql -u root -pdongfang@east.2000 -P3306 -S /tmp/mysql3306.sock

Eosgt_X8GOu2YCakpZQSW(j4​

125.39.193.225[root ~]$mysql -uroot -p'$$QaTI1#%G2&apxPu'
125.39.193.248[root ~]$pt-mysql-summary --user root --password qwerEDC#​

#########################################################################
NewFile="$Mysql_bk_dir"/db_13_redactor_$(date +%Y%m%d).tgz
DbUser=root
DbPasswd=dongfang@east.2000
#DbName=all
DbName=redactor
DbPort=3306

HostName=$(/sbin/ifconfig |grep inet|grep -v 127.0.0.1|grep -v 125.|grep -v inet
6|awk '{print $2}'|tr -d 'addr:')
BKUser=dbbackup
BKPasswd=17k@s%^dbbackup


______________________________________________________

17k

14:10:22
游杨 2016-7-11 14:10:22
http://60.28.220.7
tjjf-test
12345678


________________________________________________________________________