Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

cubrid_ha.conf

The cubrid_ha.conf file that has generation information on CUBRID HA is located in the $CUBRID/conf directory.

ha_node_list

A parameter used to specify the group name to be used in the CUBRID HA group and the host name of member nodes in which failover is supported. You can separate names of group and their member nodes by using an "at" mark (@). The default is localhost@localhost.

The followings must be registered in /etc/hosts: 1) the host names of member nodes specified in this parameter, 2) the host name of a node to be configured.

A node in which the ha_mode value is set to on must be specified in ha_node_list. The value of the ha_node_list of all nodes in the CUBRID HA group must be identical. When a failover occurs, a master node is determined in the order specified in the parameter.

This parameter can be modified dynamically. If you modify the value of this parameter, you must execute cubrid heartbeat reload to apply the changes.

ha_replica_list

A parameter used to specify the group name to be used in the CUBRID HA group and the host name of member nodes in which failover is not supported. You can separate names of group and their member nodes by using an "at" mark (@). The default is NULL.

The group name must be identical to the name specified in ha_node_list.

The followings must be registered in /etc/hosts: 1) the host names of member nodes specified in this parameter, 2) the host name of a node to be configured.

A node in which the ha_mode value is set to replica must be specified in ha_replica_list. The ha_node_list values of all nodes in the CUBRID HA group must be identical.

This parameter can be modified dynamically. If you modify the value of this parameter, you must execute cubrid heartbeat reload to apply the changes.

ha_port_id

A parameter used to specify the UDP port number; the UDP port is used to detect failure when exchanging heartbeat messages. The default is 59901.

If a firewall exists in the service environment, the firewall must be configured to allow the configured port to pass through it.

ha_ping_hosts

A parameter used to specify the host which verifies whether or not a failover occurs due to unstable network when a failover has started in a slave node. The default is NULL.

Configuring this parameter can prevent failovers from occurring due to network instability. You can specify multiple hosts by using a colon (:).

ha_copy_sync_mode

A parameter used to specify the mode of storing the transaction log copy. The default is SYNC.

The value can be one of the followings: SYNC, SEMISYNC, or ASYNC. The number of values must be the same as the number of nodes specified in ha_node_list. They must be ordered by the specified value. You can specify multiple nodes by using a colon (:)

For more information, see Multiplexing Logs.

ha_copy_log_base

A parameter used to specify the location of storing the transaction log copy. The default is $CUBRID_DATABASES.

For more information, see Multiplexing Logs.

ha_db_list

A parameter used to specify the name of the database that will run in CUBRID HA mode. The default is NULL. You can specify multiple databases by using a comma (,).

ha_apply_max_mem_size

A parameter to used to specify the value of maximum memory that the replication log reflection process of CUBRID HA can use. The default is 500.

Example

The following is an example of configuring cubrid_ha.conf:

[common]

ha_node_list=foo@apple:banana

ha_db_list=testdb

ha_copy_sync_mode=sync:semisync

ha_apply_max_mem_size=1000