Creating Databases and Configuring Servers

Creating Databases

Create databases to be included in CUBRID HA at each node of the CUBRID HA in the same manner. Modify the options for database creation as needed.

[nodeA]$ cd $CUBRID_DATABASES

[nodeA]$ mkdir testdb

[nodeA]$ cd testdb

[nodeA]$ mkdir log

[nodeA]$ cubrid createdb -L ./log testdb

Creating database with 512.0M size.

CUBRID 9.0

[nodeA]$

cubrid.conf

Ensure ha_mode of $CUBRID/conf/cubrid.conf in every CUBRID HA node has the same value. Especially, take caution when configuring the log_max_archives and force_remove_log_archives parameters (logging parameters) and the ha_mode parameter (HA parameter).

# Service parameters

[service]

service=server,broker,manager

# Common section

[common]

service=server,broker,manager

# Server parameters

server=testdb

data_buffer_size=512M

log_buffer_size=4M

sort_buffer_size=2M

max_clients=100

cubrid_port_id=1523

db_volume_size=512M

log_volume_size=512M

# Adds when configuring HA (Logging parameters)

log_max_archives=100

force_remove_log_archives=no

# Adds when configuring HA (HA mode)

ha_mode=on

Configuring cubrid_ha.conf

Ensure ha_port_id, ha_node_list, ha_db_list of $CUBRID/conf/cubrid_ha.conf in every CUBRID HA node has the same value.

[common]

ha_port_id=59901

ha_node_list=cubrid@nodeA:nodeB

ha_db_list=testdb

ha_copy_sync_mode=sync:sync

ha_apply_max_mem_size=500

databases.txt

Ensure that you must configure the host names (nodeA:nodeB) of master and slave nodes in db-host of $CUBRID_DATABASES/databases.txt; if $CUBRID_DATABASES is not configured, do it in $CUBRID/databases/databases.txt).

#db-name vol-path db-host log-path lob-base-path

testdb /home/cubrid/DB/testdb nodeA:nodeB /home/cubrid/DB/testdb/log file:/home/cubrid/DB/testdb/lob