To move the HCP database to optimal volumes:
- From the HCP Configuration Menu, enter s to display the HCP Service Menu.
- In response to the confirming prompt, enter y or yes to confirm your entry or n or no to try again.
When you enter y or yes, the HCP Service Menu appears.
HCP Service Menu ============================================= [1] Recover an HCP Node [2] Display the Current System Status [3] Shut down the HCP System [4] Free Space on Nodes [5] Install a Hotfix [6] Finalize Migration [7] Change Region Count [8] Configure Routine Database Maintenance [9] Configure Time Settings [10] Migrate Metadata Regions [11] Perform Node Swap [s] Perform SSD Maintenance [m] Manage Database Volumes [q] Return to Configuration Menu Enter your choice. [Default: 1]: m
- From the HCP Service Menu, enter m.
- In response to the confirming prompt, enter y or yes to confirm your entry or n or no to try again.
When you enter y or yes, the HCP Setup displays the Manage Database Volumes menu.
Manage Database Volumes ============================================= [1] Move Database [d] Delete Old Database [q] Return to Configuration Menu [Enter your choice. [Default: 1]:
- From the Manage Database Volumes menu, enter 1.
- In response to the confirmation prompt, enter y or yes to confirm your entry or n or no to try again.
When you enter y or yes, HCP Setup displays the Move Database menu.
Move Database ============================================= Volumes to move: Node | Type | Current volume | New volume | | (Available/Total) | (Available/Total) ------------------------------------------------------------ 172.20.59.125 | pgdata | /RIS/archive33 | /RIS/archive94 | pgidx | (450M/1006) | (1806/2006) 172.20.59.125 | pgxlog | /RIS/archive34 | /RIS/archive95 | | (450M/1006) | (1806/2006) 172.20.59.129 | pgxlog | /RIS/archive33 | /RIS/archive94 | | (350M/1006) | (1506/2006) Executing this procedure will move the database from the current volume to the new volume. This process cannot be undone after it is complete. Please review the changes before proceeding. Do you want to move the database? [Default: no]: yes You chose: “yes”, is this correct? [Default: yes]: yesFrom the Move Database menu, HCP Setup asks you to review your database configuration and warns you that the process cannot be undone after the database move is complete. - When you have reviewed the configuration, enter y or yes to confirm the move or n or no to try again.
- In response to the confirmation prompt, enter y or yes to confirm your entry or n or no to try again.
After the procedure begins, the progress of the database move appears and details the current status of the HCP Service procedure.
Starting to poll nodes for progress Thu Jan 16 09:51:15 2020 Current status: node 042: 40% Complete (2/5): Running arcShutdown Thu Jan 16 09:52:13 2020 Current status: node 042: 60% Complete (3/5): Running mountDisks Thu Jan 16 09:52:48 2020 Current status: node 042: 80% Complete (4/5): Running move_pgdata Thu Jan 16 09:52:55 2020 Current status: node 042: 100% Complete: Deploy complete Thu Jan 16 09:54:07 2020 Current status: node 042: 100% Complete: Rebooting node Thu Jan 16 09:54:12 2020 Current status: node 042: 100% Complete: Waiting for node to become available. Thu Jan 16 09:56:12 2020 Current status: node 042: 100% Complete: Waiting for node to become available. Thu Jan 16 09:58:13 2020 Current status: node 042: 100% Complete: Waiting for node to become available. Thu Jan 16 10:00:03 2020 Current status: node 042: 100% Complete: All nodes available Thu Jan 16 10:00:38 2020 Current status: node 042: 100% Complete: All nodes available and metadata is balanced >>> HCP Service Procedure successful Press ENTER to continue:When the procedure is complete, press Enter to return to the HCP Service menu.You can now delete the database from the older database volume.