tencent cloud

Data Transfer Service

Release Notes and Announcements
Release Notes
Announcements
Product Introduction
Overview
Data Migration
Data Sync
Data Subscription (Kafka Edition)
Strengths
Supported Regions
Specification Description
Purchase Guide
Billing Overview
Configuration Change Description
Payment Overdue
Refund
Getting Started
Data Migration Guide
Data Sync Guide
Data Subscription Guide (Kafka Edition)
Preparations
Business Evaluation
Network Preparation
Adding DTS IP Addresses to the Allowlist of the Corresponding Databases
DTS Service Permission Preparation
Database and Permission Preparation
Configuring Binlog in Self-Built MySQL
Data Migration
Databases Supported by Data Migration
Cross-Account TencentDB Instance Migration
Migration to MySQL Series
Migrating to PostgreSQL
Migrating to MongoDB
Migrating to SQL Server
Migrating to Tencent Cloud Distributed Cache
Task Management
Data Sync
Databases Supported by Data Sync
Cross-Account TencentDB Instance Sync
Sync to MySQL series
Synchronize to PostgreSQL
Synchronization to MongoDB
Synchronize to Kafka
Task Management
Data Subscription (Kafka Edition)
Databases Supported by Data Subscription
MySQL series Data Subscription
Data Subscription for TDSQL PostgreSQL
MongoDB Data Subscription
Task Management
Consumption Management
Fix for Verification Failure
Check Item Overview
Cutover Description
Monitoring and Alarms
Supported Monitoring Indicators
Supported Events
Configuring Metric Alarms and Event Alarms via the Console
Configuring Indicator Monitoring and Event Alarm by APIs
Ops Management
Configuring Maintenance Time
Task Status Change Description
Practical Tutorial
Synchronizing Local Database to the Cloud
Creating Two-Way Sync Data Structure
Creating Many-to-One Sync Data Structure
Creating Multi-Site Active-Active IDC Architecture
Selecting Data Sync Conflict Resolution Policy
Using CLB as Proxy for Cross-Account Database Migration
Migrating Self-Built Databases to Tencent Cloud Databases via CCN
Best Practices for DTS Performance Tuning
FAQs
Data Migration
Data Sync
FAQs for Data Subscription Kafka Edition
Regular Expressions for Subscription
Error Handling
Common Errors
Failed Connectivity Test
Failed or Alarmed Check Item
Inability to Select Subnet During CCN Access
Slow or Stuck Migration
Data Sync Delay
High Data Subscription Delay
Data Consumption Exception
API Documentation
History
Introduction
API Category
Making API Requests
(NewDTS) Data Migration APIs
Data Sync APIs
Data Consistency Check APIs
(NewDTS) Data Subscription APIs
Data Types
Error Codes
DTS API 2018-03-30
Service Agreement
Service Level Agreements
DocumentaçãoData Transfer ServiceData MigrationMigration to MySQL SeriesAdvanced Operations for MySQL Series MigrationMigrating Online DDL Temp Table

Migrating Online DDL Temp Table

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2024-07-08 19:41:52

Overview

When performing an online DDL operation on tables in the source database with the gh-ost or pt-online-schema-change (pt-osc) tool, you need to migrate the temp tables generated by online DDL changes to the target database. DTS allows you to associate the temp table names of the object table in advance when selecting the migration objects, so that the object table can be migrated together with the temp tables subsequently generated by the source database.
When you perform an online DDL operation on the table table name with the gh-ost tool, DTS supports migrating temp tables _table name_ghc, _table name_gho, and _table name_del to the target database.
When you perform an online DDL operation on the table table name with the pt-osc tool, DTS supports migrating temp tables _table name_new and _table name_old to the target database.

Scope of application

Currently, temp tables can be migrated between MySQL, MariaDB, Percona, and TDSQL-C for MySQL.

Restrictions

The table mapping (table renaming) feature conflicts with the temp table migration feature (online DDL), and only one of them can be enabled at any time.

Directions

1. Log in to the DTS console, select Data Migration on the left sidebar, and create a migration task.
2. In the Set migration options and select migration objects step, select Sync Online DDL Temp Table and Online DDL Tool
If you select gh-ost, DTS will migrate the temp tables (_table name_ghc, _table name_gho, and _table name_del) generated by the gh-ost tool to the target database.
If you select pt-osc, DTS will migrate the temp tables (_table name_new and _table name_old) generated by the pt-osc tool to the target database.
Note:
In Selected Object on the right, you need to selected the specified table object, and then the button Sync Online DDL Temp Table will be displayed below. If you select the databases or tables, the button cannot be displayed.
If the source database already contains tables with the same names as temp tables _table name_new and _table name_old, pt-osc will generate other temp tables with different names, which DTS cannot migrate. In this case, if you just choose the table itself as the Migration Object, data in temp tables created by online DDL updates can’t be migrated to the target database. Instead, you must select the entire database or instance where the table to be migrated resides.

Anterior: Database/Table RenamingPróximo: Database Connection Check

Ajuda e Suporte

Esta página foi útil?

comentários