Help Center/ Data Replication Service/ User Guide (Kuala Lumpur Region)/ FAQs/ Real-Time Synchronization/ Can Online DDL Tools Be Used for Real-time Synchronization?

Updated on 2022-08-16 GMT+08:00

View PDF

Can Online DDL Tools Be Used for Real-time Synchronization?

During table-level incremental synchronization from MySQL to MySQL, you can use Online DDL tools to add or delete columns. Pay attention to the following when using Online DDL:

The DRS synchronization mechanism conflicts with the tool. Do not select Incremental DDLs when selecting synchronization objects on the Set Synchronization Task page.
Before using Online DDL tools to add columns, perform the corresponding operations in the destination database and then in the source database.
When using Online DDL tools to delete columns, perform the corresponding operation in the source database and then in the destination database.

Common online DDL tools:

pt-online-schema-change
gh-ost

Parent topic: Real-Time Synchronization

Previous topic: Can DRS Sync Tables of Different Schemas to the Same Schema?

Next topic: Which MySQL DDL Statements Can Be Directly Executed in GaussDB(DWS)?

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.