Table Rollback
1. Function Description
A table rollback is a rollback at the table level. Service must be stopped for full-table rollback at a specified table. First, stop both the primary/standby processes of the Tcapsvr storage process where the table is rolled back, then fetch the cold backup files and Ulog files of the table, construct data locally in Tcapsvr, and finally replace the constructed data files and start the Tcapsvr storage process.
2. Application Scenarios
Table rollback needs to stop the service, which interrupts TcaplusDB read and write operations. It is generally applicable to full-table rollback. At present, the online usage rate of TcaplusDB is not high, because the service should be stopped.
3. Instructions
Prepare the set, app, game zones (optional), tables (optional), and the rollback time.
Find the application entry of the record rollback on the TcaplusDB Console.
After the application, go to the rollback transaction page according to the pop-up guide, and click the transaction execution after confirmation.
The first step in the transaction is to stop the storage process where the tables are located, download cold backup files and Ulog files where the tables are located to the storage machine to construct the data. After the data construction is complete, replace the constructed data file to the data directory, and then start the storage process where the tables are located.
4. Notations
Limitations on use:
If the table to be rolled back has been changed or deleted between the backup time point and the rollback time point, the table cannot be rolled back.
If the table to be rolled back has been expanded and shrunk between the backup time point and the rollback time point, the table cannot be rolled back.