Database Workshop
Database Workshop
Document
- Documentation
Database WorkshopUser guide (RDS for MySQL)Data managementTicket listData cleanup and archiving ticketManaging a data cleanup and archiving ticket
Copy page
Download PDFData cleanup and archiving ticket
Managing a data cleanup and archiving ticket
Copy pageDownload PDFManaging a data cleanup and archiving ticket
This topic explains how to manage submitted tickets on the Database Workshop (DBW) console, including viewing, modifying, and approving tickets.
Prerequisites
A data cleanup and archiving ticket has been created. For detailed steps, refer to Creating a data cleanup and archiving ticket.
Precautions
- View a ticket: DBW administrators can view all tickets, while DBW normal users can only view tickets they created or are assigned as approvers.
- Approve a ticket: Approvers for ticket approval are set in the approval workflow when instance security control is enabled. For detailed steps, refer to Enabling security control.
- Manually execute a ticket: If the ticket is created with the Manually executed after approval option, its status will change to Waiting for execution once approved. The creator must manually execute the ticket to complete the SQL statement execution.
Procedure
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, under the all, Created by me, and Pending my approval tabs, filter and view the target ticket information as needed.
- Database type is RDS for MySQL.
- Ticket type is Data cleanup and archiving.
- On the ticket list page, you can view all ticket information, including Ticket number, Ticket title, Database instance, Database name, Table name, Is deleted data backed up?, Database type, Ticket status, Execution method, Creator, Current handler, Creation time, Last operation time, Number of rows deleted, Ticket remarks, and Actions.
tip
- You can filter tickets for RDS for MySQL by database type.
- The ticket status includes Not started, Pre-checking, Pre-check failed, Approving, Cancelled, Rejected, Waiting for execution, Executing, Execution failed, and Executed successfully. You can filter tickets by ticket status.
- When a ticket fails to pass pre-check, you can hover the cursor over the status of the target ticket to view the error information.
- Click the target ticket ID to view the basic information, configuration details, operation logs, and ticket workflow.
- On the ticket details page, click Approve ticket in the workflow to view the current approval progress, including approver and approval time.
- On the ticket details page, click Execute ticket in the workflow to view the current execution progress, including Task ID, Execution status, Start Time, Completion time, Database user, Execute SQL statements, Number of rows deleted, backup address, and Actions, etc. Click View log in the actions column to view detailed execution log of the current scheduling task. Click Download in the backup address column to download data backed up in TOS (data backup configured in the ticket). If the ticket is in the approval state and has not yet entered the execution phase, you can not view its execution status.
If the data backup function is configured when creating a data cleanup and archiving ticket, and the data is backed up to the built-in TOS. After the ticket task is executed, the backup data is stored in CSV format and retained for 30 days; it will be automatically deleted after expiration. If necessary, download the backup data to your local device in time. The method to download backup data is as follows.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, go to the All, Created by me tab and filter to view the target ticket information as needed.
- Database type is RDS for MySQL.
- Ticket type is Data cleanup and archiving.
- Click the target ticket number. On the Ticket Details page, in the ticket processing flow, click Execute ticket.
- Click Download in the backup address column to save the data backed up in TOS to the local PC.
tip
To re-import the downloaded backup data into the database, refer to Creating a data import ticket for RDS for MySQL.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, go to the Pending my approval tab and filter the target ticket information as needed.
- Database type is RDS for MySQL.
- Ticket type is Data cleanup and archiving.
- On the Pending my approval sub-tab, find the target ticket and approve the ticket as required.
- Pass: To allow the operations specified in the ticket, click Pass in the Actions column.
- Refuse: To deny the operations specified in the ticket, click Refuse in the Actions column.
- After the approval workflow is complete, the ticket status varies depending on the approval method:
- Automatic execution after approval: After the ticket is approved, it will automatically proceed to execution.
- Scheduled execution after approval: After the ticket is approved, its status changes to Waiting for execution. The ticket will only be executed once its scheduled start time is reached.
You can terminate the data cleanup and archiving task when archiving historical data is no longer needed.
tip
Only the ticket creator can terminate a ticket task.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, go to the Created by me tab and filter to view the target ticket information as needed.
- Database type is RDS for MySQL.
- Ticket type is Data cleanup and archiving.
- On the Created by me subtab, select ... in the Actions column of the target ticket. > Terminate.
- In the Confirm termination dialog box, click OK.
Last updated: 2026.08.04 10:53:13
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
