Logical database change management

Background information

ODC V4.3.2 and later supports data changes in logical databases. You can use logical database change tasks to run time-consuming SQL statements and prevent execution timeouts.

Notes

• Only OceanBase MySQL and MySQL data sources are supported.

• Only Data Definition Language (DDL) changes are supported.

• The SQL check specifications and SQL window specifications in ODC security rules are not supported.

Create a logical database change task

In a Project or Ticket, click Logical Database Change.

• Create a logical database change from a project.

• Create a logical database change from a ticket.

On the Create Logical Database Change page, enter the following information.

Item	Description
Logical database	Select the logical database to change.
SQL content	Select Enter SQL. This is the default method. Enter the SQL script directly in the editor. Note Enter a maximum of 500,000 characters. If you exceed the limit, upload an attachment. Click the Convert IN Value button to convert batch-copied data into the in('A','B') format. The column value delimiter is a line feed. The row value separator is a space or a tab character.
Separator	The Delimiter separator is supported.
Task settings	Select Execute Immediately/Scheduled Execution to set the task execution method.
Execution timeout	In the Execution timeout text box, enter a number to specify the statement execution timeout in hours. The default timeout is 48 hours, and the maximum is 480 hours.
Description	In the Task description text box, enter a description of up to 200 characters. This is optional.

1. Click Create to create the logical database change task.

2. After the task is created, you can view its information in the list under Tickets > Logical Database Change.

View a logical database change task

Task information

1. In the logical database change list under Tickets, click View in the Actions column.

2. In the task details panel that appears, click the Task Information tab to view information such as the logical database, task type, threat level, and SQL content.

3. Click Run Again to restart the logical database change task.

Task flow

In the task details panel, click the Task Flow 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 for the task.

Item	Description
All logs	All logs displays all log information for the task, including INFO, ERROR, and WARN logs. Click the Find, Download, and Copy buttons to search for, download, or copy all log information.
Alert log	The alert log displays only the ERROR and WARN logs for the task. When a task fails, view the error message in the alert log. Click the Find, Download, and Copy buttons to search for, download, or copy the alert log information.

References

• SQL editing and execution

• PL compilation and debugging

• Project collaboration management

• Database change management

• Multi-database change management

• Lock-free schema evolution