My Oracle Support Banner

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

Last updated on JANUARY 15, 2021

Applies to:

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


On this document we will cover the upgrade of MySQL NDB Cluster using MySQL Cluster Manager (MCM) between major & minor versions, and the downgrade of the same but within the same major version.

For downgrade between major versions, go to this <Note 2266414.1>.
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.


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
 Check the compatibility between versions
 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- Verify the Cluster tables and data

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