Add New Node To Database Instance

Once you have added and installed new nodes, you need to complete the enlargement process by adding the new nodes to storage, the volume, and the database. The following steps apply:

Considerations

  • Either remove any database quota (Maximal Volume Size) that might be set or set it to a high enough value during the enlargement / reorganize process.
  • You must enlarge the database with a number of nodes that is a multiple of the redundancy you have chosen for the volume. Otherwise, you will first need to drop the redundancy. For example, it is possible to enlarge without dropping the redundancy if you add two, four, six, eight, ... (a multiple of two) number of nodes to a cluster if the redundancy is set to “2”.
  • When reducing or increasing the redundancy, a recovery process will take place. DO NOT continue with the enlargement procedure during the recovery process.

In case of potential data loss during the procedure, ensure you have a recent backup available offline that is stored outside of the cluster.

Prerequisites

  • You have added, installed, and activated new nodes (refer to Add and Activate Data Nodes for details on how to add and activate data nodes)(refer to for details on how to add data nodes).
  • You have access to a user in EXAoperation with at least Administrator privileges.
  • You know the MAC addresses and the disk layout of the running part of the cluster.

Procedure

You can follow the below steps to add a new node to a database instance. As an example, the below steps describes the procedure for adding 2 data nodes to a 2-node system with a data volume redundancy of 2.

Shutdown All Databases

  1. Log in to EXAoperation as an admin user.
  2. From Services > EXASolution check for running operations.

  3. If you stop the database while there are operations running, these operations will be aborted. It is recommended to wait until all running operations have completed before stopping the database.

  4. Select the database instances that should be shut down and click Shutdown.
  5. Refresh the page until the status of all instances change from Running to Created.Additionally, you can also monitor the procedure in the logservices.

Add Nodes to Storage

  1. After you have installed the nodes in the Install Node(s) step, they will appear in the storage overview screen as shown below:
  2. Next, from the Services > EXAStorage screen, select the new unused nodes and click Add Unused Disks.
  3. The unused disks are added, and the state for these disks are displayed as ONLINE.

Add Nodes to Volumes

  1. Go to Services > EXAStorage and click on the name of the volume instance to open the volume details screen.
  2. The EXAStorage Volume screen is displayed as shown below:
  3. Click Edit to edit the volume.
  4. Ensure you are editing the correct volume.

  5. Select the new nodes that you want to add to the volume from the List of Nodes to add and click the arrow to add them.
  6. In the Master Nodes to add field, type the number of active nodes that you are adding to the volume and click Apply to save your changes.
  7. You are returned to the volume information screen, and the new nodes added are visible in the Node list.

Add New Nodes to Database

As a good practice one node should be assigned to only one database. Two databases should not share same node.

  1. Go to Services > EXASolution and select the database instance.
  2. The database instance screen is displayed.

  3. Click Edit to edit the database instance.
  4. Ensure you are editing the database instance.

  5. Select the new nodes that you want to add from the Add Reserve Nodes and click the arrow to add them. Click Apply to save your changes.
  6. You are returned to the volume information screen, and the new nodes are visible in the Node list as reserve nodes.
  7. Select Enlarge from the Actions drop down list and click Submit.
  8. Enter the number of additional active (or master) database nodes. In our example, the number of nodes we are adding to the database is '2'.
  9. Click Apply. The database starts up.
  10. Once the process has completed, the active data nodes are running.

Reorganize Database

After completing all the operations in EXAoperation, run the REORGANIZE DATABASE command from your SQL client to finish the process. This will evenly re-distribute the data among the 2 new nodes. If you want to know how long it takes to reorganize the database, see Estimate Duration of REORGANIZE DATABASE.

Failure to perform this step would result in a data imbalance between the nodes and could result in decreased performance.