My Oracle Support Banner

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

Last updated on JUNE 08, 2018

Applies to:

MySQL Cluster - Version 7.1 and later
Generic Linux

Goal

Upgrade/Downgrade MySQL NDB Cluster using RPM, between major versions or patch releases.

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.