My Oracle Support Banner

How to Upgrade/Downgrade MySQL Cluster When Using MySQL Cluster Manager (MCM) (Doc ID 2028705.1)

Last updated on JULY 02, 2018

Applies to:

MySQL Cluster - Version 7.0 and later
Information in this document applies to any platform.

Goal

Upgrade or downgrade MySQL Cluster when using MySQL Cluster Manager (MCM), between major versions or patch releases.

The upgrade cluster command can perform major as well as minor series upgrades. Despite the name of this command, upgrade cluster can also be used to perform MySQL Cluster downgrades.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Pre-requisites
 Check the compatibility between versions
 Upgrade/Downgrade
 1- Backup first
 a) Run backup cluster
 b) Obtain a copy of the binary logs from one of the SQL nodes using your favourite copy method
 c) A schema dump using mysqldump
 2- Perform the upgrade/downgrade
 a) Extract the contents of the new MySQL Cluster binary archive distribution
 b) Add a new package pointing to directory previously created
 c) Guarantee the Cluster is fully operational
 d) Run upgrade cluster
 e) List clusters in the site again to verify that the cluster now runs the new package
 e) Show the Cluster status to verify that it is fully operational
 4- Run mysql_upgrade
 5- Verify the Cluster tables and data
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.