Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 | 

HA-Related System Catalog

db_ha_apply_info

A table that saves the progress status every time the applylogdb utility applies replication logs. This table is updated at every point the applylogdb utility commits, and the acculmative count of operations are stored in the *_counter column. The meaning of each column is as follows:

Column Name

Column Type

Meaning

db_name

VARCHAR(255)

Name of the database saved in the log

db_creation_time

DATETIME

Creation time of the source database for the log to be applied

copied_log_path

VARCHAR(4096)

Path to the log file to be applied

page_id

INTEGER

Page of the replication log committed in the slave database

offset

INTEGER

Offset of the replication log committed in the slave database

log_record_time

DATETIME

Timestamp included in replication log committed in the slave database, i.e. the creation time of the log

last_access_time

DATETIME

Time when applylogdb was committed in the slave database

insert_counter

BIGINT

Number of times that applylogdb was inserted

update_counter

BIGINT

Number of times that applylogdb was updated

delete_counter

BIGINT

Number of times that applylogdb was deleted

schema_counter

BIGINT

Number of times that applylogdb changed the schema

commit_counter

BIGINT

Number of times that applylogdb was committed

fail_counter

BIGINT

Number of times that applylogdb failed to be inserted/updated/deleted/committed and to change the schema

required_page_id

INTEGER

Minimum pageid that applylogdb can read

start_time

DATETIME

Time when the applylogdb process accessed the slave database

status

INTEGER

Progress status (0: IDLE, 1: BUSY)