Guide can be found at https://www.percona.com/doc/percona-xtradb-cluster/5.7/howtos/upgrade_guide.html. There is no need to re-invent the wheel. I am too lazy to do it.
Issue 1: If you are running mysql_upgrade and face the following error: “mysql_upgrade: [ERROR] 1136: Column count doesn’t match value count at row 1”, just do as follows:
- Clone https://github.com/mysql/mysql-sys and go to this folder.
- Run the following:
mysql -u root -p < ./sys_57.sql
mysql_upgrade -u root -p