###################################################
更新：当前脚本只能自动下载5.7.22
随着官网的更新
几个月后该脚本将无法正常下载
更新后的脚本链接：自动部署最新版MySQL5.7（二进制版本）
###################################################
脚本使用说明
1.该脚本的数据存储路径为/data，请确认你的/data盘为单独挂载，或者有足够的空间
2.脚本默认开启GTID
3.脚本下载的MySQL来源为官网，版本为linux下的64位5.7.22，链接地址为：MySQL5.7.22版本确认
4.脚本关闭了Selinux，但并没关闭防火墙，所以确认wget能成功执行下载
5.脚本会使用yum下载部分工具，确认yum源配置正确
6.--initialize-insecure的初始化方式会生成一个空密码，而不是脚本中的随机密码
###################################################
#!/bin/bash
# FlyDido
# 2018.6.4
# 部署MySQL5.7，请提前为数据存储路径"/data"划分好空间
#关闭SeLinux
sed -i 's/enforcing/disabled/g' /etc/sysconfig/selinux
setenforce=0
#用户及路径创建
groupadd mysql
useradd -g mysql -s /sbin/nologin -d /usr/local/mysql -MN mysql
mkdir /data/mysql/mysql3306/{data,tmp,logs} -p
mkdir /opt/mysql -p
#部署前置环境
yum install -y numactl vim wget &> /tmp/install.log &&
M=mysql-5.7.22-linux-glibc2.12-x86_64
#开始下载MySQL，如果下载失败，请检查官网版本是否为脚本中版本
echo -e "开始下载5.7.22\n如果下载失败，请登陆：https://dev.mysql.com/downloads/mysql/5.7.html#downloads\n检查当前可下载版本是否为5.7.22\n然后把脚本中第29行的M值设置成可下载版本\n"
echo -e "3\n"
sleep 1
echo -e "2\n"
sleep 1
echo -e "1\n"
sleep 1
echo -e "Ready,Go!\n"
sleep 1
cd /opt/mysql
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/$M.tar.gz
#下载情况判定
if [ $? == 0 ];then
echo -e "下载完成\n正在解压\n..."
else
echo -e "下载失败，请检查版本\n"
exit 1
fi
tar -xf $M.tar.gz
echo -e "解压完成\n"
#制作软链接
ln -s /opt/mysql/$M /usr/local/mysql
#更改权限
chown -R mysql.mysql /data
chown -R mysql.mysql /opt/mysql
chown -R mysql.mysql /usr/local/mysql
#定义server-id相关因子
echo -e "开始定义server-id\n请确认当前IP是否使用eth0，如果不是请将脚本中IP变量定义中的eth0改成当前使用的网卡\n确认端口是否为3306，如果不是请将变量PORT定义的3306改成需要的端口"
IP=`ip addr show|grep eth0|grep inet|awk '{print $2}'|awk -F '/' '{print $1}'|awk -F '.' '{print $4}'`
PORT=3306
echo -e "server-id生成完成，server-id为：$IP$PORT\n"
#生成cnf
echo -e "正在/data/mysql/mysql3306/下生成本次初始化使用的cnf\n"
cat << EOF > /data/mysql/mysql3306/my3306.cnf
[client]
port = 3306
socket = /tmp/mysql3306.sock
[mysql]
prompt="\\u@\\h [\\d]>"
#pager="less -i -n -S"
#tee=/opt/mysql/query.log
no-auto-rehash
[mysqld]
#misc
user = mysql
basedir = /usr/local/mysql
datadir = /data/mysql/mysql3306/data
port = 3306
socket = /tmp/mysql3306.sock
event_scheduler = 0
tmpdir = /data/mysql/mysql3306/tmp
#timeout
interactive_timeout = 300
wait_timeout = 300
#character set
character-set-server = utf8
open_files_limit = 65535
max_connections = 100
max_connect_errors = 100000
lower_case_table_names =1
#
explicit_defaults_for_timestamp=1
#symi replication
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=1000 # 1 second
#rpl_semi_sync_slave_enabled=1
#logs
log-output=file
slow_query_log = 1
slow_query_log_file = slow.log
log-error = error.log
pid-file = mysql.pid
long_query_time = 1
#log-slow-admin-statements = 1
#log-queries-not-using-indexes = 1
log-slow-slave-statements = 1
#binlog
#binlog_format = STATEMENT
binlog_format = row
server-id = $IP$PORT
log-bin = /data/mysql/mysql3306/logs/mysql-bin
binlog_cache_size = 1M
max_binlog_size = 256M
sync_binlog = 0
expire_logs_days = 10
#procedure
log_bin_trust_function_creators=1
#GTID
gtid-mode = on
enforce-gtid-consistency=on
log-slave-updates=1
#relay log
skip_slave_start = 1
max_relay_log_size = 128M
relay_log_purge = 1
relay_log_recovery = 1
relay-log=relay-bin
relay-log-index=relay-bin.index
#slave-skip-errors=1032,1053,1062
#skip-grant-tables
#buffers & cache
table_open_cache = 2048
table_definition_cache = 2048
table_open_cache = 2048
max_heap_table_size = 96M
sort_buffer_size = 128K
join_buffer_size = 128K
thread_cache_size = 200
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 256K
query_cache_min_res_unit = 512
thread_stack = 192K
tmp_table_size = 96M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M
#myisam
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
#innodb
innodb_buffer_pool_size = 100M
innodb_buffer_pool_instances = 1
innodb_data_file_path = ibdata1:100M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 1G
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 50
innodb_file_per_table = 1
innodb_rollback_on_timeout
innodb_status_file = 1
innodb_io_capacity = 2000
transaction_isolation = READ-COMMITTED
innodb_flush_method = O_DIRECT
loose_tokudb_cache_size=100M
loose_tokudb_directio=ON
loose_tokudb_fsync_log_period=1000
loose_tokudb_commit_sync=0
EOF
#创建一个配置在/etc下
rm -rf /etc/my.cnf
cp -f /data/mysql/mysql3306/my3306.cnf /etc/my.cnf
echo -e "开始执行初始化\n"
#初始化
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/mysql3306/my3306.cnf --initialize &> /tmp/install.log
if [ $? == 0 ];then
echo -e "初始化成功\n"
else
echo -e "初始化失败\n"
exit 1
fi
#更新环境变量
echo -e "export PATH=\$PATH:/usr/local/mysql/bin" >> /etc/profile
echo -e "开始启动MySQL服务\n"
#启动MySQL服务
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/mysql3306/my3306.cnf &
if [ $? == 0 ];then
echo -e "MySQL启动成功\n"
else
echo -e "启动失败，请检查日志/data/mysql/mysql3306/data/error.log\n"
exit 1
fi
PD=`cat /data/mysql/mysql3306/data/error.log |grep 'temporary password'|awk '{print $NF}'`
#后续需要的操作
echo -e "仔细阅读接下来你需要做的操作\n"
echo -e "1.环境变量设置完毕，请手动执行：source /etc/profile\n"
echo -e "2.初始密码为$PD\n在完成第1步的基础上执行mysql -uroot -p'$PD'进行登陆\n登陆后执行：alter user user() identified by '密码';\n注意密码需要打上引号，初次登陆必须更改密码\n"
echo -e "3.日志路径：/data/mysql/mysql3306/logs\n数据存储路径：/data/mysql/mysql3306/data\nMySQL部署路径：/usr/local/mysql\n"
echo -e "4.初始log_file_size设置为1G\n日志组设置为3\n初始buffer_pool_size设置为100M\n请尽快按需修改cnf配置\n"
echo -e "5.numa并没有关闭，请参照度娘/谷哥对numa进行设置\n Done!"
