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]


About NhocConan

A super lazy guy who tries to write tech blog entries in English.He is lazy, so he can only write when he is in a good mood or when he is tired of coding.

Leave a comment

Your email address will not be published. Required fields are marked *