Upgrading Percona XtraDB Cluster

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
  • Run
    mysql_upgrade -u root -p

    again.

Leave a Reply