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 copy and monitor the status of replication logs.

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

The following example shows how to check log information (Active Info.) of the master node, the status information of log copy (Copied Active Info.) of the slave node, and the applylogdb info (Applied Info.) of the slave node by executing applyinfo in the slave node.

  • Applied Info.: Shows the status information after the slave node applies the replication log.
  • Copied Active Info.: Shows the status information after the slave node copies the replication log.
  • Active Info.: Shows the status information after the master node records the transaction log.

[nodeB] $ cubrid applyinfo -L /home/cubrid/DB/testdb_nodeA -r nodeA -a testdb

 

 *** 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                        : testdb

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

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

EOF LSA                        : 1913 | 2976

Append LSA                     : 1913 | 2976

HA server state                : active

You can see the delay in applying from the master node to the slave node by checking the difference between the EOF LSA of Active Info. and the EOF LSA of the Copies Active Applied Info.

You can see the delay in applying the log copied to the slave node to the slave database by checking the difference between the EOF LSA of the Copied Active Info. and the committed page of the Applied Info.

You can check delay time of copying from mast node to slave node with EOF LSA in Active Info. and EOF LSA of Applied Info.

You can check delay time of applying to the slave node which was copied from the master node with EOF LSA of Copied Active Info. and Committed page of Applied Info.

The items shown by each status are as follows:

  • Applied Info.
    • Committed page: The information of committed pageid and offset of a transaction reflected last through replication log reflection process. The difference between this value and the EOF LSA of "Copied Active Info. represents the amount of replication delay.
    • 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 transactions 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: Name of a target database in which the replication log copy process copies logs
    • DB creation time: The creation time of a database copied through replication log copy process
    • EOF LSA: Information of pageid and offset copied at the last time on the target node by the replication log copy process. There will be a delay in copying logs as much as difference with the EOF LSA value of "Active Info." and with the Append LSA value of "Copied Active Info."
    • Append LSA: Information of pageid and offset written at the last time on the disk by the replication log copy process. This value can be less than or equal to EOF LSA. There will be a delay in copying logs 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 logs from. For details on status, see Server.
  • Active Info.
    • DB name: Name of a database of which node was 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 transaction log of a node that is configured in the -r option. There will be a delay in copying logs as much as difference between the EOF LSA value of "Copied Active Info." and this value.
    • Append LSA: Information of pageid and offset written at the last time on the disk by the database of which node was configured in the -r option.
    • HA server state: The server status of a database server of which node was configured in the -r option.