Adding Nodes to the HADB

When you create new nodes and add them to the database, you increase processing and storage capacity. To add nodes, use the hadbm addnodes command. The syntax is as follows:

hadbm addnodes [--no-refragment] [--spares=sparecount] --dbpassword=password | --dbpasswordfile=file [--inetdsetupdir=path] --hosts=node-list [dbname]

For example:

hadbm addnodes --dbpassword secret123 --hosts n6,n7,n8,n9

After you have added nodes, you must perform these additional tasks:

For details, see "Setting Up the JDBC Connection Pool".


Note

If you created the database using --inetd, you must do the following:

  • Use the --no-refragment option and refragment the database in a separate step using the hadbm refragment command.
  • Take extra steps to update the inetd configuration files to take into account the new nodes you add.

The hadbm addnodes command options are listed in the following table.

Table 0-14  hadbm addnodes Options 

Long Form

Short Form

Default

Description

--no-refragment

-r

not specified

If specified, does not refragment the database during node creation; you can refragment the database later using the hadbm refragment command. For details about refragmentation, see "Refragmenting the HADB".

You must use this option if you created the database using --inetd. In this case, you must refragment the database in a separate step using hadbm refragment.

If you do not have sufficient device space for a refragmentation, you can recreate the database with more nodes. See "Adding Nodes Without Refragmenting".

--spares

-s

0

Specifies the number of new spare nodes in addition to those that already exist. This number must be even and must not be greater than the number of nodes added. Spare nodes are optional, but having two or more ensures high availability.

--dbpassword

-p

none

Specifies the HADB system user password. You can use --dbpasswordfile instead. For details, see "Using the hadbm Command".

--dbpasswordfile

-P

none

Specifies a file that stores the password for the HADB system user. For details, see "Using the hadbm Command".

--hosts

-H

none

Specifies a comma-separated list of new host names for the new nodes in the database. One node is created for each comma-separated item in the list. The number of nodes must be even.

Using duplicate host names creates multiple nodes on the same machine with different port numbers. Make sure that nodes on the same machine are not mirror nodes.

Odd numbered nodes are in one DRU, even numbered nodes in the other. If --spares is used, new spare nodes are those with the highest numbers.

If the database was created with double network interfaces, the new nodes must be configured in the same way. See "Configuring Double Networks".

dbname

none

hadb

Specifies the database name. The database must be in the HA Fault Tolerant or Fault Tolerant state. For more information about database states, see "Getting the Status of the HADB".


Legal Notices