Shulou(Shulou.com)06/01 Report--

In the process of deploying MySQL, binary packages are generally used, so when upgrading MySQL version, the latest MySQL package can be decompressed to basedir. Of course, if MySQL does not have any data, it can be directly deleted and reinstalled. When updating, MySQL service needs to be stopped. Note that if it is a production environment, it is necessary to do the corresponding standby switch before upgrading. Secondly, only normal version iterations can be used during upgrading, and version updates cannot be praised. For example, upgrading from 5.1 to 5.7 is not feasible. Normally, it should be upgraded from 5.6 to 5.7. The following is a simple explanation of how to use mysql_upgrade to upgrade the version under the binary package:

#Start upgrade after shutdown MySQL process [root@localhost ~]# cd /usr/local/[root@localhost local]# rm -rf mysql[root@localhost local]# tar -jxvf /usr/local/src/mysql-5.7.17-linux-glibc2.5-x86_64.tar.bz2 -C ./ [root@localhost local]# mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql[root@localhost local]# cat /etc/ld.so.conf.d/mysql.conf#Check if lib path is correct/usr/local/mysql/lib[root@localhost local]# ldconfig -v#Reload the latest package to the system, note that some software that depends on MySQL may need to be recompiled [root@localhost local]# /etc/init.d/mysqld start#Try to start, Note that some variable parameters have been cancelled in MySQL 5.7. It is best to query whether the variable in my.cnf exists on another MySQL 5.7 installed server. If it does not exist, it means that the parameter has been cancelled in the new version. It needs to be deleted until it starts.[root@localhost local]# /usr/local/mysql/bin/mysql_upgrade -u root -p#Use mysql_upgrade to update and upgrade.

mysql_upgrade will check and modify the old version of the data, confirm that the upgrade is successful, upgrade will be carried out, after the upgrade is completed, mysql_upgrade_info will be generated under databasedir to record the latest MySQL version, start MySQL, upgrade completed

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.