cubrid_broker.conf

The cubrid_broker.conf file that has general information on configuring CUBRID broker is located in the $CUBRID/conf directory. This section explains the parameters of cubrid_broker.conf that are used by CUBRID HA.

ACCESS_MODE

A parameter used to specify the mode of a broker. The default is RW.

Its value can be one of the followings: RW (Read Write), RO (Read Only), SO (Slave Only), or PHRO (Preferred Host Read Only). For details, see Broker mode.

PREFERRED_HOSTS

A parameter used only when the ACCESS_MODE parameter value is PHRO. The default value is NULL.

You can specify multiple nodes by using a colon (:). It tries to connect to host in the following order: host specified in the PREFERRED_HOSTS parameter first and host specified in $CUBRID_DATABASES/databases.txt  second.

Example

The following example shows how to configure cubrid_broker.conf.

[%testdb_broker]

SERVICE                 =ON

BROKER_PORT             =33000

MIN_NUM_APPL_SERVER     =5

MAX_NUM_APPL_SERVER     =40

APPL_SERVER_SHM_ID      =33000

LOG_DIR                 =log/broker/sql_log

ERROR_LOG_DIR           =log/broker/error_log

SQL_LOG                 =ON

TIME_TO_KILL            =120

SESSION_TIMEOUT         =300

KEEP_CONNECTION         =AUTO

ACCESS_MODE             =PHRO

PREFERRED_HOSTS         =nodeA:nodeB:nodeC