Updated on 2022-09-21 GMT+08:00

Viewing Subscription Information

DRS allows you to view incremental subscription information (excluding view and stored procedure data) in a specified time range on the DRS console.

This section describes how to view the subscription information online and the meaning of each field in the data record.

Prerequisites

  • You have logged in to the DRS console.
  • You have created a subscription task.

Procedure

  1. On the Data Subscription Management page, click the target subscription task.
  2. On the displayed page, click the Subscription Information tab.

    By default, incremental subscription information of the last 5 minutes is displayed in the current list. To view the subscription information in a specified time range, you can select the time range in the upper right corner on the page, and the time range must be within the subscription task time range.
    Figure 1 Viewing subscription information

    The data format of subscription information is the internal data format of the DRS service. Table 1 describes the fields in the data record.

    Table 1 Field description

    Field

    Description

    Service ID

    IP address and port of the RDS instance

    Database Name

    Name of the database where the statement is executed

    Table Name

    Name of the table where the statement is executed

    Statement Type

    The statement types are as follows: update, delete, insert, replace, begin, commit, ddl, and dml.

    Binlog Position

    Location of the change record in the binlog file. The format is binlog_file_offset@binlog_file_id. binlog_file_id indicates the suffix of the binlog file name, and binlog_file_offset indicates the offset of the binlog record in the binlog file.

    Time

    Time when the change record is written to the binlog file

    To view details about a specified table in a specified database, click View Subscription Data.

    Figure 2 Field description

    For details, see Table 2.

    Table 2 Field description

    Field

    Description

    Field Name

    Name of each field corresponding to the change record

    Type

    Data type of each field corresponding to the change record

    Code

    Character set code corresponding to the change record

    Original Value

    The value of each field before the change There is no original value for the insert operation.

    New Value

    The value of each field after the change There is no original value for the delete operation.

    • The update operation has both the original and new values.
    • If the operation type is DDL, only the field name, type, code, original value, and new value are available.