1. 小版本升级，先升级从库，再升级主库

ip addr #查看vip的位置，确认这台服务器是从库

2. 复制5.7.22 安装包到指定目录下

scp -r root@10.11.11.68:/opt/mysql/Percona-Server-5.7.22-22-Linux.x86_64.ssl101  /opt/mysql
chown -R mysql. /opt/mysql/Percona-Server-5.7.22-22-Linux.x86_64.ssl101

3. 停掉mysql服务

service mysqld stop

4. 删除旧的软链接，创建新的软链接

unlink /usr/local/mysql
ln -s /opt/mysql/Percona-Server-5.7.22-22-Linux.x86_64.ssl101 /usr/local/mysql

5. 配置文件中添加慢日志监控，监控超过1s的慢SQL

# vi /etc/my.cnf 添加以下：
long_query_time = 1

6. 确认/etc/init.d/mysqld启动脚本中basedir=/usr/local/mysql

7. 启动mysql服务

service mysqld start

8. 确认PATH环境变量配置是否正确

cat ~/.bash_profile 或 cat /etc/profile

9. 升级确认

mysql_upgrade -uroot -S /tmp/mysql.sock (输出 Upgrade process completed successfully.完成)

如遇到如下报错：
mysql_upgrade: [ERROR] 1205: Lock wait timeout exceeded; try restarting transaction

则关闭mysql-monitor-agnet监控，关闭mysql slave复制进程后再重试。