[教程] WDCP升級mysql 8.0腳本，親測可用 2021.01.26

helen5106

1. #!/bin/bash
   
2. # mysql 8.0 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://fudaan.com
   
5. # Modify: windsage
   
6. 
   
7. IN_DIR="/www/wdlinux"
   
8. 
   
9. if [ ! $1 ];then
   
10.     MYS_VER="8.0.11"
    
11. else
    
12.     MYS_VER=$1
    
13. fi
    
14. 
    
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
    
28. 
    
29. 
    
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. # 數(shù)據(jù)庫文件夾默認要求是data
    
38. mkdir -p $IN_DIR/mysql-${MYS_VER}/data
    
39. fi
    
40. 
    
41. if [ ! -d mysql-${MYS_VER} ];then
    
42. tar zxvf mysql-boost-${MYS_VER}.tar.gz
    
43. fi
    
44. 
    
45. cd mysql-${MYS_VER}
    
46. 
    
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
    
70. 
    
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
    
79. 
    
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. # 或者把備份的數(shù)據(jù)庫復制回來，注意不要覆蓋performance_schema
     
105. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
     
106. echo
     
107. echo "-------------------------------------------------------------"
     
108. echo "數(shù)據(jù)庫需要初始化，自動生成的密碼會存入mysql的日志，默認在/var/log/mysql/error.log"
     
109. echo
     
110. echo "此時查看mysql日志，應該一切正常了，但新手朋友注意了，此時你的httpd無法啟動了，需要編譯安裝php。"
     
111. echo

復制代碼

• 注意，安裝的事8.0.11, 如果是其他的，需要修改boost的文件夾名字，boost_1_66_0 這個地方，可以解壓mysql后看看，可能是其他名字

helen5106

遇到的問題

1. 內(nèi)存不夠容易卡死，增加swap文件
2. my.cnf有寫參數(shù)錯誤，導致初始化錯誤,根據(jù)提示,刪掉一些沒用參數(shù)，把/www/wdlinux/mysql/data重新命名，然后重新初始化
mysqld --initialize --user=mysql --console --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/data

helen5106

升級完mysql, 重新編譯php

下面是php 7.3.26

1. #!/bin/bash
   
2. # PHP 7.1 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://fudaan.com
   
5. # Modify: slrainy
   
6. 
   
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
    
27. 
    
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
    
40. 
    
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
     
120. 
     
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

php安裝過程中， Lib可能出錯，參考https://blog.csdn.net/zsl10/article/details/52143713

besthome

可能還是每個服務器有其獨特的情況吧，在wdcp下升級mysql，極少有順利的。
mysql升級后，pid有問題，不想折騰，好在云服務器快照下，回滾了。

jotian

我也是昨天折騰了一天，全報錯，我是想升級到5.7.3.4，可能就如上面說的我沒有設置boost_1_66_0