mysql升级小结和mysql_upgrade的用途

1 源端备份
innobackupex --host=localhost --user=backup --password='VfvVunpnwVHEcAY4JMwW' --slave-info --safe-slave-backup --defaults-file=/etc/my.cnf /home/admin/mysql_backup/sunyu

2 scp
..

3 目标端应用apply-log
innobackupex --defaults-file=/data/mysql/mysql3306/conf/my.cnf --apply-log 2017-05-18_23-24-13/

4 copy-back
innobackupex --defaults-file=/data/mysql/mysql3306/conf/my.cnf --copy-back 2017-05-18_23-24-13/

5 upgrade
mysql_upgrade -uroot -p -S /data/mysql/mysql3306/sock/my3306.sock --force