Administering HotStandby with ADMIN COMMANDs (HotStandby API)
The HotStandby API (HSB API) is used for monitoring and controlling the server processes. For example, the solidDB® High Availability Controller (HAC) uses the HSB API. Another example is the Watchdog sample program that is included in the solidDB® server package.
The HSB API is provided as a syntax extension to solidDB® SQL, in the form of ADMIN COMMAND:
ADMIN COMMAND hotstandby hsb-commandoptions
or
ADMIN COMMAND hsb hsb-command options
The HSB commands can be issued via any SQL-capable interactive tool (like solsql), or programmatically, through ODBC or JDBC.
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.