The solidDB HotStandby (HSB) related components are administered with configuration parameters and ADMIN COMMANDs.
Configuration parameters
Parameters are grouped according to section categories in configuration files.
There are four types of parameters:
▪ Server-side parameters in the server-side solid.ini configuration file
▪ There are two HSB-specific sections in the server-side solid.ini configuration file: [Cluster] and [HotStandby], see Cluster section and HotStandby section.
▪ Various other parameters can also affect HSB functionality.
Note If you use the Watchdog sample provided with the solidDB package, the solid.ini file also contains watchdog-specific parameters in a [Watchdog] section. For information, see the section Watchdog sample application.
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 changes to any configuration file do not take effect until the next time that the corresponding program is started.
▪ Use the ADMIN COMMAND 'describe' command to query the current settings and the ADMIN COMMAND 'parameter' command to change the settings of a running solidDB server dynamically,
The high availability behavior is controlled with the HotStandby API (HSB API), which is based on a subset of solidDB ADMIN COMMAND commands.
This subset of commands is identified by the command prefix hotstandby, abbreviated as hsb. These commands can be run by using any SQL-capable tool (like solsql) or programmatic interfaces like ODBC or JDBC.
The hotstandby admin commands control the high availability state of a solidDB HSB server, or retrieve state information. The commands can be run manually or programmatically. The solidDB HA management tools, High Availability Controller (HAC), and the Watchdog sample use the commands programmatically.
You can use the HSB commands to program your own application to manage high availability in solidDB, for example, to implement an integration to an external cluster management software.
For more details about the HotStandby ADMIN COMMAND commands and their syntax, see HOTSTANDBY.
For more details about the HAC ADMIN COMMAND commands and their syntax, see HACONTROLLER.
HotStandby and access rights
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.
HotStandby and solidDB tools
The solidDB data management tools can be used with HotStandby servers.
Console tools for issuing ADMIN COMMANDs
You can run HotStandby-specific administrative commands (ADMIN COMMAND 'hotstandbyoption') 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:
ADMIN COMMAND 'hotstandby status connect';
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:
hotstandby status connect
Import and export tools
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.
High Availability Manager (HAM) sample
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 HAC.