前言：本脚本目前实际上限制比较多，后面会慢慢加强健壮性，目前只能实现指定端口号及目录的端口号安装

标准化

  • 目录：/xxx/mysql+port/{data,logs,tmp}

  • 自动生成root密码并存放/tmp/rootpasswd，实例初始化完成以后请记录root密码后及时删除该文件

  • 参数文件模板根据自己需要再改一改

  • 本脚本只针对MySQL5.7，5.6或者其他版本的同学需要另外再改改

一键安装脚本

  1. #!/bin/bash
  2. #Time 2018-05-10
  3. #Author xucl
  4. PATH=/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin
  5. PREFIX=/usr/local
  6. SYSTEM=`uname -a |awk '{print $13}'`
  7. USER=mysql
  8. BASEDIR=${PREFIX}/mysql
  9. SHELL=/sbin/nologin
  10. read -t 30 -p "请输入安装版本:" VERSION
  11. read -t 30 -p "请输入MySQL端口:" PORT
  12. read -t 30 -p "请输入数据最上层目录:" ROOTDIR
  13. read -t 30 -p "请输入innodb_buffer_pool_size:" POOLSIZE
  14. DATADIR=${ROOTDIR}/mysql${PORT}
  15. #echo ${DATADIR}
  16. function Confirm()
  17. {
  18. cat <<_ACEOF
  19.     Version:    ${VERSION}
  20.     Prefix:        ${PREFIX}
  21.     User:        ${USER}
  22.     Datadir:    ${DATADIR}
  23. _ACEOF
  24. }
  25. function IsAlready()
  26. {
  27.     if [ -d "/usr/local/mysql" ];then
  28.         echo "已安装"
  29.         exit 2
  30.     fi
  31. }
  33. function Avrg()
  34. {
  35.     ARGS=`getopt -o yv:f:u:d: --long version:,prefix:,user:,datadir: -n 'mysql_install' -- "$@"`
  36.     if [ ! $? -eq 0 ];then
  37.         echo "参数错误"
  38.         exit 2
  39.     fi
  40.     eval set -- "${ARGS}"
  42.     while true
  43.     do
  44.         case "$1" in
  45.             -v|--version)
  46.                 VERSION=$2
  47.                 shift 2
  48.                 ;;
  49.             -f|--prefix)
  50.                 PREFIX=$2
  51.                 shift 2
  52.                 ;;
  53.             -u|--user)
  54.                 USER=$2
  55.                 shift 2
  56.                 ;;
  57.             -d|--datadir)
  58.                 DATADIR=$2
  59.                 shift 2
  60.                 ;;
  61.             -y)
  62.                 YESFLAG="1"
  63.                 shift
  64.                 ;;
  65.             --)
  66.                 shift
  67.                 break
  68.                 ;;
  69.             *)
  70.                 echo "参数错误"
  71.                 exit 2
  72.                 ;;
  73.         esac
  74.     done    
  75. }
  76. IsAlready
  78. Avrg $@
  79. FILENAME=mysql-${VERSION}-linux-glibc2.12-${SYSTEM}
  81. #解压MySQL文件
  82. function Unzipfile()
  83. {
  84. echo "正在解压文件"
  85. tar -xvzf ${FILENAME}.tar.gz -C ${PREFIX} &>/dev/null
  86. mv ${PREFIX}/${FILENAME}/ ${BASEDIR}
  87. }
  89. #创建用户
  90. function Adduser()
  91. {
  92. if [ `cat /etc/passwd |grep mysql|wc -l` == "0" ];then
  93.     groupadd ${USER}
  94.     useradd -s ${SHELL} -g ${USER} ${USER}
  95. fi
  96. }
  98. #创建目录
  99. function CreateDir()
  100. {
  101. mkdir -p ${DATADIR}/data
  102. if [ $? -eq 0 ];then
  103.   echo "data 目录创建成功"
  104. else
  105.   echo "data 目录创建失败"
  106.   exit 2
  107. fi
  109. mkdir -p ${DATADIR}/logs
  110. if [ $? -eq 0 ];then
  111.   echo "logs 目录创建成功"
  112. else
  113.   echo "logs 目录创建失败"
  114.   exit 2
  115. fi
  117. mkdir -p ${DATADIR}/tmp
  118. if [ $? -eq 0 ];then
  119.   echo "tmp 目录创建成功"
  120. else
  121.   echo "tmp 目录创建失败"
  122.   exit 2
  123. fi
  124. }
  126. #生成my.cnf
  127. function genemycnf()
  128. {
  129. SERVERID=$RANDOM
  130. sed -i "s/POOLSIZE/${POOLSIZE}/g" my.cnf 
  131. sed -i "s/PORT/${PORT}/g" my.cnf
  132. sed -i "s/SERVERID/${SERVERID}/g" my.cnf
  133. cp -r my.cnf ${DATADIR}
  134. echo "配置文件已生成"
  135. }
  137. #文件夹授权
  138. function grantpri()
  139. {
  140. chown -R ${USER}:${USER} ${BASEDIR}
  141. chown -R ${USER}:${USER} ${DATADIR}
  142. echo "授权成功"
  143. }
  146. #初始化MySQL
  147. function MySQLinit()
  148. {
  149. echo "数据库初始化中..."
  150. ${BASEDIR}/bin/mysqld  --defaults-file=${DATADIR}/my.cnf --user=mysql --initialize &>/dev/null
  151. if [ $? -eq 0 ]; then
  152.   echo "初始化成功"
  153. else
  154.   echo "初始化失败"
  155. fi
  157. tempass=`cat ${DATADIR}/data/error.log | grep password | awk '{print $11}'`
  158. passwd=`tr -cd '[:alnum:]' < /dev/urandom | fold -w16 | head -n1`
  159. echo ${passwd}>/tmp/rootpasswd
  160. sql="alter user user() identified by '${passwd}'"
  162. if [ ! -e "/tmp/mysql${PORT}" ]; then
  163.   printf "正在启动MySQL......\n"
  164.   ${BASEDIR}/bin/mysqld  --defaults-file=${DATADIR}/my.cnf --user=mysql &
  165.   sleep 5
  166. else
  167.   printf "MySQL已启动" && exit 1
  168. fi
  170. #更改密码
  171. /usr/local/mysql/bin/mysql -uroot -p"${tempass}" -S /tmp/mysql${PORT}.sock -e "${sql};flush privileges;"  --connect-expired-password 
  172. }
  174. Unzipfile
  175. Adduser
  176. CreateDir
  177. genemycnf
  178. grantpri
  179. MySQLinit

配置文件模板

  1. #my.cnf
  2. [client]
  3. port            = PORT
  4. socket          = /tmp/mysqlPORT.sock
  6. [mysql]
  7. prompt="\\u@\\h [\\d]>" 
  8. #pager="less -i -n -S"
  9. #tee=/opt/mysql/query.log
  10. no-auto-rehash 
  12. [mysqld]
  13. #misc
  14. user = mysql
  15. basedir = /usr/local/mysql                 
  16. datadir = /storage/mysqlPORT/data     
  17. port = PORT                             
  19. socket = /tmp/mysqlPORT.sock
  20. event_scheduler = 0                     
  22. tmpdir = /storage/mysqlPORT/tmp         
  23. #timeout
  24. interactive_timeout = 300 
  25. wait_timeout = 300
  27. #character set
  28. character-set-server = utf8             
  30. open_files_limit = 65535                 
  31. max_connections = 1000                    
  32. max_connect_errors = 100000                
  33. lower_case_table_names =1                
  34. #file
  35. #@secure-file-priv=/tmp
  36. #symi replication                        
  38. #rpl_semi_sync_master_enabled=1
  39. #rpl_semi_sync_master_timeout=1000 
  40. #rpl_semi_sync_slave_enabled=1
  42. #logs
  43. log-output=file
  44. slow_query_log = 1
  45. slow_query_log_file = slow.log
  46. log-error = error.log
  47. log_warnings = 2
  48. pid-file = mysql.pid
  49. long_query_time = 1
  50. #log-slow-admin-statements = 1
  51. #log-queries-not-using-indexes = 1
  52. log-slow-slave-statements = 1
  54. #binlog
  55. #binlog_format = STATEMENT
  56. binlog_format = row
  57. server-id = SERVERID
  58. log-bin = /storage/mysqlPORT/logs/mysql-bin
  59. max_binlog_size = 256M
  60. sync_binlog = 0
  61. expire_logs_days = 10
  62. #procedure 
  63. log_bin_trust_function_creators=1
  65. #file
  66. secure_file_priv="/tmp"
  67. #
  68. gtid-mode = on
  69. enforce-gtid-consistency=1
  72. #relay log
  73. skip_slave_start = 1
  74. max_relay_log_size = 128M
  75. relay_log_purge = 1
  76. relay_log_recovery = 1
  77. relay-log=relay-bin
  78. relay-log-index=relay-bin.index
  79. log_slave_updates
  81. #slave-skip-errors=1032,1053,1062
  82. #skip-grant-tables
  84. #buffers & cache
  85. table_open_cache = 2048
  86. table_definition_cache = 2048
  87. table_open_cache = 2048
  88. max_heap_table_size = 96M
  89. sort_buffer_size = 128K
  90. join_buffer_size = 128K
  91. thread_cache_size = 200
  92. query_cache_size = 0
  93. query_cache_type = 0
  94. query_cache_limit = 256K
  95. query_cache_min_res_unit = 512
  96. thread_stack = 192K
  97. tmp_table_size = 96M
  98. key_buffer_size = 8M
  99. read_buffer_size = 2M
  100. read_rnd_buffer_size = 16M
  101. bulk_insert_buffer_size = 32M
  103. #myisam
  104. myisam_sort_buffer_size = 128M
  105. myisam_max_sort_file_size = 10G
  106. myisam_repair_threads = 1
  108. #innodb
  109. innodb_buffer_pool_size = POOLSIZE
  110. innodb_buffer_pool_instances = 1
  111. innodb_data_file_path = ibdata1:128M:autoextend
  112. innodb_flush_log_at_trx_commit = 1
  113. innodb_log_buffer_size = 8M
  114. innodb_log_file_size = 100M
  115. innodb_log_files_in_group = 3
  116. innodb_max_dirty_pages_pct = 50
  117. innodb_file_per_table = 1
  118. innodb_rollback_on_timeout
  119. innodb_io_capacity = 2000
  120. transaction_isolation = READ-COMMITTED
  121. innodb_flush_method = O_DIRECT

文件准备

以下是我安装的全部准备，总共是三个文件，一个是二进制包，一个是配置文件模板，一个是安装启动脚本

  1. [root@localhost3 mysql57]# ll
  2. 总用量 626112
  3. -rw-r--r-- 1 root root      2506 5月  10 15:10 my.cnf
  4. -rw-r--r-- 1 root root 641127384 1月  15 03:57 mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
  5. -rwxr-xr-x 1 root root      3304 5月  10 16:47 mysqlinstall.sh

安装过程

  1. [root@localhost3 mysql57]# sh mysqlinstall.sh
  2. 请输入安装版本:5.7.20
  3. 请输入MySQL端口:3309
  4. 请输入数据最上层目录:/storage
  5. 请输入innodb_buffer_pool_size:128M
  6. 正在解压文件
  7. data 目录创建成功
  8. logs 目录创建成功
  9. tmp 目录创建成功
  10. 配置文件已生成
  11. 授权成功
  12. 数据库初始化中...
  13. 初始化成功
  14. 正在启动MySQL......

安装过程也比较简单，按提示输入即可，安装完成以后，用/tmp/rootpasswd记录的密码登录即可