My Oracle Support Banner

How to Upgrade/Downgrade MySQL NDB Cluster using RPM (Doc ID 1941472.1)

Last updated on MARCH 31, 2021

Applies to:

MySQL Cluster - Version 7.1 and later
Generic Linux

Goal

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

If you are upgrading/downgrading MySQL Cluster via MySQL Cluster Manager (MCM), see also the following document for more details: How to Upgrade/Downgrade MySQL Cluster When Using MySQL Cluster Manager (MCM)
For downgrade between major versions, go to this Note 2266414.1.

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
 Read "How to Upgrade MySQL NDB Cluster" document first
 Check the compatibility between versions
 I) Online upgrade/downgrade
 1- Backup first
 a) Perform a native cluster backup
 b) Obtain a copy of the binary logs from one of the SQL nodes using your favourite copy method
 c) A schema dump using the mysqldump
 2- Perform the rolling upgrade/downgrade
 a) First, upgrade/downgrade one SQL node at a time
 b) Second, upgrade/downgrade all the Management nodes
 b) Last, upgrade/downgrade one Data node at a time
 3- Run mysql_upgrade
 4- Verify the NDB cluster tables and data
 II) Offline upgrade/downgrade
 1- Backup first
 a) Perform a native cluster backup
 b) Obtain a copy of the binary logs from one of the SQL nodes using your favourite copy method
 c) A schema dump using the mysqldump
 2- Stop the NDB Cluster
 a) Stop SQL nodes
 b) Shutdown Cluster
 3- Upgrade/Downgrade the NDB Cluster on all nodes
 a) Upgrade/Downgrade all SQL and Management nodes
 b) Upgrade/Downgrade all Data nodes
 4- Start the NDB Cluster
 a) Start Management nodes
 b) Start Data nodes
 c) Start SQL nodes (if not already started before)
 5- Run mysql_upgrade
 6- 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.