Swap active/reserve node for a database instance

Synopsis This article guides you through the procedure of switching a database node of an instance with a reserve node. Please note that The procedure requires a maintenance window of at least half an hour The tasks performed in EXAoperation requires a user with at least "Administrator" privileges The performance of the database is decreased until the segments are fully moved to another node Applicability This procedure is usable for all versions of EXASuite 5.0. Procedure 1. CHECK DATABASE OPERATION Navigate to the EXAoperation page "Services > EXASolution" Review the database list and check if the column "Background Restore" indicates "None" on all instances 2. SHUTDOWN DATABASE Open "Services > EXASolution" Select all (running) EXASolution instances Click on the button "Shutdown" Reload the page until all instances change their status from "Running" to "Created" You may follow the procedure in an appropriate logservice: System marked as stopped. Successfully send retry shutdown event to system partition 64. EXASolution exa_db1 is rejecting connections controller-st(0.0): Shutdown called. User 0 requests shutdown of system. 3. EDIT DATABASE / DEACTIVATE NODE Open "Services > EXASolution" Click on the name of the database instance Edit the database instance In section "Deactivate Database Nodes" move the desired node to the right side and apply 4. STARTUP DATABASE You will find the node in state "deactivated" Choose "Startup" from the drop down menu and click "Submit" Open the "Services > EXASolution" page Reload the page until all instances change their status from "Created" to "Running" 5. MOVE SEGMENTS TO OTHER NODE Open the "Services > EXAStorage" page Click on the persistent data volume of the concerning database instance Open the node which has been recently deactivated from the database instance Click on "Move Node" Tick the node and apply with "Move Node" The new node appears on the node list on the right side now Data segments will be moved now Until the recovery is done the performance of the database instances will be decreased 6. REACTIVATE NODE Open the "Services > EXASolution" page Click on the name of the database instance Edit the database instance again In section "Reactivate Database Nodes" move the node to the right side and apply