Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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

Constraints

Supported Platforms

Currently, CUBRID HA is supported by Linux only. All nodes within CUBRID HA groups must be configured on the same platforms.

Table Primary Key

CUBRID HA synchronizes data among nodes with the following method (as known as transaction log shipping): It replicates the primary key-based replication logs generated from the server of a master node to a slave node and then reflects the replication logs to the slave node.

If data of the specific table within CUBRID HA groups is not synchronized, you should check whether the appropriate primary key has specified for the table.

Table Trigger and Java Stored Procedure

Using triggers and java stored procedures in CUBRID HA can cause duplicate executions because triggers and java stored procedures executed in a master node will be executed in a slave node again. This may cause data inconsistency among nodes within CUBRID HA groups.

It is not recommended to use triggers and java stored procedures in CUBRID HA.

Method and CUBRID Manager

CUBRID HA synchronizes data among nodes within CUBRID HA groups based on replication logs. Therefore, using method that does not generate replication logs or configuring NOT NULL through CUBRID Manager may cause data inconsistency among nodes within CUBRID HA groups.

Therefore, method cannot be used and menus CUBRID Manager (except for the query processor) in CUBRID HA configuration.

In CUBRID HA configuration, the use of method is not recommended, and the use of CUBRID Manager’s menus except for the query processor are not recommended.

UPDATE STATISTICS statement  

UPDATE STATISTICS statement which update the statistical informations is not replicated to the slave node.

Standalone Mode

The replication logs are not generated as for tasks performed in standalone mode. For this reason, data inconsistency among nodes within CUBRID HA groups may occur when performing tasks in standalone mode.

Serial Cache

To enhance performance, a serial cache does not access Heap and does not generate replication logs when retrieving or updating serial information. Therefore, if you use a serial cache, the current values of serial caches will be inconsistent among the nodes within CUBRID HA groups.

cubrid backupdb -r

This command is used to back up a specified database. If the -r option is used, logs that are not required for recovery will be deleted. This deletion may result in data inconsistency among nodes within CUBRID HA groups. Therefore, you must not use the -r option.

INCR/DECR Functions

If you use INCR/DECR (click counter functions) in a slave node of HA configuration, an error is returned.

LOB (BLOB/CLOB) Type

In a CUBRID HA environment, the meta data (Locator) of a LOB column is replicated and LOB data is not replicated. Therefore, if storage of a LOB type is located on the local machine, no tasks corresponding to columns are allowed in slave nodes or master nodes after failover.