Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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

cubrid applyinfo

Description

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

Syntax

cubrid applyinfo [option] <database-name>

  • database-name : Specifies the name of a server to monitor. A node name is not included.
Option

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                        : tdb01

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                        : tdb01

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

EOF LSA                        : 1913 | 2976

Append LSA                     : 1913 | 2976

HA server state                : active

$

  • Applied Info.
    • Committed page : The information of committed pageid and offset of a transaction reflected last through replication log reflection process. This information is internally used; which means that replication reflection will be delayed if a big difference exists between the EOF LSA value of "Copied Active Info." and this value.
    • Insert Count : The number of Insert queries reflected through replication log reflection process.
    • Update Count : The number of Update queries reflected through replication log reflection process.
    • Delete Count : The number of Delete queries reflected through replication log reflection process.
    • Schema Count : The number of DDL statements reflected through replication log reflection process.
    • Commit Count : The number of commits reflected through replication log reflection process.
    • Fail Count : The number of DML and DDL statements in which log reflection through replication log reflection process fails.
  • Copied Active Info.
    • DB name : Database name of a database server process to which replication log copy process copies replication logs
    • DB creation time : The creation time of a database copied through replication log copy process
    • EOF LSA : The last information of pageid and offset of a database server process replication log copied through replication log copy process. There will be a delay in replication log copy process as much as difference with the EOF LSA value of "Active Info." and with the Append LSA value of "Copied Active Info."
    • Append LSA : The last information of pageid and offset of a log received from the database server process through replication log copy process. This value can be less than or equal to EOF LSA. There will be a delay in replication log copy process as much as difference between the EOF LSA value of "Copied Active Info." and this value.
    • HA server state : Status of a database server process which replication log copy process receives replication logs from. For more information on status, see Server.
  • Active Info.
    • DB name : Database name of a database server process of a node that is configured in the -r option.
    • DB creation time : Database creation time of a node that is configured in the -r option.
    • EOF LSA : The last information of pageid and offset of a database server process replication log of a node that is configured in the -r option. There will be a delay in replication log copy process as much as difference between the EOF LSA value of "Copied Active Info." and this value.
    • Append LSA : The last information of pageid and offset of a replication log which is written in a database server process of a node that is configured in the -r option.
    • HA server state : Status of a database server process of a node that is configured in the -r option.