ApsaraDB for OceanBase:Synchronize shadow tables

Background information

The shadow table synchronization feature of OceanBase Developer Center (ODC) allows you to automatically create a shadow table in the current database based on the schema of the source table. The shadow table name is the combination of the source table name and a prefix or suffix. This feature applies to scenarios like end-to-end stress testing.

Create a shadow table synchronization task

Assume that you want to create a shadow table named employee_t in the odc_test database under the mysql410 data source.

1. On the Ticket tab in the SQL development window, choose Synchronize Shadow Table > Create Shadow Table Synchronization Project.

2. On the Create Shadow Table Synchronization Project panel, specify the following information.

   1. Select a synchronization object.

      Parameter	Description
      Database	The database to which the shadow table to be created belongs. You can view the name of the current data source.
      Synchronization Range	The table to be synchronized. Partial Tables: Shadow tables will be created in the current database for the selected tables. You can also check the Select All box on the left of the search box to select all source tables. All Tables: Shadow tables will be created in the current database for all tables in the source database.
      Name of Shadow Table	The name of the shadow table, in the format of prefix+ source table name or source table name +suffix. You can use a custom prefix or suffix.
      Synchronization Objects	The source tables to be synchronized as shadow tables. You must specify this field when Synchronization Range is set to Partial Tables.

   2. Click Next to analyze the structure of the shadow table.

      Parameter	Description
      Synchronized Tables	The Synchronized Tables tab displays the source table name, shadow table name, and analysis result. You can click View to view the source table schema, shadow table schema, and schema change SQL statement, or click Skip, indicating that this shadow table is not synchronized.
      Unsynchronized Tables	The Unsynchronized Tables tab displays the source table name, shadow table name, and analysis result. You can click Undo Skip to synchronize this shadow table. Note A skipped table will be displayed on the Unsynchronized Tables tab. If a shadow table with the same name and the same schema as the source table already exists, schema synchronization will be skipped.
      SQL Preview	The SQL statement for schema synchronization.
      Task Settings	Options of Execution Mode include: Execute Immediately: The synchronization task is executed immediately. Execute On Schedule: The synchronization task is executed on schedule. Options of Task Error Handling Method include: Abort Task: If an error occurs during the execution of the synchronization task, the subsequent SQL scripts are interrupted and no longer executed. Ignore Error and Continue: If an error occurs during the execution of the synchronization task, the SQL script with the error is skipped, but subsequent SQL scripts will be executed.
      Description	The business background of the project, such as the change purpose and expected goal.

3. After you specify the preceding information, click Submit in the lower-right corner of the panel.

4. After a task is generated, the Tasks panel appears. In the Task panel, you can view the approval status and information about the task.

View shadow table synchronization tasks

Task information

1. In the shadow table synchronization list on the Tasks page, click View in the Actions column.

2. In the Task Details panel, click the Task Information tab to view the basic information and settings of the task.

3. In the Task Details panel, click Initiate Again in the lower-right corner to initiate the task again.

Task process

1. In the Task Details panel, click the Task Process tab to view Initiated Task Status,Approval Status, Execution Status, and Completion Result.

2. You can click Initiate Again in the lower-right corner of the panel to initiate the task again.

Task logs

1. In the Task Details panel, click the Task Logs tab and view all logs and alert logs of the task.

   Parameter	Description
   All Logs	Displays the complete information of all task logs, including INFO, ERROR, and WARN logs. You can click Search, Download, or Copy to search for, download, or copy all logs.
   Alert Logs	Displays the ERROR and WARN logs of the task. When a task fails, you can view the error message in the alert logs. You can click Search, Download, or Copy to search for, download, or copy alert logs.

2. You can click Initiate Again to initiate the task again.

References

• Users and roles

• Automatic authorization

• Project collaboration management

• Risk levels, risk identification rules, and approval processes

• SQL check specifications

• SQL window specification

• Database change management

• Lock-free schema changes

• Schema comparison

• Message notification management