Upgrade MySQL Router

Upgrade MySQL Shell

Upgrade MySQL Server

Assumptions: 

• Single-Primary

Minor release

• Ensure you have a backup and you know how to restore it.

• Ensure all important connections use MySQL Router.

• Encourage developers to write idempotent code (an operation is idempotent if performing it multiple times has the same effect as performing it once).

On any node...

mysqlsh

\c icadmin@node1

dba.getCluster().status()

• Check "status" of the replica set is "OK" and the "status" of all nodes is "ONLINE".

• Choose one of the nodes with a "memberRole" of "SECONDARY" as the first node to patch and, on that node, do...

sudo systemctl stop mysqld

sudo yum clean all

sudo yum -y update percona-server-server percona-server-client percona-server-shared percona-icu-data-files

sudo yum -y percona-mysql-shell percona-xtrabackup-80

sudo yum list installed | grep percona

sudo systemctl start mysqld

• On any node...

mysqlsh

\c icadmin@node1

dba.getCluster().status()

• Check "version" of the node you patched shows the correct version number.

• Repeat for the rest of the SECONDARY nodes.

• Finally, perform the same steps on the Primary node...

Major Release

TODO

Status Check

Bibliography