This topic describes the FAQ about the data tracking feature provided by Data Management Service (DMS).
(1) You can search for log entries online instead of manually downloading binary logs.
(2) You can search for log entries about data insertion, update, or deletion instead of manually analyzing binary logs.
(3) You can perform rollback for each operation record instead of manually writing rollback statements.
Search: You can search for log entries based on specific search criteria.
View Details: You can view log details such as rollback statements.
Next: You can find more log entries that meet the specified search criteria.
- ApsaraDB for MySQL
- PolarDB for MySQL
You can use data tracking to download and analyze MySQL binary logs, without manual operations.
Binary logs stored in Object Storage Service (OSS). Relational Database Service (RDS) regularly transfers the backup of binary logs to OSS.
Binary logs stored on database servers.
(1) Search for log entries about data insertion, update, and deletion in all databases.
(2) Search for log entries about data insertion, update, and deletion in a specified table in a specified database.
(3) Search for log entries about update operations on the record whose record ID is 12345678, for example, update dmstest.test1 set money=0 where id=12345678.
(4) Search for log entries about update operations on records whose original value of the num column is 123, for example, update dmstest.test1 set num=rand() where num=123.
(5) Search for log entries about update operations on records whose value of the num column is changed to 0, for example, update dmstest.test1 set num=0.
Data tracking works as follows:
(1) Data tracking reads binary logs based on the time period you specified.
(2) Data tracking analyzes and displays data that meets specified search criteria on the first page.
(3) When you click Next, more data that meets the specified search criteria appears on the next page.
(1) Make sure you specify the correct time period.
(2) Make sure you specify the correct search criteria.
(3) Click Next to find more data that meets the specified search criteria.
(4) Update operations that fail to update data are not recorded in binary logs. Data tracking cannot find these operations.