How to Change NoOfReplicas In MySQL NDB Cluster
(Doc ID 1476824.1)
Last updated on NOVEMBER 02, 2023
Applies to:
MySQL Cluster - Version 4.1 and laterInformation in this document applies to any platform.
Goal
The example used here will be to change from NoOfReplicas=1 to NoOfReplicas=2.
How to change NoOfReplicas in MySQL NDB Cluster.
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 |
| Notes |
| Test case |
| 1. Start Cluster |
| 1.1 Management node |
| 1.2 Data nodes |
| 1.3 SQL node |
| 1.4 Confirm all nodes started |
| 2. Create schema "world" |
| 2.1 Download schema "world" from here |
| 2.2 Import schema "world" into MySQL Cluster |
| 2.3 ALTER TABLEs from InnoDB storage engine to NDB |
| 3. Backup Cluster using native tools |
| 3.1 Start backup on Management Client |
| 3.2 Confirm backup files on all Data nodes |
| 4. Backup schema using mysqldump |
| 5. Stop Cluster |
| 5.1 Management & Data nodes |
| 5.2 SQL node |
| 6. Change NoOfReplicas from 1 to 2 |
| 7. Start Cluster |
| 7.1 Management node (with option --initial) |
| 7.2 Data nodes (with option --initial) |
| 7.3 SQL node |
| 7.4 Confirm all nodes started |
| 8. Restore schema |
| 8.1 Restore table structures backed up with mysqldump |
| 8.2 Confirm tables' availability and structure |
| 9. Restore data using ndb_restore |
| 9.1 From Node ID 2 backup |
| 9.2 From Node ID 3 backup |
| 9.3 From Node ID 4 backup |
| 9.4 From Node ID 5 backup |
| 9.5 Confirm the data restored is available |
| 9.6 Confirm Cluster is still running properly |
| References |