cubrid applyinfo

Description

This utility is used to monitor the replication status of CUBRID HA.

Syntax

cubrid applyinfo [option] <database-name>

Options

Option

Default

Description

-r

none

Configures the name of a target node in which transaction logs are copied. Using this option will output the information of active logs (Active Info.) of a target node.

-a

 

Outputs the information of replication reflection of a node executing cubrid applyinfo. The -L option is required to use this option.

-L

none

Configures the location of transaction logs copied from the other node. Using this option will output the information of transaction logs copied (Copied Active Info.) from the other node.

-p

0

Outputs the information of a specific page in the copied logs. This is available only when the -L option is enabled.

-v

 

Outputs detailed information.

Example

$ cubrid applyinfo -L /home/cubrid/DB/tdb01_masterdb.cub -r master_node_name -a tdb01

 

 *** Applied Info. ***

Committed page                 : 1913 | 2904

Insert count                   : 645

Update count                   : 0

Delete count                   : 0

Schema count                   : 60

Commit count                   : 15

Fail count                     : 0

 

 *** Copied Active Info. ***

DB name                        : testdb01

DB creation time               : 11:28:00.000 AM 12/17/2010  (1292552880)

EOF LSA                        : 1913 | 2976

Append LSA                     : 1913 | 2976

HA server state                : active

 

 ***  Active Info. ***

DB name                        : testdb01

DB creation time               : 11:28:00.000 AM 12/17/2010  (1292552880)

EOF LSA                        : 1913 | 2976

Append LSA                     : 1913 | 2976

HA server state                : active

$