CUBRID utilities used for the HA feature are as follows. The following utilities can be used only in servers where the ha_mode parameter is configured to on.
The syntax for the cubrid changemode utility, which is used to output or change the state of the database server, is as follows: The history of the server error log is output every time the operation mode of the server changes. The current operation mode is output if the -m option is not specified.
cubrid changemode [option] <database_name>@<hostname>
-m, --mode=<MODE> : Specifies the mode to change. Available values are active, standby and maintenance.
The syntax for the cubrid copylogdb utility, which is used to copy the transaction log created by the remote database server to a specified path, is as follows:
cubrid copylogdb [option] <database_name>@<hostname>
-L, --log-path=<PATH>: A file path to which the copied transaction log is to be stored.
-m, --mode=<MODE>: Specifies the method by which the transaction log page is to be copied. The one of following options are available: sync, semisync, async. Guaranteeing sending and writing logs jobs is determined by selected mode.
There are three ways of sending the transaction log as follows: You should choose one that meets your operation policy.
The syntax for the cubrid applylogdb utility, which reads the copied transaction log file from the specified path, analyzes it, and then reflects it to the local database server, is as follows:
cubrid applylogdb [option] <database_name>@<hostname>
-L, --log-path=<PATH> : The path to the transaction log file to be read.
--max-mem-size=<SIZE> : The maximum memory size available for process. The memory unit is MB; up to 1,000 MB is allowed.
Note See the APPL_SERVER_MAX_SIZE description to get information about the requirements of CAS process restart; For cubrid applylogdb, you can specify the maximum memory size directly by using the --max-mem-size option.