Board logo

标题: [教程] WDCP升级mysql 8.0脚本，亲测可用 2021.01.26 [打印本页]
作者: helen5106    时间: 2021-1-26 12:39     标题: WDCP升级mysql 8.0脚本，亲测可用 2021.01.26

  1. #!/bin/bash
  2. # mysql 8.0 update scripts
  3. # Author: wdlinux
  4. # Url: http://www.wdlinux.cn
  5. # Modify: windsage

  7. IN_DIR="/www/wdlinux"

  9. if [ ! $1 ];then
  10.     MYS_VER="8.0.11"
  11. else
  12.     MYS_VER=$1
  13. fi

  15. echo "升级有风险 操作需谨慎"
  16. echo "欢迎学习交流互助提高"
  17. echo "qq：242013800"
  18. echo
  19. read -p "DO YOU REALLY WANT TO UPDATE? (Y/N): " yn
  20. if [ "$yn" == "Y" ] || [ "$yn" == "y" ]; then
  21.     echo "MYSQL IS NOW UPDATING!"
  22. else
  23.     exit
  24. fi
  25. echo
  26. echo "-------------------------------------------------------------"
  27. echo


  30. if [ ! -f mysql-boost-${MYS_VER}.tar.gz ];then
  31. # 因mysql5.7需要boost，所以这个直接是包含boost的源码包
  32.     wget -c https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-${MYS_VER}.tar.gz
  33. fi
  34. yum install -y cmake bison libmcrypt-devel libjpeg-devel libpng-devel freetype-devel curl-devel openssl-devel libxml2-devel zip unzip
  35. if [ ! -d $IN_DIR/mysql-${MYS_VER} ];then
  36. mkdir -p $IN_DIR/mysql-${MYS_VER}
  37. # 数据库文件夹默认要求是data
  38. mkdir -p $IN_DIR/mysql-${MYS_VER}/data
  39. fi

  41. if [ ! -d mysql-${MYS_VER} ];then
  42. tar zxvf mysql-boost-${MYS_VER}.tar.gz
  43. fi

  45. cd mysql-${MYS_VER}

  47. echo "START CONFIGURING MYSQL"
  48. sleep 3
  49. #mkdir -p build
  50. #cd  build/
  51. make clean
  52. cmake \
  53. -DFORCE_INSOURCE_BUILD=1 \
  54. -DCMAKE_INSTALL_PREFIX=$IN_DIR/mysql-$MYS_VER \
  55. -DSYSCONFDIR=$IN_DIR/etc \
  56. -DDEFAULT_CHARSET=utf8 \
  57. -DDEFAULT_COLLATION=utf8_general_ci \
  58. -DWITH_SSL=bundled \
  59. -DWITH_DEBUG=OFF \
  60. -DWITH_EXTRA_CHARSETS=complex \
  61. -DENABLED_PROFILING=ON \
  62. -DWITH_INNOBASE_STORAGE_ENGINE=1 \
  63. -DWITH_MYISAM_STORAGE_ENGINE=1 \
  64. -DWITH_MEMORY_STORAGE_ENGINE=1 \
  65. -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
  66. -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
  67. -DENABLE_DOWNLOADS=1 \
  68. -DWITH_BOOST=./boost/boost_1_66_0/
  69. [ $? != 0 ] && echo "NO! CONFIGURE ERROR!  :(" && exit

  71. echo "START MAKE"
  72. sleep 3
  73. make
  74. [ $? != 0 ] && echo "NO! MAKE ERROR!  :(" && exit
  75. echo "START MAKE INSTALL"
  76. sleep 3
  77. make install
  78. [ $? != 0 ] && echo "NO! MAKE INSTALL ERROR!  :(" && exit

  80. service mysqld stop
  81. #cd ..
  82. # 建立备份文件夹，这个可以自定义设置,建议一开始就先备份，不要问我为什么，这样可视化安全更放心
  83. if [ ! -d /www/wdlinux/mysql_bk ];then
  84. mkdir -p /www/wdlinux/mysql_bk
  85. cp -pR /www/wdlinux/mysql/data/* /www/wdlinux/mysql_bk
  86. fi
  87. rm -f /www/wdlinux/mysql
  88. ln -sf $IN_DIR/mysql-$MYS_VER /www/wdlinux/mysql
  89. sh scripts/mysql_install_db.sh --user=mysql --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/data
  90. chown -R mysql.mysql /www/wdlinux/mysql
  91. chown -R mysql.mysql /www/wdlinux/mysql/data
  92. mv /www/wdlinux/mysql/data/mysql /www/wdlinux/mysql/data/mysqlo
  93. cp support-files/mysql.server /www/wdlinux/init.d/mysqld
  94. chmod 755 /www/wdlinux/init.d/mysqld
  95. service mysqld restart
  96. ln -sf $IN_DIR/mysql/lib/libmysqlclient.so.20. /usr/lib/libmysqlclient.so.20
  97. cd ..
  98. rm -rf mysql-${Ver}/
  99. # rm -rf mysql-${Ver}.tar.gz
  100. sleep 2
  101. service mysqld restart
  102. sleep 2
  103. mysqld --initialize --user=mysql --console
  104. # 或者把备份的数据库复制回来，注意不要覆盖performance_schema
  105. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
  106. echo
  107. echo "-------------------------------------------------------------"
  108. echo "数据库需要初始化，自动生成的密码会存入mysql的日志，默认在/var/log/mysql/error.log"
  109. echo
  110. echo "此时查看mysql日志，应该一切正常了，但新手朋友注意了，此时你的httpd无法启动了，需要编译安装php。"
  111. echo
复制代码




作者: helen5106    时间: 2021-1-27 15:51

遇到的问题

1. 内存不够容易卡死，增加swap文件
2. my.cnf有写参数错误，导致初始化错误,根据提示,删掉一些没用参数，把/www/wdlinux/mysql/data重新命名，然后重新初始化
mysqld --initialize --user=mysql --console --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/data
作者: helen5106    时间: 2021-1-27 16:02

升级完mysql, 重新编译php

下面是php 7.3.26
  1. #!/bin/bash
  2. # PHP 7.1 update scripts
  3. # Author: wdlinux
  4. # Url: http://www.wdlinux.cn
  5. # Modify: slrainy

  7. if [ ! $1 ];then
  8.         Ver=7.3.26
  9. else
  10.         Ver=$1
  11. fi
  12. echo "升级有风险 操作需谨慎"
  13. echo "欢迎学习交流互助提高"
  14. echo "qq：6824498"
  15. echo "点击链接加入群(207118653)【lanmp php thinkphp5 交流】：https://jq.qq.com/?_wv=1027&k=45CsOTO"
  16. echo
  17. #read -p "PRESS ENTER IF YOU REALLY WANT TO UPDATE"
  18. read -p "DO YOU REALLY WANT TO UPDATE? (Y/N): " yn
  19. if [ "$yn" == "Y" ] || [ "$yn" == "y" ]; then
  20.         echo "PHP IS NOW UPDATING!"
  21. else
  22.         exit
  23. fi
  24. echo
  25. echo "-------------------------------------------------------------"
  26. echo

  28. ###yum
  29. yum clean all
  30. yum install -y gcc gcc-c++ make autoconf libtool-ltdl-devel gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel openssl-devel curl-devel patch libmcrypt-devel libmhash-devel ncurses-devel bzip2-devel libcap-devel gmp-devel t1lib-devel libc-client-devel sqlite-devel aspell-devel readline-devel recode-devel libtidy-devel libxslt-devel openldap-devel
  31. ln -s /usr/lib64/libc-client.so /usr/lib/libc-client.so
  32. ###
  33. if [ ! -f php-${Ver}.tar.gz ];then
  34.         wget -c http://cn2.php.net/distributions/php-${Ver}.tar.gz
  35. fi
  36. if [ ! -f iconv_ins.sh ];then
  37.         wget -c http://down.wdlinux.cn/in/iconv_ins.sh
  38. fi
  39.         sh iconv_ins.sh

  41. ###
  42. if [ -f /www/wdlinux/mysql/lib/libmysqlclient.so.20 ];then
  43.         if [ -d /usr/lib64 ];then
  44.                 LIBNCU="/usr/lib64"
  45.         else
  46.                 LIBNCU="/usr/lib"
  47.         fi
  48.         ln -sf /www/wdlinux/mysql/lib/libmysqlclient.so.20 $LIBNCU
  49. fi
  50. if [ ! -f php-${Ver} ];then
  51. tar zxvf php-${Ver}.tar.gz
  52. fi
  53. cd php-${Ver}
  54. if [ -d /www/wdlinux/apache_php ];then
  55. make clean
  56. ./configure \
  57. --prefix=/www/wdlinux/apache_php-${Ver} \
  58. --exec-prefix=/www/wdlinux/apache_php-${Ver} \
  59. --bindir=/www/wdlinux/apache_php-${Ver}/bin \
  60. --sbindir=/www/wdlinux/apache_php-${Ver}/sbin \
  61. --libdir=/www/wdlinux/apache_php-${Ver}/lib/php \
  62. --mandir=/www/wdlinux/apache_php-${Ver}/php/man \
  63. --with-config-file-path=/www/wdlinux/apache_php-${Ver}/etc \
  64. --with-apxs2=/www/wdlinux/apache/bin/apxs \
  65. --with-mhash \
  66. --with-openssl \
  67. --with-mysqli=/www/wdlinux/mysql/bin/mysql_config \
  68. --with-pdo-mysql=/www/wdlinux/mysql \
  69. --with-gd \
  70. --with-iconv \
  71. --with-zlib \
  72. --enable-zip \
  73. --with-kerberos \
  74. --with-pcre-regex \
  75. --with-libxml-dir=/usr \
  76. --enable-inline-optimization \
  77. --disable-debug \
  78. --disable-rpath \
  79. --enable-shared \
  80. --enable-xml \
  81. --enable-bcmath \
  82. --enable-shmop \
  83. --enable-sysvsem \
  84. --enable-mbregex \
  85. --enable-mbstring \
  86. --enable-ftp \
  87. --enable-pcntl \
  88. --enable-sockets \
  89. --with-xmlrpc \
  90. --enable-soap \
  91. --without-pear \
  92. --with-gettext \
  93. --enable-session \
  94. --with-curl \
  95. --with-jpeg-dir \
  96. --with-png-dir \
  97. --with-freetype-dir \
  98. --enable-opcache \
  99. --enable-fpm \
  100. --without-gdbm \
  101. --disable-fileinfo
  102. [ $? != 0 ] && echo "configure err" && exit
  103. make ZEND_EXTRA_LIBS='-liconv'
  104. [ $? != 0 ] && echo "make err" && exit
  105. make install
  106. [ $? != 0 ] && echo "make install err" && exit
  107. cp php.ini-production /www/wdlinux/apache_php-${Ver}/etc/php.ini
  108. sed -i 's/short_open_tag = Off/short_open_tag = On/g' /www/wdlinux/apache_php-${Ver}/etc/php.ini
  109. rm -f /www/wdlinux/apache_php
  110. ln -sf /www/wdlinux/apache_php-${Ver} /www/wdlinux/apache_php
  111. if [ ! -d /www/wdlinux/apache_php-${Ver}/lib/php/extensions ];then
  112.         mkdir -p /www/wdlinux/apache_php-${Ver}/lib/php/extensions/no-debug-zts-20131226
  113.         ln -sf /www/wdlinux/apache_php-${Ver}/lib/php/extensions/no-debug-zts-20131226 /www/wdlinux/apache_php-${Ver}/lib/php/extensions/no-debug-non-zts-20131226
  114. fi
  115. service httpd restart
  116. echo
  117. echo "如果升级后httpd无法启动，打开httpd.conf，注释 #LoadModule php5_module        modules/libphp5.so"
  118. echo "php update compelete"
  119. fi

  121. if [ -d /www/wdlinux/nginx_php ];then
  122. make clean
  123. ./configure --prefix=/www/wdlinux/nginx_php-${Ver} --with-config-file-path=/www/wdlinux/nginx_php-${Ver}/etc --with-mysql=/www/wdlinux/mysql --with-iconv=/usr --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-rpath --enable-inline-optimization --with-curl --enable-mbregex --enable-mbstring --with-mcrypt=/usr --with-gd --enable-gd-native-ttf --with-openssl --with-mhash --enable-soap --with-imap --with-kerberos --with-imap-ssl  --enable-ftp --enable-sockets --enable-zip --enable-fpm --with-mysqli=/www/wdlinux/mysql/bin/mysql_config --with-pdo-mysql=/www/wdlinux/mysql
  124. [ $? != 0 ] && echo "configure err" && exit
  125. make
  126. [ $? != 0 ] && echo "make err" && exit
  127. make install
  128. [ $? != 0 ] && echo "make install err" && exit
  129. cp php.ini-production /www/wdlinux/nginx_php-${Ver}/etc/php.ini
  130. sed -i 's/short_open_tag = Off/short_open_tag = On/g' /www/wdlinux/nginx_php-${Ver}/etc/php.ini
  131. service php-fpm stop
  132. rm -f /www/wdlinux/nginx_php
  133. ln -sf /www/wdlinux/nginx_php-${Ver} /www/wdlinux/nginx_php
  134. cp /www/wdlinux/nginx_php-${Ver}/etc/php-fpm.conf.default /www/wdlinux/nginx_php-${Ver}/etc/php-fpm.conf
  135. sed -i 's/user = nobody/user = www/g' /www/wdlinux/nginx_php/etc/php-fpm.conf
  136. sed -i 's/group = nobody/group = www/g' /www/wdlinux/nginx_php/etc/php-fpm.conf
  137. sed -i 's/;pid =/pid =/g' /www/wdlinux/nginx_php/etc/php-fpm.conf
  138. cp -f sapi/fpm/init.d.php-fpm /www/wdlinux/init.d/php-fpm
  139. chmod 755 /www/wdlinux/init.d/php-fpm
  140. if [ ! -d /www/wdlinux/nginx_php-${Ver}/lib/php/extensions ];then
  141.         mkdir -p /www/wdlinux/nginx_php-${Ver}/lib/php/extensions/no-debug-zts-20131226
  142.         ln -sf /www/wdlinux/nginx_php-${Ver}/lib/php/extensions/no-debug-zts-20131226 /www/wdlinux/nginx_php-${Ver}/lib/php/extensions/no-debug-non-zts-20131226
  143. fi
  144. service php-fpm start
  145. echo
  146. echo "php update is OK"
  147. fi
  148. echo
复制代码
作者: helen5106    时间: 2021-1-27 16:03

php安装过程中， Lib可能出错，参考https://blog.csdn.net/zsl10/article/details/52143713
作者: besthome    时间: 2021-3-31 23:40

可能还是每个服务器有其独特的情况吧，在wdcp下升级mysql，极少有顺利的。
mysql升级后，pid有问题，不想折腾，好在云服务器快照下，回滚了。
作者: jotian    时间: 2021-6-25 19:01

我也是昨天折腾了一天，全报错，我是想升级到5.7.3.4，可能就如上面说的我没有设置boost_1_66_0



欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2