Data Management (DMS) introduces a new feature to change schemas without locking tables. This feature prevents your business from being blocked by table locks due to schema changes. This feature also minimizes the latency that is caused by the online DDL feature of MySQL during primary-secondary replication. This feature creates one or more temporary tables that use the new schema, replicates full data and incremental binary logs to the temporary tables, and then stores the temporary tables as permanent tables.
Prerequisites
Procedure
In the following example, the feature changes the data type of the long_text_a
column in the big_table
table from varchar(1024)
to text(1024)
.
- Submit a ticket as a regular user.
- Approve and handle the ticket as a DMS administrator.