We are Migrating the temporal Mysql DB and we have some running workflows in the current DB
We don’t want to loose any running workflows , pls help which table from the bellow tables we need to port.
As we are now migrating all services from a staging server where all services were deployed to a new ECS cluster where services are deployed in ECS instances separately and that will be pointing to new migrated DB for which I need to know which tables from staging server DB I need to port to new DB
Temporal
having tables bellow
±--------------------------+
| Tables_in_temporal |
±--------------------------+
| activity_info_maps |
| buffered_events |
| child_execution_info_maps |
| cluster_membership |
| cluster_metadata |
| cluster_metadata_info |
| current_executions |
| executions |
| history_node |
| history_tree |
| namespace_metadata |
| namespaces |
| queue |
| queue_metadata |
| replication_tasks |
| replication_tasks_dlq |
| request_cancel_info_maps |
| schema_version |
| shards |
| signal_info_maps |
| signals_requested_sets |
| task_queues |
| tasks |
| timer_info_maps |
| timer_tasks |
| transfer_tasks |
| visibility_tasks |
±--------------------------+
And temporal_visibility DB having bellow tables
±------------------------------+
| Tables_in_temporal_visibility |
±------------------------------+
| executions_visibility |
| schema_version |
±------------------------------+
Help is much appriciated as we are now going live.