In apsaradb RDS for MySQL, you can use SQL Explorer, binlogs, or DTS to view incremental data. The following are details of different viewing methods.

SQL Explorer

SQL Explorer

Binary log (binlog)

Binlogs can accurately record all add, delete, and modify operations in the database, allowing you to accurately restore incremental data. The Binlog for RDS is stored in the instance first. The system regularly uploads the Binlog to OSS for backup, and then clears the Binlog in the instance. as described in the following sections.

  1. Log on to the ApsaraDB for RDS console .
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Click the ID of the target instance.
  4. In the left-side navigation pane, choose Backup and restoration > log backup. To locate a Binlog file, click download, and then click copy public network address.
  5. In the Linux where MySQL is installed, run the following command to download the Binlog file:
    wget -c '[$Binlog_Address]'
    Note [$Binlog_Address] is the external download URL of Binlog files.
  6. Run the following command to convert the file to a readable format:
    mysqlbinlog --no-defaults -v --base64-output=decode-rows [$Binlog_File] > binlog.sql
    Note [$Binlog_File] is the name of a Binlog file.
  7. In the current directory of log files, run the following command to view the log:
    more binlog.sql
    Note You can also export log files to locate problems.

DTS Data Subscription

The data subscription function of DTS can push incremental data in RDS to users in real time. The user can customize incremental data, and can choose the schema of some tables or the incremental data to subscribe to. For more information about change tracking, see  Change tracking (new).