Logical database change management

Background information

OceanBase Developer Center (ODC) V4.3.2 and later allow you to change the data in your logical database. You can create a logical database change task to run time-consuming SQL statements to avoid an execution timeout.

Considerations

• Only MySQL and OceanBase MySQL data sources are supported.

• Only data definition language (DDL) changes are supported.

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

Create a logical database change task

1. On the Projects or Tickets tab, click Apply for Database Permissions to apply for table permissions.

   • Create a logical database change task on the Projects tab.

     

   • Create a logical database change task on the Tickets tab.

     

2. In the Create Logical Database Change panel, specify the following information:

   

   Parameter	Description
   Logical Database	Select the logical database to which the database change task belongs.
   SQL Content	Select SQL Entry , which is the default way to specify SQL content. You can directly write the SQL script in the editing area. Note The maximum size of the SQL statements that can be entered in the SQL window is limited to 500,000 characters. If the SQL script to be executed has more than 500,000 characters, you can directly upload the script file. You can click IN Value Conversion to convert the batch copied data into the in('A','B') format. Column values are separated with line breaks. Row values are separated with spaces or tabs.
   Delimiter	The delimiters are supported.
   Task Settings	Select Execute Now or Scheduled Execution .
   Execution Timeout	Specify the timeout period for statement execution, in hours. The default value is 48 hours. The maximum value is 480 hours.
   Description	Optional. Additional information about the task, which cannot exceed 200 characters in length.

3. Click Create .

4. After the logical database change task is generated, choose Tickets > Logical Database Change and view the task information in the task list.

   

View a logical database change task

Task information

1. In the logical database change task list on the Tickets tab shown in the preceding figure, click View in the Actions column of the target task.

2. In the task details panel, click the Task Information tab to view the information about the task, including the logical database, type, risk level, and SQL content.

3. Click Initiate Again in the lower-right corner of the panel to initiate the logical database change task again.

Task process

In the Task Details panel, click the Task Process tab and 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 and 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

• Perform PL compilation and debugging

• Use the command-line window

• Edit and export the result set of an SQL statement

• Perform analysis

• Generate test data

• Manage partitioning plans

• Synchronize shadow tables

• Lock-free schema changes