Adding or Deleting Tables in the Blacklist or Whitelist

Constraints

• Up to 50 tables can be selected in the whitelist or blacklist at a time. You are advised to select as small a number of tables as is appropriate based on workloads.
• The blacklist and whitelist cannot be switched.
• The blacklist or whitelist cannot be empty.
• You are advised to add or delete tables in the blacklist or whitelist during off-peak hours. If you perform this operation during peak hours, modifications cannot be updated. You can click Stop to stop the operation and reduce the number of tables to be added or deleted, or perform the operation during off-peak hours.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
4. On the Instances page, locate a GaussDB(for MySQL) instance and click the instance name to go to the Basic Information page.
5. In the navigation pane on the left, choose HTAP Analysis.
6. Click the name of an HTAP instance to go to the Basic Information page.
7. In the navigation pane on the left, choose Data Synchronization, locate the synchronization task, and click View in the Operation column.
   Figure 1 Viewing a synchronization task
   

8. Click Edit next to Blacklist and Whitelist.
   Figure 2 Editing blacklist or whitelist
   

9. Add or delete tables in the whitelist or blacklist as required.
   Figure 3 Adding or deleting tables in the whitelist or blacklist
   
   • To add a table to the whitelist or blacklist, select the table in the Available Tables list on the left.
   • To delete a table from the whitelist or blacklist, locate the table in the Selected Tables list and click in the Operation column. To delete multiple tables, select the desired tables and click Delete All in the upper right corner.
   • To quickly find the desired tables to be added, enter multiple tables in the search box and click . Use commas (,), spaces (), and line breaks (\n) to separate multiple tables. The tables that you entered are selected by default in the Available Tables list and displayed in the Selected Tables list.

10. After the tables in blacklist and whitelist are modified, click Modify Synch Task at the lower right corner of the page.
11. Return to the data synchronization page and view the status of the task.
    • When a table to be added contains a large amount of data, the message "Modification phase: Preparing data" is displayed in the Status column.
    • You can click View to view the details about the modification. During the modification, you can click Stop to stop the modification.
    • After the modification is complete, the status of the task becomes available. You can click View to view the modified results.
      Figure 4 Viewing the modified tables in the whitelist or blacklist