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:

    [bash]mysql -u root -p < ./sys_57.sql[/bash]

  • Run

    [bash]mysql_upgrade -u root -p[/bash]


Leave a Reply