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.
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
$
- 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 details 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.