MySQL5.6升級5.7步驟

升級步驟：

1、對mysql5.6進行全庫備份（******）用於失敗倒回
2、關閉mysql5.6版本資料庫
3、將mysql5.7軟體部署
4、修改配置信息
5、修改啟動腳本
6、啟動mysql5.7資料庫
7、mysql_upgrade升級資料庫相關參數
8、重啟資料庫，測試升級結果

首先對資料庫進行物理備份,利用Percona Xtrabackup.
關閉5.6的資料庫
安裝5.7的二進位安裝包.
修改/etc/profile 改變環境變數指向5.7.執行source /etc/profile 生效
編輯5.7的system啟動文件

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/data/app/mysql/bin/mysqld --defaults-file=/mysql/3306/my.cnf
LimitNOFILE = 5000

啟動資料庫
systemctl start mysqld
使用mysql_upgrade 檢查

[root@db01 ~]# mysql_upgrade -S /mysql/mysql.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
Upgrading the sys schema.
Checking databases.
sys.sys_config                                     OK
world.city                                         OK
world.country                                      OK
world.countrylanguage                              OK
Upgrade process completed successfully.
Checking if update is needed.

重啟資料庫

[root@db01 ~]# systemctl restart mysqld
[root@db01 ~]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      8902/sshd           
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      8912/postmaster     
tcp6       0      0 :::3306                 :::*                    LISTEN      10347/mysqld        
tcp6       0      0 :::22                   :::*                    LISTEN      8902/sshd           
tcp6       0      0 ::1:5432                :::*                    LISTEN      8912/postmaster