How to Upgrade/Downgrade MySQL NDB Cluster using RPM
(Doc ID 1941472.1)
Last updated on MARCH 01, 2023
Applies to:
MySQL Cluster - Version 7.1 and laterGeneric 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 |