Logical database change management

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.

Considerations

• Only OceanBase MySQL and MySQL data sources are supported.

• Only DDL changes are supported.

• SQL check specifications and SQL window specifications in the ODC security guidelines are not supported.

Create a logical database change task

1. 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.

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

   Information Item	Description
   Logical Database	Select the logical database to be changed.
   SQL Content	Select SQL Entry: SQL entry is the default method, allowing you to 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	Enter a number in the Execution Timeout text box to specify the statement execution timeout, 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.

3. Click Create to complete the creation of the logical database change.

4. 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

1. In the logical database change list on the Ticket page, click the View button under the Actions column.

2. In the pop-up task details panel, click the Basic Information tab to view information such as the target logical database, task type, risk level, and SQL content.

3. 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.

References

• SQL editing and execution

• PL compilation and debugging

• Command-line window

• Result editing and exporting

• Execution analysis

• Generate test data

• Partition management

• Shadow table synchronization

• Lock-free schema change