腳本里面沒有把同步時間寫進去，這個寫在最前面
yum install -y ntp ntpdate
cp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
執(zhí)行下列語句之前，請詳細(xì)了解ntp和ntpdate的區(qū)別，由于我這里是測試環(huán)境，所以ntpdate并無問題，正式環(huán)境請慎用ntpdate
（ntp是逐漸校正時間，ntpdate是跳躍式的直接修改時間，可能會對應(yīng)用造成不良影響）
（另外，在虛擬機上測試時，ntpd不是太明顯）
service ntpdate start?
/sbin/chkconfig --add ntpd
/sbin/chkconfig --level 234 ntpd on
在阿里CentOS7環(huán)境下，會存在缺少libaio.so.1的報錯
yum install -y libaio
腳本正文
#!/bin/bash
#? ? ? FlyDido
#? ? ? V1.0? ? 2018.6.4
#? ? ? 部署MySQL5.7，請?zhí)崆盀閿?shù)據(jù)存儲路徑"/data"劃分好空間
#? ? ? V1.1? ? 2018.9.11
#? ? ? 將V1.0版本的固定下載部署5.7.22版本更新為自動識別5.7最新版本
#關(guān)閉SeLinux
sed -i 's/enforcing/disabled/g' /etc/sysconfig/selinux
setenforce 0
#用戶及路徑創(chuàng)建
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
#部署前置環(huán)境
yum install -y numactl vim wget &> /tmp/install.log &&
#獲取mysql5.7官網(wǎng)最新版本號
wget https://dev.mysql.com/downloads/mysql/5.7.html#downloads &>> /tmp/install.log &&
#將新版本號寫入變量
#注意這里是截取的277行的版本號，但是5.7.html有時候會有變化，所以如果更新之后版本號不在277行需要修改成對應(yīng)的行號
M=`cat 5.7.html |grep '<h1>MySQL Community Server'|awk '{print $4}'`
echo -e "當(dāng)前版本號為$M\n"
N=mysql-$M-linux-glibc2.12-x86_64
#刪除wget下來的網(wǎng)頁文件
rm -rf 5.7.html
#開始下載MySQL，如果下載失敗，請檢查官網(wǎng)版本是否為腳本中版本
echo -e "開始下載$M\n如果下載失敗，請登陸：https://dev.mysql.com/downloads/mysql/5.7.html#download確認(rèn)當(dāng)前可用版本\n并手動將腳本中第39行的M值改寫成可下載版本的版本號(格式范例:5.7.23)"
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/$N.tar.gz
#下載情況判定
if [ $? == 0 ];then
? ? echo -e "下載完成\n正在解壓\n..."
else
? ? echo -e "下載失敗，請檢查版本\n或者是檢查腳本中的那句cat 5.7.html |sed -n 277p...，確定版本號是否在277行，并修改成相應(yīng)的行號\n"
? ? exit 1
fi
tar -xf $N.tar.gz
echo -e "解壓完成\n"
#制作軟鏈接
ln -s /opt/mysql/$N /usr/local/mysql
#更改權(quán)限
chown -R mysql.mysql /data
chown -R mysql.mysql /opt/mysql
chown -R mysql.mysql /usr/local/mysql
#定義server-id相關(guān)因子
echo -e "開始定義server-id\n請確認(rèn)當(dāng)前IP是否使用eth0，如果不是請將腳本中IP變量定義中的eth0改成當(dāng)前使用的網(wǎng)卡\n確認(rè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
max_allowed_packet=1073741824
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
log_timestamps=SYSTEM
#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
#replication
read_only=1
replicate-wild-ignore-table=mysql.%
#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=1
#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
#創(chuàng)建一個配置在/etc下
rm -rf /etc/my.cnf
cp -f /data/mysql/mysql3306/my3306.cnf /etc/my.cnf
echo -e "開始執(zhí)行初始化\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
#更新環(huán)境變量
echo -e "export PATH=\$PATH:/usr/local/mysql/bin" >> /etc/profile
echo -e "開始啟動MySQL服務(wù)\n"
#啟動MySQL服務(wù)
/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}'`
#后續(xù)需要的操作
echo -e "仔細(xì)閱讀接下來你需要做的操作\n"
echo -e "1.環(huán)境變量設(shè)置完畢，請手動執(zhí)行：source /etc/profile\n"
echo -e "2.初始密碼為$PD\n在完成第1步的基礎(chǔ)上執(zhí)行mysql -uroot -p'$PD'進行登陸\n登陸后執(zhí)行：alter user user() identified by '密碼';\n注意密碼需要打上引號，初次登陸必須更改密碼\n"
echo -e "3.日志路徑：/data/mysql/mysql3306/logs\n數(shù)據(jù)存儲路徑：/data/mysql/mysql3306/data\nMySQL部署路徑：/usr/local/mysql\n"
echo -e "4.初始log_file_size設(shè)置為1G\n日志組設(shè)置為3\n初始buffer_pool_size設(shè)置為100M\n請執(zhí)行：sed -i 's/innodb_buffer_pool_size = 100M/innodb_buffer_pool_size = 需要的大小/g' /data/mysql/mysql3306/my3306.cnf 進行修改\n"
echo -e "5.numa并沒有關(guān)閉，請參照度娘/谷哥對numa進行設(shè)置\n"
echo -e "6.執(zhí)行cat /data/mysql/mysql3306/my3306.cnf |grep server-id，如果結(jié)果是3306，表明網(wǎng)卡不是eth0，手動更改該server-id確保不會影響主從配置\n"
