MySQL 升级

1.配置慢速关闭

set global innodb_fast_shutdown=0;

2. 解压新的压缩包

tar xvf mysql-5.7.29-linux-glibc2.12-x86_.tar.gz

3. 关闭原实例

systemctl stop mysql3307

4. 替换安装包

mv mysql3307/ mysql3307_bak
mv mysql-5.7.29-linux-glibc2.12-x86_ /usr/local/mysql3307
cp my3307.cnf …/…/mysql3307/conf

5.修改权限

chown -R mysql:mysql mysql3307

6.启动

systemctl start mysql3307

7.升级程序

./mysql_upgrade -u root -S /var/lib/mysql/mysql3307.sock

Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Found outdated sys schema version 1.5.1.
Upgrading the sys schema.
Checking databases.
sbtest.sbtest1 OK
sbtest.sbtest10 OK
sbtest.sbtest2 OK
sbtest.sbtest3 OK
sbtest.sbtest4 OK
sbtest.sbtest5 OK
sbtest.sbtest6 OK
sbtest.sbtest7 OK
sbtest.sbtest8 OK
sbtest.sbtest9 OK
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.

8.重启mysql

systemctl restart mysql3307 或者其他方式重启

9. check error.log

10.升级完成