Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-310

Swap active/reserve node for a database instance

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: EXASolution, EXAStorage
    • Labels:
      None
    • Solution:
      Hide

      Synopsis

      This article guides you through the procedure of switching a database node of an instance with a reserve node.

      Please note that

      1. The procedure requires a maintenance window of at least half an hour
      2. The tasks performed in EXAoperation requires a user with at least "Administrator" privileges
      3. 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
      Show
      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
    • Category 1:
      Cluster Administration - DB Instance Management
    • Category 2:
      Cluster Administration - Cluster Management

      Attachments

        Issue Links

        1. 1_check_database_operations.png
          1_check_database_operations.png
          50 kB
        2. 2_shutdown_database_2.png
          2_shutdown_database_2.png
          50 kB
        3. 2_shutdown_database.png
          2_shutdown_database.png
          51 kB
        4. 3_edit_database_2.png
          3_edit_database_2.png
          71 kB
        5. 3_edit_database.png
          3_edit_database.png
          103 kB
        6. 4_startup_database_2.png
          4_startup_database_2.png
          50 kB
        7. 4_startup_database.png
          4_startup_database.png
          103 kB
        8. 5_move_segments_2.png
          5_move_segments_2.png
          64 kB
        9. 5_move_segments_3.png
          5_move_segments_3.png
          57 kB
        10. 5_move_segments_4.png
          5_move_segments_4.png
          41 kB
        11. 5_move_segments_5.png
          5_move_segments_5.png
          65 kB
        12. 5_move_segments_6.png
          5_move_segments_6.png
          97 kB
        13. 5_move_segments.png
          5_move_segments.png
          96 kB
        14. 6_reactivate_nodes_2.png
          6_reactivate_nodes_2.png
          68 kB
        15. 6_reactivate_nodes.png
          6_reactivate_nodes.png
          116 kB

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: