Basics of HotStandby administration

The HotStandby related components are administered with configuration parameters and ADMIN COMMANDs.

Parameters are grouped according to section categories in the solid.ini configuration file. When you are using HotStandby, you mainly use the [HotStandby] section of the solid.ini configuration file. Other sections can be used to configure the overall behavior of the solidDB^® server.

The High Availability Controller (HAC) is configured by using the solidhac.ini configuration file. The parameters in the solidhac.ini configuration file are also grouped according to different section categories.

The High Availability Manager (HAM) is configured by using the HAManager.ini configuration file. The parameters in the HAManager.ini identify the HA Controller instances so that the High Availability Manager has access to them.

You can change configuration parameters in the following ways:

▪Edit the configuration files solid.ini, solidhac.ini and HAManager.ini manually.

Note The server reads the configuration files during startup only, and therefore any changes to any configuration file will not take effect until the next time that the corresponding program is started.

▪Use the following ADMIN COMMAND syntax to change the settings of a running solidDB^® server dynamically:

ADMIN COMMAND 'parameter hotstandby.2SafeAckPolicy=2';
ADMIN COMMAND 'parameter com.listen="tcp sf_server 1315"';

Note All configuration parameters cannot be changed dynamically.

The HSB API is provided as a syntax extension to solidDB^® SQL, in the form of ADMIN COMMAND:

The HSB commands can be issued via any SQL-capable interactive tool (like solsql), or programmatically, through ODBC or JDBC.

There are no specific access rights for HotStandby, normal administrator access rights suffice. To execute the HotStandby administrative commands, SYS_ADMIN_ROLE or SYS_CONSOLE_ROLE access rights are required.

The solidDB^® data management tools can be used with HotStandby servers.

You can issue HotStandby-specific administrative commands (ADMIN COMMAND 'hotstandby <option>') with solidDB^® SQL Editor (solsql), and solidDB^® Remote Control (solcon).

When you are using solsql, the command name must be given with single quotation marks and a semicolon at the end of the command. For example:

When you are using solcon, the command name must be given without the ADMIN COMMAND prefix, quotation marks, and without the semicolon at the end of the command. For example:

The import and export tools, solidDB^® Speed Loader (solloado or solload), solidDB^® Export (solexp), and solidDB^® Data Dictionary (soldd) can also be used with HotStandby.

The solidDB^® package also contains a sample tool, High Availability Manager (HAM) that can be used to monitor solidDB^® HotStandby states, and to control HSB servers and High Availability Controllers (HAC). HAM can be used only with the HA Controller.