VReplication: When will the VReplication entry in mysql.vreplication table be deleted? #354

newborn22 · 2023-11-08T07:07:00Z

newborn22
Nov 8, 2023
Collaborator

VReplication: When will the VReplication entry in mysql.vreplication table be deleted?

When one vreplication workflow of onlineDDL finished, it will still keep its entry in mysql.vreplication table, just like this:

*************************** 2. row ***************************
                   id: 2
             workflow: 16a61c86_7d60_11ee_9efc_da3720e3a51d
               source: keyspace:"testdb" shard:"0" filter:{rules:{match:"_ff44cd38_7d5c_11ee_9efc_da3720e3a51d_20231107190127_vrepl" filter:"select `id` as `id`, `name` as `name`, `age` as `age`, `email` as `email` from `test_table`" source_unique_key_columns:"id" target_unique_key_columns:"id" source_unique_key_target_columns:"id"}}
                  pos: MySQL56/706c0824-7d5c-11ee-8906-645ea9381de9:1-3633
             stop_pos: NULL
              max_tps: 9223372036854775807
  max_replication_lag: 9223372036854775807
                 cell: 
         tablet_types: in_order:REPLICA,PRIMARY
         time_updated: 1699356222
transaction_timestamp: 1699356221
                state: Stopped
   state_before_pause: NULL
              message: stopped for online DDL cutover
              db_name: testdb
          rows_copied: 0
                 tags: 
       time_heartbeat: 0
        workflow_type: 5
       time_throttled: 0
  component_throttled: 
    workflow_sub_type: 0
 defer_secondary_keys: 0

Answered by newborn22

Nov 8, 2023

The vreplication entry will be deleted in the func (e *Executor) deleteVReplicationEntry(ctx context.Context, tableSchema string, uuid string) error. There are two places where this function is called:

In the gcArtifacts phase of the onlineDDL sheduler: after onlineDDL completes, if the current time has passed a certain time from the completion time (24 hours in the code), the corresponding entry will be deleted.
When the user cancels the onlineDDL task, or the onlineDDL task is detected as stale in the reviewStaleMigrations phase of the onlineDDL sheduler, the function terminateMigration will be called, and this function will call deleteEntry.

View full answer

newborn22 · 2023-11-08T07:19:35Z

newborn22
Nov 8, 2023
Collaborator Author

The vreplication entry will be deleted in the func (e *Executor) deleteVReplicationEntry(ctx context.Context, tableSchema string, uuid string) error. There are two places where this function is called:

In the gcArtifacts phase of the onlineDDL sheduler: after onlineDDL completes, if the current time has passed a certain time from the completion time (24 hours in the code), the corresponding entry will be deleted.
When the user cancels the onlineDDL task, or the onlineDDL task is detected as stale in the reviewStaleMigrations phase of the onlineDDL sheduler, the function terminateMigration will be called, and this function will call deleteEntry.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

VReplication: When will the VReplication entry in mysql.vreplication table be deleted? #354

{{title}}

Replies: 1 comment

{{title}}

Select a reply

VReplication: When will the VReplication entry in mysql.vreplication table be deleted? #354

newborn22 Nov 8, 2023 Collaborator

Replies: 1 comment

newborn22 Nov 8, 2023 Collaborator Author

newborn22
Nov 8, 2023
Collaborator

newborn22
Nov 8, 2023
Collaborator Author