Background information
ODC V4.3.2 and later versions support making changes to data in logical databases. You can run time-consuming SQL statements through a logical database change task to avoid statement execution timeout.
Note
- If you do not have permissions for a logical database, you can apply for logical database permissions via Apply for Database Permissions in the project/ticket section.
- For information on the relationship between logical and physical databases, see Logical Database Management.
Considerations
Only OceanBase MySQL and MySQL data sources are supported.
Only DDL changes are supported.
SQL check specifications and SQL window specifications in ODC security specifications are not supported.
Create a logical database change task
In Project/Ticket, click Logical Database Change.
Create a logical database change from the project entry.
Create a logical database change from the ticket entry.
On the Create Logical Database Change page, enter the following information.
Information ItemDescriptionLogical Database Select the logical database to be changed. SQL Content Select SQL Entry: SQL entry is the default method, where you can directly enter the SQL script in the editing area. Note
- In SQL entry, a maximum of 500,000 characters are allowed. If exceeded, you can upload an attachment.
- Click IN Value Conversion to convert batch copied data into the in('A','B') format.
- Column value separator is a line break character.
- Row value separator is a space or TAB character.
Separator Supports Delimiter as the separator. Task Settings Select Immediate Execution / Scheduled Execution to set the task execution method. Execution Timeout Period Enter a number in the Execution Timeout text box to specify the statement execution timeout period, in hours (default timeout is 48 hours, with a maximum of no more than 480 hours). Description You can enter up to 200 characters of descriptive information in the Ticket Description text box. This item is optional. Click Create to complete the creation of the logical database change.
After the task is generated, you can view its information in the Ticket > Logical Database Change list.
View a logical database change task
Task information
In the logical database change list under Ticket, click the View button next to the action column for the task you want to view.
In the task details panel that appears, click the Basic Information tab to view information such as the logical database, task type, risk level, and SQL content.
Click Initiate Again to re-initiate the logical database change task.
Task process
In the task details panel, click the Task Process tab to view information such as the task initiation status, approval status, execution status, and execution result.
Execution records
In the task details panel, click the Execution Records tab to view the task execution status.
Task logs
In the task details panel, click the Task Logs tab to view all logs and alert logs of the task.
Information Item |
Description |
|---|---|
| All Logs | All logs display comprehensive information such as INFO, ERROR, and WARN logs for the task. You can click the Find, Download, and Copy buttons to search for information, download, or copy all log information. |
| Alert Log | The alert log displays only the ERROR and WARN logs of a task. When a task fails, you can view the error information in the alert log. You can click the Find, Download, and Copy buttons to search for information, download, or copy the alert log. |