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 |