Data Replication Service
Data Replication Service
All results for "
" in this service
All results for "
" in this service
What's New
Service Overview
Infographics
DRS Overview
Five Major Functions
Data Comparison
User Permission Migration
What Is DRS?
Supported Databases
Advantages
Functions and Features
Real-Time Migration
Backup Migration
Real-Time Synchronization
Data Subscription
Real-Time Disaster Recovery
Workload Replay
Specification Description
Real-Time Synchronization
Real-Time Disaster Recovery
Product Architecture and Function Principles
Mapping Data Types
MySQL->PostgreSQL
MySQL->GaussDB
MySQL->Oracle
MySQL->CSS/ES
Oracle->MySQL
Oracle->GaussDB(for MySQL)
Oracle->GaussDB
Oracle->DDM
Oracle->GaussDB(DWS)
Oracle->PostgreSQL
GaussDB(for MySQL)->Oracle
GaussDB(for MySQL)->CSS/ES
GaussDB->MySQL
GaussDB->GaussDB(DWS)
GaussDB->Oracle
DB2 for LUW->GaussDB
DB2 for LUW->GaussDB(DWS)
PostgreSQL->GaussDB
PostgreSQL->GaussDB(DWS)
TiDB->GaussDB(for MySQL)
Microsoft SQL Server->GaussDB(DWS)
Microsoft SQL Server->GaussDB
Microsoft SQL Server->MySQL
Microsoft SQL Server->GaussDB(for MySQL)
Microsoft SQL Server->PostgreSQL
Billing
Billing Mode
Pay-Per-Use
Yearly/Monthly
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Renewal
Expiration and Overdue Payment
Security
Shared Responsibilities
Identity Authentication and Access Control
Data Protection
Audit and Logs
Risk Monitoring
Fault Recovery
Certificates
Compliance Description
Permissions Management
Agency Management
Constraints
Constraints on Migration Tasks
Constraints on Synchronization Tasks
Constraints on DR Tasks
Accessing DRS
Related Services
Basic Concepts
Billing
Billing Overview
Billing Modes
Overview
Yearly/Monthly Billing
Pay-per-Use Billing
Preferential Policies
Billed Items
Billing Examples
Billing Mode Changes
Overview
Pay-per-Use to Yearly/Monthly
Renewing Subscriptions
Overview
Manually Renewing a DRS Task
Auto-renewing a DRS Task
Bills
Arrears
Billing Termination
Cost Management
Cost Composition
Cost Allocation
Cost Analysis
Cost Optimization
Preparations
Overview
Registering a Huawei ID and Enabling Huawei Cloud Services
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
From On-premises Databases to Huawei Cloud
Accessing Huawei Cloud over a Public Network
Accessing Huawei Cloud over a VPN
From Other Cloud Databases to Huawei Cloud
Accessing Huawei Cloud over a Public Network
Accessing Huawei Cloud over a VPN
From Huawei Cloud to Huawei Cloud
Accessing Huawei Cloud Through a VPC (Same Region and Same VPC)
Accessing Huawei Cloud Through a VPC (Same Region and Different VPCs)
Accessing Huawei Cloud over a Public Network (Different Regions)
Accessing Huawei Cloud Through a VPN (Different Regions)
From ECS-Hosted Databases on Huawei Cloud to Huawei Cloud
Accessing Huawei Cloud Through a VPC (Same Region and Same VPC)
Accessing Huawei Cloud Through a VPC (Same Region and Different VPCs)
Accessing Huawei Cloud over a Public Network (Different Regions)
Accessing Huawei Cloud Through a VPN (Different Regions)
Getting Started with Common Practices
Getting Started
Creating a Real-Time Migration Task
Creating a Real-Time Synchronization Task
Creating a Real-Time DR Task
Creating a Workload Replay Task
Common Tasks
Real-Time Migration
Migration Overview
To the Cloud
From MySQL to MySQL
From MySQL to DDM
From MySQL to GaussDB(for MySQL)
From MySQL Schema and Logic Table to DDM
From MongoDB to DDS
From MongoDB to GeminiDB Mongo
From Redis to GeminiDB Redis
From Redis Cluster to GeminiDB Redis
Out of the Cloud
From MySQL to MySQL
From DDS to MongoDB
From GeminiDB Redis to Redis
From GeminiDB Redis to Redis Cluster
Task Management
Creating a Migration Task
Querying the Migration Progress
Viewing Migration Logs
Data Comparison (Comparing Migration Items)
Managing Objects
Migrating Accounts
Parameters for Comparison
Viewing Migration Objects
Task Life Cycle
Viewing Task Details
Modifying Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Migration Task
Resuming a Migration Task
Disabling Read-Only of the Destination Database
Resetting a Migration Task
Pausing a Migration Task
Cloning a Migration Task
Stopping a Migration Task
Deleting a Migration Task
Importing Tasks in Batches
Task Statuses
Tag Management
Connection Diagnosis
Interconnecting with CTS
Key Operations Recorded by CTS
Viewing Traces
Interconnecting with Cloud Eye
Supported Metrics
Configuring Alarm Rules
Viewing Monitoring Metrics
Interconnecting with LTS
Log Reporting
Viewing and Downloading Logs
Appendix
General Usage Suggestions
DRS Pre-Check Items
Backup Migration
Migration Overview
Creating an RDS Backup Migration Task
Creating a Backup Using OBS Buckets
Task Management
Viewing Task Details
Modifying Task Information
Viewing Migration Logs
Deleting a Migration Task
Task Statuses
Interconnecting with LTS
Log Reporting
Viewing and Downloading Logs
Tag Management
Real-Time Synchronization
Synchronization Overview
Data Synchronization Topologies
To the Cloud
From MySQL to MySQL
From MySQL to PostgreSQL
From MySQL to GaussDB Distributed
From MySQL to GaussDB Primary/Standby
From MySQL to GaussDB(DWS)
From MySQL to GaussDB(for MySQL)
From MySQL to MariaDB
From PostgreSQL to PostgreSQL
From PostgreSQL to GaussDB(DWS)
From PostgreSQL to GaussDB Primary/Standby
From PostgreSQL to GaussDB Distributed
From Oracle to MySQL
From Oracle to GaussDB(for MySQL)
From Oracle to GaussDB Primary/Standby
From Oracle to GaussDB Distributed
From Oracle to DDM
From Oracle to GaussDB(DWS)
From Oracle to PostgreSQL
From DDM to MySQL
From DDM to GaussDB(DWS)
From DDM to DDM
From DB2 for LUW to GaussDB Primary/Standby
From DB2 for LUW to GaussDB Distributed
From DB2 for LUW to GaussDB(DWS)
From TiDB to GaussDB(for MySQL)
From Microsoft SQL Server to GaussDB(DWS)
From Microsoft SQL Server to GaussDB Primary/Standby
From Microsoft SQL Server to GaussDB Distributed
From Microsoft SQL Server to Microsoft SQL Server
From Microsoft SQL Server to MySQL
From Microsoft SQL Server to GaussDB(for MySQL)
From Microsoft SQL Server to PostgreSQL
From MongoDB to DDS
From MariaDB to MariaDB
From MariaDB to MySQL
From MariaDB to GaussDB(for MySQL)
From GaussDB(for MySQL) to GaussDB(for MySQL)
From Cassandra to GeminiDB Cassandra
From Dynamo to GeminiDB Dynamo
From AWS DocumentDB to DDS
Out of the Cloud
From MySQL to MySQL
From MySQL to Kafka
From MySQL to CSS/ES
From MySQL to Oracle
From MySQL to MariaDB
From DDM to MySQL
From DDM to Oracle
From DDM to Kafka
From DDS to MongoDB
From DDS to Kafka
From PostgreSQL to PostgreSQL
From PostgreSQL to Kafka
From GaussDB Distributed to MySQL
From GaussDB Distributed to Oracle
From GaussDB Distributed to GaussDB(DWS)
From GaussDB Distributed to Kafka
From GaussDB Distributed to GaussDB Distributed
From GaussDB Distributed to GaussDB Primary/Standby
From GaussDB Primary/Standby to MySQL
From GaussDB Primary/Standby to Oracle
From GaussDB Primary/Standby to GaussDB(DWS)
From GaussDB Primary/Standby to Kafka
From GaussDB Primary/Standby to GaussDB Distributed
From GaussDB Primary/Standby to GaussDB Primary/Standby
From GaussDB(for MySQL) to MySQL
From GaussDB(for MySQL) to GaussDB(DWS)
From GaussDB(for MySQL) to Kafka
From GaussDB(for MySQL) to CSS/ES
From GaussDB(for MySQL) to Oracle
From MariaDB to MariaDB
From Microsoft SQL Server to Kafka
Between Self-built Databases
From MySQL to Kafka
From MySQL to CSS/ES
From MySQL to GaussDB Primary/Standby
From MySQL to GaussDB Distributed
From Oracle to Kafka
From Oracle to GaussDB Primary/Standby
From Oracle to GaussDB Distributed
From PostgreSQL to Kafka
From GaussDB Primary/Standby to MySQL
From GaussDB Primary/Standby to Oracle
From GaussDB Primary/Standby to Kafka
From GaussDB Primary/Standby to GaussDB Distributed
From GaussDB Primary/Standby to GaussDB Primary/Standby
From GaussDB Distributed to MySQL
From GaussDB Distributed to Oracle
From GaussDB Distributed to Kafka
From GaussDB Distributed to GaussDB Distributed
From GaussDB Distributed to GaussDB Primary/Standby
From DB2 for LUW to GaussDB Primary/Standby
From DB2 for LUW to GaussDB Distributed
From Microsoft SQL Server to Kafka
Two-Way Synchronization
Two-Way Synchronization from MySQL to MySQL
Task Management
Creating a Synchronization Task
Querying the Synchronization Progress
Viewing Synchronization Logs
Data Comparison (Comparing Synchronization Items)
Managing Objects
Editing Synchronization Objects
Importing Synchronization Objects
Changing Object Names (Mapping Object Names)
Viewing Synchronization Mapping Information
Processing Data
Managing Parameters
Changing Task Parameters
Viewing Parameter Change History
Task Life Cycle
Viewing Task Details
Modifying Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Changing the Synchronization Mode
Editing a Synchronization Task
Resuming a Synchronization Task
Skipping Data and Resuming a Synchronization Task
Pausing a Synchronization Task
Resetting a Synchronization Task
Resetting Synchronization Position
Restarting a Synchronization Task
Skipping DDL Statements
Performing a Switchover for a Dual-AZ Task
Exchanging the Direction for a Two-Way Synchronization Task
Changing a Single-AZ Task to a Dual-AZ Task
Cloning a Synchronization Task
Changing Specifications
Unsubscribing from a Yearly/Monthly Task
Stopping a Synchronization Task
Deleting a Synchronization Task
Importing Tasks in Batches
Filtering Large Fields
Task Statuses
Tag Management
Connection Diagnosis
Viewing Abnormal Data
Interconnecting with CTS
Key Operations Recorded by CTS
Viewing Traces
Interconnecting with Cloud Eye
Supported Metrics
Configuring Alarm Rules
Viewing Monitoring Metrics
Interconnecting with LTS
Log Reporting
Viewing and Downloading Logs
Operation Reference in Synchronization Scenarios
Kafka Message Format
Kafka Authentication
Synchronizing Sequence Values for a Synchronization Task with GaussDB Distributed Serving as the Source Database
Forcibly Stopping Synchronization of GaussDB Distributed
Forcibly Stopping Synchronization of GaussDB Primary/Standby
Forcibly Stopping Synchronization of PostgreSQL
Creating Event Triggers and Functions to Implement Incremental DDL Synchronization for PostgreSQL
Appendix
General Usage Suggestions
DRS Pre-Check Items
Data Subscription
Creating a Data Subscription Task
SDK APIs
Introduction to SDK APIs
SDK Usage Instructions
SDK Download Address
Task Management
Viewing Task Details
Modifying Task Information
Editing a Subscription Task
Viewing Subscription Information
Modifying Consumption Start Time
Resuming a Subscription Task
Resetting a Subscription Task
Deleting a Subscription Task
Task Statuses
Tag Management
Real-Time Disaster Recovery
DR Overview
DR Scenarios
From MySQL to MySQL (Single-Active DR)
From MySQL to GaussDB(for MySQL) (Single-Active DR)
From DDM to DDM (Single-Active DR)
From GaussDB(for MySQL) to GaussDB(for MySQL) (Single-Active DR)
From MySQL to MySQL (Dual-Active DR)
From GaussDB(for MySQL) to GaussDB(for MySQL) (Dual-Active DR)
Task Management
Creating a DR Task
Querying the DR Progress
Viewing DR Logs
Data Comparison (Comparing DR Items)
Task Life Cycle
Viewing DR Data
Modifying Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Disabling or Enabling Read-Only
Editing a DR Task
Resuming a DR Task
Pausing a DR Task
Retrying a DR Task
Resetting a DR Task
Viewing DR Metrics
Performing a Primary/Standby Switchover for DR Tasks
Exchanging the DR Direction
Changing Specifications
Unsubscribing from a Yearly/Monthly Task
Stopping a DR Task
Deleting a DR Task
Task Statuses
Connection Information Management
Creating a Database Connection
Editing a Database Connection
Deleting a Database Connection
Tag Management
Connection Diagnosis
Interconnecting with CTS
Key Operations Recorded by CTS
Viewing Traces
Interconnecting with Cloud Eye
Supported Metrics
Configuring Alarm Rules
Viewing Monitoring Metrics
Interconnecting with LTS
Log Reporting
Viewing and Downloading Logs
Workload Replay
Replay Overview
Current Cloud
From MySQL to MySQL
From MySQL to GaussDB(for MySQL)
From GaussDB(for MySQL) to GaussDB(for MySQL)
To the cloud
From MySQL to MySQL
From MySQL to GaussDB(for MySQL)
Task Management
Creating a Workload Replay Task
Querying the Replay Progress
Viewing the Replay Reporting
Viewing Replay Logs
Task Life Cycle
Viewing Task Details
Modifying Task Information
Editing a Replay Task
Pausing a Replay Task
Resuming a Replay Task
Resetting a Replay Task
Stopping a Replay Task
Deleting a Replay Task
Task Statuses
Tag Management
Connection Diagnosis
Interconnecting with LTS
Log Reporting
Viewing and Downloading Logs
Audit Log Format
Best Practices
Best Practices Summary
Real-Time Migration
Migrating MySQL Databases from Other Clouds to RDS for MySQL
Overview
Resource Planning
Operation Process
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Configuring a MySQL Instance on Another Cloud
Cloud Migration
Creating a DRS Migration Task
Checking Migration Results
From Other Cloud MySQL to GaussDB(for MySQL)
Overview
Resource Planning
Operation Process
Creating a VPC and Security Group
Creating a GaussDB(for MySQL) Instance
Configuring a MySQL Instance on Other Clouds
Creating a DRS Migration Task
Checking Migration Results
From Other Cloud MongoDB to DDS
From ECS-hosted MySQL to RDS for MySQL
Overview
Resource Planning
Operation Process
Cloud Migration
Creating an RDS for MySQL Instance
Creating a Migration Task
Confirming Migration Results
From ECS-hosted MySQL to GaussDB(for MySQL)
Overview
Prerequisites
Resource Planning
Operation Guide
Procedure
ECS-hosted MySQL Server
Creating a VPC and Security Group
Creating an ECS (MySQL Server)
Installing a MySQL Database (Community Edition)
Creating an ECS and Installing the MySQL Client on It
Testing the ECS-hosted MySQL Performance
Cloud Migration
Creating a GaussDB(for MySQL) Instance
Creating a DRS Migration Task
Checking the Migration Results
From ECS-hosted MongoDB to DDS
From On-Premises MySQL to RDS for MySQL
From On-Premises MongoDB to DDS
From RDS for MySQL to DDM
Overview
Resource Planning
Operation Process
Preparing for the Source RDS for MySQL Instance
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Preparing for the Destination DDM Instance
Creating a VPC and Security Group
Creating a DDM Instance
Creating an RDS for MySQL Instance
Creating a Schema and Associating It with the RDS for MySQL Instance
Creating a DDM Account
Creating Table Structures in the Destination Database
Creating and Configuring a VPN
Creating a VPN for the Source Database
Creating a VPN for the Destination Database
Modifying the VPN Configuration for the Source Database
Creating a DRS Migration Task
Confirming Migration Results
From MySQL Schema and Logic Table to DDM
Overview
Resource Planning
Process
Procedure
Constructing Data Before the Migration
Preparing for the Destination DDM Instance
Creating a VPC and Security Group
Creating a DDM Instance
Creating an RDS for MySQL Instance
Creating a DDM Account
Creating a Schema and Associating It with the RDS for MySQL Instance
Creating Table Structures in the Destination Database
Migrating Databases
Verifying Data After the Migration
Backup Migration
Migrating Microsoft SQL Server Backup Data to RDS SQL Server DB Instance
Overview
Migration Preparations
Exporting Backup Files
Uploading Backup Files
Scenario 1: Full Backup Migration
Scenario 2: Full+Incremental Backup Migration
Manual Configuration
Real-Time Synchronization
From Other Cloud PostgreSQL to RDS for PostgreSQL
From ECS-hosted PostgreSQL to RDS for PostgreSQL
From On-Premises PostgreSQL to RDS for PostgreSQL
From On-premises MySQL to GaussDB Distributed
From On-premises Oracle to GaussDB Distributed
Purpose
Resource Planning
Operation Process
Creating a VPC and Security Group
Creating a GaussDB Instance
Generating Test Data
Synchronizing Databases
Verifying Data
From On-premises Oracle to GaussDB Primary/Standby
Purpose
Resource Planning
Operation Process
Preparations
Creating a VPC and Security Group
Creating a GaussDB Instance
Creating a UGO Task
Creating a Database Evaluation Project
Creating an Object Migration Project
Creating a DRS Task
Starting Synchronization
UGO Schema Migration Phase 1: Tables, Primary Keys, Unique Keys/Indexes
DRS Synchronization Phase 1: Full Synchronization
UGO Schema Migration Phase 2: Common Indexes
DRS Synchronization Phase 2: Incremental Synchronization
UGO Schema Migration Phase 3: Triggers, Events, Tasks, Foreign Keys, and Sequences
From On-Premises Oracle to DDM
Overview
Resource Planning
Operation Process
Preparing for the Source Oracle Database
Preparing for the Destination DDM Instance
Creating a VPC and Security Group
Creating a DDM Instance
Creating an RDS for MySQL Instance
Creating a Schema and Associating It with the RDS for MySQL Instance
Creating a DDM Account
Creating Table Structures in the Destination Database
Creating a DRS Synchronization Task
Confirming Synchronization Results
From RDS for MySQL to Kafka
Overview
Resource and Cost Planning
Operation Process
Creating a VPC and Security Group
Preparing for Source RDS for MySQL
Creating an RDS for MySQL Instance
Generating Test Data
Preparing for Destination Kafka
Creating a Kafka Instance
Creating a Topic
Creating a DRS Synchronization Task
Confirming the Results
From GaussDB Distributed to Kafka
From GaussDB Primary/Standby to Kafka
Real-Time Disaster Recovery
Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS
Overview
Resource Planning
Operation Process
Configuring an RDS for MySQL Instance in the Production Center
Creating a VPC and Security Group
Creating an EIP
Creating an RDS for MySQL Instance
Configuring an RDS for MySQL Instance in the DR Center
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Configuring Remote Disaster Recovery
Creating a DRS Disaster Recovery Task
Configuring the Disaster Recovery Task
Performing a Primary/Standby Switchover
Security Best Practices
Security White Paper
Security White Paper
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Basic Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Returned Values
Getting Started
Task Creation Process
Task Creation Example
APIs V3.0 (Recommended)
Quotas
Querying Resource Quotas
Public API Management
Querying AZs in Which Flavors Are Not Sold Out
Querying Task Progress in Batches
Real-Time Disaster Recovery
Querying RPO and RTO in Batches
APIs V3.0 (Deprecated)
Public API Management
Creating Tasks in Batches
Testing Connections in Batches
Testing Connections in Batches (Cluster Mode)
Modifying Tasks in Batches
Selecting Database Objects in Batches
Performing a Batch Pre-Check
Querying Pre-check Results in Batches
Setting Flow Control for Tasks
Obtaining Database Parameters in Batches
Modifying Database Parameters
Starting Tasks in Batches
Resuming or Retrying Tasks in Batches
Pausing Tasks in Batches
Stopping or Deleting Tasks in Batches
Changing the Passwords of the Source and Destination Databases in Batches
Setting Definers in Batches
Creating a Comparison Task
Querying Comparison Results
Querying Tasks of a Tenant
Querying Task Details in Batches
Querying Task Statuses in Batches
Configuring Exception Notifications
Querying Available Node Specifications
Querying Data-level Table Comparison Tasks
Creating a Data-level Table Comparison Task
Canceling a Comparison Task
Immediately Starting a Data-level Table Comparison Task
Querying the Row Comparison Overview
Querying Row Comparison Details
Querying the Value Comparison Overview
Querying Value Comparison Details
Querying Value Comparison Differences
Creating an Object-level Comparison Task
Querying the Overview of an Object Comparison Task
Querying Details About an Object Comparison Task
Exporting the Result File of a Comparison Task
Downloading the Result File of a Comparison Task
Real-Time Migration Management
Updating Migrated User Information in Batches
Obtaining Migration Users of the Source Database
Real-Time Synchronization Management
Processing Data in Batches
Configuring Synchronization Policies in Batches
Advanced Settings
Real-Time Disaster Recovery Management
Performing Primary/Standby Switchovers in Batches
Querying DR Monitoring Data
Querying the DR Initialization Progress in Batches
Querying DR Initialization Object Details in Batches
APIs V5.0 (in OBT)
Resource Management
Querying Information about Available Links
Task Management
Creating a Task
Querying Tasks
Updating Details About a Task with a Specified ID
Deleting a Task with a Specified ID
Deleting Tasks in Batches
Cloning a Task
Management of Tasks Created Asynchronously in Batches
Asynchronously Creating Tasks in Batches
Submitting Tasks Created Asynchronously in Batches
Querying the List of Tasks Created Asynchronously in Batches
Querying Details About Tasks Created Asynchronously in Batches with a Specified ID
Updating Details About Tasks Created Asynchronously in Batches with a Specified ID
Downloading the Task Import Template
Importing Tasks in Batches
Database Object Configuration
Submitting the Query of Database Object Information
Submitting the Query of Database Object Information
Obtaining the Result of Querying Database Object Information
Querying Database Object Information
Querying Database Object Information
Downloading the Object Import Template
Uploading the Object Import Template
Querying the Progress of Uploading the Object Import Template
Obtaining the Result of Uploading the Object Import Template
Obtaining the Progress of Saving Objects
Querying the Synchronization Mapping List
Querying Whether Object Selection and Column Mapping Are Supported
Task Details
Querying Task Details
Obtaining Task Pricing Details
Querying the Abnormal Data List
Exporting Task Operation Statistics
Querying Monitoring Data
Querying Incremental Component Details
Task Operations
Performing Operations on a Task with a Specified ID
Collecting Database Position Information
Stopping a Task
Batch Performing Operations on Tasks with Specified IDs
Batch Stopping Tasks
Obtaining the Operations Allowed in a Specified Task
Obtaining the Result for Querying Database Position
Verifying a Task Name
Updating the Start Point of an Incremental Task
Uploading a Driver File
Deleting a Driver File
Synchronizing a Driver File
Querying the Driver File List
Comparison Management
Querying the Comparison Policy
Modifying the Comparison Policy
Querying the Health Comparison List
Querying Details About a Health Comparison Task
Obtaining the Overview of an Object-Level Health Comparison
Querying the Data-Level Streaming Comparison List
Enterprise Projects
Querying Enterprise Projects
Data Processing
Updating Data Processing Rules for a Specified Task
Obtaining the Data Processing Rule Update Result for a Specified Task
Querying Data Processing Rules
Verifying Data Filtering Rules
Obtaining the Data Filtering Verification Result
Collecting Column Information About a Specified Database Table
Obtaining Column Information About a Specified Database Table
Parameter Management
Updating Task Parameters
Querying Task Parameter Configuration List
Querying Task Parameter Change History
Tag Management
Batch Adding or Deleting Tags
Querying Tags of a Specified Project
Querying Tags of a Task
Adding Resource Tags in Batches
Deleting Resource Tags in Batches
Querying the Resource Instance List
Querying the Number of Resource Instances
Querying Tags of a Task
Querying Tags of a Specified Project
Permissions Management
Querying the Permissions of an Agency
Workload Replay
Querying the Workload Replay Result
Application Examples
Scenario 1: Querying Task Statuses in Batches
Scenario 2: Querying Task Details in Batches
Scenario 3: Starting Tasks in Batches
Permissions Policies and Supported Actions
Permissions Policies and Supported Actions
DRS Actions
Appendix
Abnormal Request Results
HTTP Status Codes for General Requests
Error Code
Task Statuses
Obtaining a Project ID
Obtaining an Account ID
Obtaining a Task ID
Engine Types
Status Code
Change History
SDK Reference
SDK Overview
FAQs
Product Consulting
What Are Regions and AZs?
What Is DRS?
Can DRS Migrate RDS Primary/Standby Instances?
What Constraints Does DRS Have for a Source Database?
What Requirements Does DRS Have for a Destination Database?
Does DRS Use Concurrency?
Dose DRS Use Data Compression?
Does DRS Support Migration Between the Public Cloud and the Dedicated Cloud?
What Is the Quota?
Does DRS Support Migration from DB2 for LUW to PostgreSQL?
Can Microsoft SQL Server Database Synchronize Data with Local Databases in Real Time?
Does DRS Support Data Replication in a Specified Time Period?
Does DRS Support Resumable Uploads?
What Is Single-Active/Dual-Active Disaster Recovery?
What Are the Differences Between Real-Time Migration, Real-Time DR, and Real-Time Synchronization?
How Do I Solve the Table Bloat Issue During MySQL Migration?
How Does MySQL Data Synchronization Affect the Source and Destination Databases?
Do I Need to Stop Services Running on the Source Database?
What Is an SMN Topic?
What Are the Differences Between Single-AZ and Dual-AZ DRS Tasks?
Can DRS Migrates Table Structures Only?
How Do I Migrate Accounts in MySQL Migration, Synchronization, and DR Tasks and Can I Change Passwords?
What Factors Affect the DRS Task Speed and How Do I Estimate the Time Required?
Can I Modify Objects in a DRS Task?
Does DRS Support Data Synchronization Between Different Databases of the Same DB Instance?
Which Operations on the Source or Destination Database Affect the DRS Task Status?
What Are Differences Between Data Subscription and Synchronization from MySQL to Kafka?
Why Cannot Standby Read Replicas on Some Other Clouds Be Used as the Source Database?
Does DRS Support Migration of Users Encrypted by the Caching_sha2_password Plugin?
Why Is the Database Disk Usage Inconsistent Before and After Data Migration?
What Is the Serialization Mode of Messages Sent by DRS to Kafka?
Network and Security
What Security Protection Policies Does DRS Have?
What Can I Do If the Network Is Disconnected During the Migration?
Which Database Accounts Are Required During Migration?
How Do I Configure a VPC Security Group to Allow Network Communication?
What Can I Do If the Network Connection Between the Replication Instance and Database Is Abnormal?
How Can the Source and Destination Databases Communicate Across VPCs?
What Is the EIP Bandwidth of DRS?
Does DRS Support Cross-Account Cloud Database Migration?
Permissions Management
How Do I Set an Independent Oracle Account That Has the Least Privilege and Uses DRS?
Which MySQL Permissions Are Required for DRS?
How Can I Import Users and Permissions from the Source to the Destination Database?
Why Cannot Scheduled DRS Tasks Be Started?
What Can I Do If A Message Is Displayed Indicating that the User Has Insufficient Permissions Or Does Not Have the Permission to Create a DRS Task?
Which PostgreSQL Permissions Are Required for DRS?
Real-Time Migration
When Can I Stop a Migration Task?
How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
How Do I Ensure that All Services on the Database Are Stopped?
What Can I Do When Message "can not get agency token" Is Displayed in the Migration Log
What Do I Do If the Maximum Index Length Has Been Reached During Migration from Oracle to MySQL?
Why Is the Collation of Heterogeneous or Oracle Databases Converted to utf8mb4_bin After Those Databases Are Migrated to MySQL?
What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
What Can I Do When OOM Occurs During the Migration of MongoDB Databases?
How Do I Disable the Balancer?
How Do I Export and Import Events and Triggers in Batches?
How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
How Do I Delete Orphaned Documents in MongoDB Sharded Clusters?
What Can I Do If There Is an Extra Backslash (\) After a MySQL Account Is Migrated?
Backup Migration
What Should I Do If the Last Backup File Is Incorrectly Selected in the Backup Migration Scenario?
Manual Configuration
Real-Time Synchronization
Can DRS Sync Tables of Different Schemas to the Same Schema?
Can Online DDL Tools Be Used for Real-time Synchronization?
Does DRS Support Two-Way Real-time Synchronization?
Why Do I Use the SCAN IP Address to Connect to an Oracle RAC Cluster?
How Do I Check Supplemental Logging of the Source Oracle Database?
Suggestions on Synchronizing Data to GaussDB(DWS)
Character Set Compatibility Between Oracle and GaussDB
Garbled Characters or Synchronization Failure Due to Incompatible Character Sets
How Do I Specify the Start Point for DRS Incremental Synchronization?
What Are Syntax Differences Between MySQL or MariaDB Versions?
Configuring Remote Connection to a GaussDB Database
Configuration Description
Configuration Method for a Synchronization Task from GaussDB Primary/Standby
Configuration Method for a Synchronization Task from GaussDB Distributed in Multi-Task Mode
Configuration Method for a Synchronization Task from GaussDB Distributed in Single-Task Mode
Connection and Port Description for Incremental Synchronization from GaussDB
What Should I Do If Data Inconsistency Occurs Due to Inconsistent Primary Keys or Unique Keys of DRS?
Data Subscription
How Long Does It Take for SDK to Consume Database Changes?
Why Data Cannot Be Obtained Using the Subscribed SDK and the Program Is Abnormal?
Real-Time Disaster Recovery
What Are RPO and RTO of DRS Disaster Recovery?
How Do I Select Active Database 1 and 2 for Dual-Active DR?
What Is the Meaning of Forward and Backward Subtasks in Dual-Active Disaster Recovery?
Common Exceptions in Real-Time Disaster Recovery
Is a Primary/Standby Switchover Triggered Automatically or Manually for DR Tasks?
Can Real-Time DR Be Performed for Specified Databases?
How Do I Configure Source Database Information for a DDM DR Task?
Why Does a Real-Time DR Task Not Support Triggers and Events?
Data-Level Comparison
Which of the Following Data Types Are Not Supported By Value Comparison?
What Impact Does a DRS Comparison Task Have on Databases?
How Long Does a DRS Comparison Task Take?
General Operations
What Can I Do When Information Overlaps on the DRS Console?
Is the Destination Instance Set to Read-only or Read/Write?
How Do I Set Global binlog_format=ROW to Take Effect Immediately?
How Do I Set binlog_row_image=FULL to Take Effect Immediately?
How Do I Change the Destination Database Password to Meet the Password Policy?
How Do I Configure the Shard Key for a MongoDB Sharded Cluster?
Does Bandwidth Expansion Affect the Running DRS Tasks?
Why Data in MariaDB and SysDB Cannot Be Migrated or Synchronized?
Constraints and Operation Suggestions on Many-to-One Scenario
Constraints and Operation Suggestions on One-to-Many Scenario
Where Can I View DRS Operation Logs?
Why Is the Language of the Message Sent by DRS Inconsistent with That on the Page?
Why Is a DRS Task Automatically Stopped?
How Can I Export a DRS Task List?
Can a Completed Task Be Restarted?
What Are the Differences Between Resetting a Task and Recreating a Task?
Does DRS Support Backward Migration/Synchronization?
Why Cannot I Select an Existing SMN Topic?
Can I Change an SMN Topic After a Task Is Created?
How Do I Set the Number of Source Shards and Source Database Information When DDM Is the Source Database?
Will Data of DRS Tasks Be Lost After a Primary/Standby Switchover Occurs on the Source MySQL Database?
What Are the Differences Between All, Tables, and Databases During DRS Object Selection?
What Do I Do After Changing the Password of the Source or Destination Database?
How Do I Configure an SMN Topic Policy to Allow DRS to Publish Messages?
What Can I Do If a DRS Task Times Out Due to Too Many Tables?
Can I Change the Source or Destination Database After a DRS Task Is Created?
Billing
Do I Have to Pay For Failed Tasks?
Do I Have to Pay For Paused Tasks?
Will DRS Tasks That Are Not Started Be Billed?
What Will Happen to My Tasks After The Yearly/monthly Subscription Expires?
Will I Be Charged If I Do Not Delete a Task After It Is Completed?
Resource Freezing, Release, Deletion, and Unsubscription
Delay
Why Does the Delay of DR Tasks Increase?
Why Is the Delay High In MongoDB Replication Scenarios?
What Are Possible Causes of Slow Migration or Suspended Progress in Full Phase?
What Are Possible Causes of High Latency in DRS Incremental Phase?
Troubleshooting
Solutions to Failed Check Items
Disk Space
Checking Whether the Destination Database Has Sufficient Storage Space
Checking Whether the Destination Server Has Sufficient Storage Space
Database Parameters
Checking Whether the Source Database Binlog Is Enabled
Checking Whether the Source Database Binlog Is Row-Based
Checking Whether the expire_logs_days Value in the Source Database Is Correct
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether the Source Database server_id Meets the Incremental Migration Requirements
Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
Checking Whether the Source Database Contains Object Names with Non-ASCII Characters
Checking Whether the time_zone Values of the Source and Destination Databases Are the Same
Checking Whether the collation_server Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_UUID Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_ID Values of the Source and Destination Databases Are Different
Checking Whether the Source Database Contains Invalid sql_mode Values
Checking Whether the sql_mode Values of the Source and Destination Databases Are the Same
Checking Whether the sql_mode Value in the Destination Database Is Not no_engine
Checking Whether the innodb_strict_mode Values of the Source and Destination Databases Are the Same
Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured
Checking Whether the WAL_LEVEL Value in the Source Database Is Correct
Checking Whether the MAX_REPLICATION_SLOTS Value in the Source Database Is Correct
Checking Whether the Source Database Is on Standby
Checking Whether the log_slave_updates Value in the Source Database Is Correct
Checking Whether the BLOCK_SIZE Value of the Source Database Is the Same as That of the Destination Database
Checking Whether the binlog_row_image Value is FULL
Checking Whether the Transaction Isolation Levels are Consistent
Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same
Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters
Checking Whether the Source Database Collections Contain More Than 10 Indexes
Checking Whether the Source Database Collections Contain TTL Indexes
Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Checking Whether GTID Is Enabled for the Source Database
Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Checking Whether the Values in the Source Oracle Database Are Out of the Ranges of the MySQL Database
Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Checking Whether the Source Database User Has the Permission to Parse Logs
Checking Whether the ExpireLogsDays Value Is 0
Checking Whether the Source Database Character Set Is Supported
Checking Whether the Length Table and Field Names Is Not Supported
Checking Whether the Databases and Tables Exist
Checking Whether the Supplemental Log Level of the Source Database Meets Requirements
Checking Whether the Length of the Source Database Object Names Exceeds the Limit
Checking Whether session_replication_role of the Destination Database Is correctly Set
Checking the Database Compatibility Type
Checking Whether the Collation of the Destination Database Is Correct
Checking Whether the Index Name Is Supported
Checking Whether Tables Structures Are Consistent
Checking Whether Existing Data Meets the Constraints
Checking the Additional Column of the Destination Database
Checking Whether Implicit Primary Key Check Is Enabled for the Primary and Standby Databases
Checking Whether the Source Table Replication Attribute Is Correct
Checking Whether the Specified Replication Slot Exists in the Source Database
Checking Whether the MongoDB Instance Type Matches the Migration Mode
Checking the Physical Standby Database
Checking Whether the Case Sensitivity of the Destination Database Is Configured
Checking Whether CDC is Enabled for Tables in the Source Database
Checking Whether the CDC Retention Period in the Source Database Is Long Enough
Checking Whether the Source and Destination Databases Have Different Computer Names
Checking Whether the Length of the Source Database Name Exceeds 64
Synchronization Object Name Check
Checking Whether the Source Database Contains Disabled Clustered Indexes
Checking Whether the Source Database Is Empty
Checking Whether the Source Database Uses the Full Recovery Model
Checking the Synchronization Objects
Checking Whether the Source Database Tables Contain Data Types Not Supported for Migration
Checking Whether the SQL Server Agent of the Source Database Is Enabled
Checking Whether the Values of group_concat_max_len Are Consistent
Checking Whether the table structures of the source database are consistent
Checking Whether the Character Sets Are Compatible
Whether There Are XA Transactions That Have Not Been Submitted for a Long Time in the Source Database
Whether the Selected Objects Exist in the Destination Database
Destination Database Same Name Check
Whether the Destination Database User (Schema) and Table Exist
Whether the Maximum Number of Indexed Columns Has Been Reached
Checking the Length of the Index Column in the Source Database
Whether the Table Structures (Including Primary Key Indexes and the Number of Columns) of the Source Oracle Database and Destination Database Middleware Are Aligned
Whether Synchronization Objects Exist in the Destination Database
Whether the Source Database Contains Encrypted Objects
Checking Whether the Source Database Contains Unsupported Table Field Types
Checking Replication Attribute of Primary Key Columns
Whether There Are Tables Containing Fields of the longtext or longblob Type in the Synchronization Object
Checking Database Mapping Objects
Whether the Source Database Is the Standby Database of a GaussDB(for MySQL) Instance
Checking Whether Type Names Mapped to the Destination Database Are Valid
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether Data Replication Is Enabled for the Source Database
Checking Whether the Maximum Sequence Number of the Source Database is Less Than That of the Destination Database
Checking Whether Interval Partitioned Tables Are Included in the Source Database
Oracle Account Check in the Source Database
Checking the Number of DNs in the Source Database
Whether the Selected Objects Exist in the Destination Database
Whether There Are Foreign Keys Containing Unsupported Reference Operations in the Source Database
Whether the Selected Table Contains Delay Constraints
Whether the Source Database Tables Contain Primary Keys
Whether Foreign Keys Are Disabled or Tables to Be Synchronized Have Foreign Keys in the Destination Database
Whether There Are Composite Hash Indexes in the Source Collection
Whether There Are Composite Hash Shard Keys in the Source Collection
Whether the Source Table Structure Contains Newline Characters
Whether There Are Tables Containing Fields of the bytea or text Type in the Synchronization Object
Checking Whether the Source Table Structure Contains Virtual Columns
Whether the max_allowed_packet Value of the Source Database Is Too Small
Whether the Supplemental Log Level in the Source Database Is Correct
Whether Kafka Topics Have Been Created
Whether the Source Database Kernel Encoding Supports Data Replication
block_encryption_mode Consistency Check
Character Type and Sorting Rule Check in the Destination Database
Column Name Check in the Source Database
Whether the Destination Schemas and Table Objects Are Consistent
Source Encrypted Table Check
Checking Whether the Source Table Replication Attribute Is Correct
Partition Table Check on the Source Database
Checking Whether the Source Database Contains Unsupported Generated Columns
Source DB Instance Statuses
Checking Whether the Source DB Instance Is Available
Checking Whether the Source and Destination Databases Are of the Same Type
Checking Whether the ChangeStream API of the source DB instance is available
Destination DB Instance Statuses
Checking Whether the Destination DB Instance Is Available
Checking Whether the Destination Database Is Involved in Another Migration Task
Checking Whether the Destination Database Has a Read Replica
Checking Whether the Destination Database Is Read-Only
Checking Whether the Extensions Are Supported
Checking Whether Destination Contains the Configured Database
Checking Whether the Destination DB Instance Is Available
Checking Whether the Destination Database Is Empty
Database User Permissions
Whether the Source Database User Has Sufficient Permissions
Checking Whether the Destination Database User Has Sufficient Permissions
Checking Whether the Destination Database Account Has Required Permissions to Migrate Definer
Database Versions
Checking Whether the Source Database Version Is Supported
Checking Whether the Destination Database Version Is Supported
Checking Whether the Migration Is from an Earlier Database Version to the Same or a Later Version
Networks
Checking Whether the Source Database Is Connected
Checking Whether the Destination Database Is Connected
Database Objects
Checking Whether the Source Database Contains a MyISAM Table
Checking Whether the Source Database Contains the Functions or Stored Procedures that the Source Database User Is Not Authorized to Migrate
Checking Whether Objects with the Same Names Exist in the Source Database
Whether the Source Database Contains Unlogged Tables
Checking Whether the Names of Views to Be Migrated Are the Same
Checking Whether the _Id Fields in the Collection of the Source Database Have Indexes
Checking Whether the Index Length of the Source Database Exceeds the Limit
Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database
Checking Whether the Database Names Mapped to the Destination DB Instance Contain Unsupported Characters
Checking Whether the Source Database Tables Contain Primary Keys
Checking Whether the Source Database Contains Triggers or Events
Checking Whether the Source Database Referenced Roles Pass the Check
Checking Whether the Source Database Referenced Accounts Pass the Check
Checking Whether the Source Database Contains Schemas or Users Named cdc
Checking Whether Associated Objects Are Selected
Checking Whether the Specified Objects Exist In the Destination Database
Checking Whether the Source Table Contains Column Types that Cannot Be Used as Distribution Keys
Checking Whether the Source Table Contains Unsupported Table Field Types
Database Configuration Items
Checking Whether the Source Database Name Is Valid
Checking Whether the Source Database Table Name Is Valid
Checking Whether the Source Database View Name Is Valid
Checking Whether the Source Database Collection Name Is Valid
Checking Whether the Shard Key Can Be Obtained from the Source Database
Checking Whether the Source Database Schema Name Is Valid
Checking Whether the Maximum Number of Chunks in the Destination Database Is Sufficient
Checking Whether Archive Logs Are Enabled on the Source Oracle Database
Checking Whether Supplemental Logging Is Correctly Enabled on the Source Database
Conflicts
Checking Whether the Names of the Source and Destination Databases Are the Same
Checking Whether the Same View Names Exist in Both the Source and Destination Databases
Checking Whether the Destination Database Contains a Non-Empty Collection with the Same Name As the Source Database
Checking Whether Destination Database Contains the Same Table Names As the Synchronization Objects
Checking Whether the Destination Database Contains Objects with the Same Name As Those in the Source Database
Checking Whether Collections in Both the Source and Destination Databases Are Not Capped
SSL Connections
Checking Whether the SSL Connection Is Correctly Configured
Checking Whether the SSL Connection Is Enabled for the Source Database
Checking Whether the SSL Certificate of the Source Database Exists
Checking Whether the SSL Certificate of the Destination Database Exists
Checking Whether Both the Source and Destination Databases Use SSL
Object Dependencies
Checking Whether the Objects Referenced by Views Are Selected for Migration
Checking Whether Referenced Tables Are Selected for Migration
Source Database Information
Checking Whether the Shards and Mongos Are in the Same Cluster
Checking Whether the Balancers of the Source Database Is Enabled
Checking Whether the Source and Destination Database Types Match
Pre-Check Timeout
Failure Cases
Case Overview
Real-Time Migration from MongoDB to DDS
Full Migration Error: Prematurely reached end of stream
Full Migration Error: not authorized on *** to execute command {***}
Full Migration Error: GC overhead limit exceeded
Full Migration Error: The background process is unavailable. Maybe it has been killed manually or by the operating system. Please restart the task if possible or wait for restarting by itself within 5 minutes."
Full Migration Error: Timed out after 60000 ms while waiting to connect
Full or Incremental Migration Error: Timed out after 60000 ms while waiting to connect
Full or Incremental Migration Error: Invalid BSON field name ***
Incremental Migration Error: Timed out after 60000 ms while waiting for a server that matches com.mongodb.client.internal
Incremental Migration Error: Command failed with error *** (***):***. The full response is {***}"
Real-Time Migration and Synchronization from MySQL to MySQL
Full Phase Error: Table *** doesn't exist
Full Phase Error: The background process is unavailable
Full Phase Error: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Full Phase Error: Error writing file *** (errno: 28 - No space left on device)
Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement
Full Phase Error: The table *** is full
Full Phase Error: Unknown column *** in 'field list'
Full Phase Error: Lock wait timeout exceeded; try restarting transaction
Full Phase Error: Java heap space
Full Phase Error: Table *** already exists
Full Phase Error: temp table: *** not exist
Full Phase Error: failed to create new session
Full Phase Error: load table: *** failed
Full Phase Error: extract table structure failed!
Full Phase Error: read table=*** failed
Full Phase Error: CANNOT UPDATE USER WITH NULL PASSWORD
Full Phase Error: Access denied for user *** to database ***
Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement
Full Phase Error: Temporary file write failure.
Full Phase Error: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
Full Phase Error: Unknown database ***
Full Phase Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Full Phase Error: retry structures failed events and Table *** doesn't exist
Full Phase Error: shard table=*** failed
Full Phase Error: error when split table shard occur!
Full Phase Error: Column name 'AUTO_PK_ROW_ID' is reserved.
Full Phase Error: transfer account failed, can not find password from src DB
Full Phase Error: Failed to add the foreign key constraint '***' to system tables
Full Phase Error: Too many keys specified; max 64 keys allowed
Full Phase Error: Unknown collation: 'utf8mb4_0900_ai_ci'
Full Phase Error: exist some xa transactions for long times, may lack some data for this Job!.
Full Phase Error: Invalid GIS data provided to function st_geometryfromtext'
Full or Incremental Phase Error: Access denied for user ***
Full or Incremental Phase Error: binlog is not existed
Full or Incremental Phase Error: database log download failed
Full or Incremental Phase Error: Can not read response from server
Full or Incremental Phase Error: Communications link failure
Full or Incremental Phase Error: EOF Packet received, master disconnected
Full or Incremental Phase Error: Extract db create sql failed
Full or Incremental Phase Error: load database structure failed in source database
Full or Incremental Phase Error: load table: *** failed
Full or Incremental Phase Error: Reached end of input stream
Full or Incremental Phase Error: Read timed out
Full or Incremental Phase Error: The background process is unavailable
Full or Incremental Phase Error: Duplicate entry *** for key 'PRIMARY'
Full or Incremental Phase Error: cause by: Index: ***, Size: ***
Full or Incremental Phase Error: The offset and file name between src and parser is inconsistency
Full or Incremental Phase Error: core process is not healthy or crashed
Full or Incremental Phase Error: table info of table `***` from metadata miss
Full or Incremental Phase Error: binlog parse fail, data dictionary may be not complete!
Full or Incremental Phase Error: table *** record field size for insert/delete dml
Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: ***
Full or Incremental Phase Error: The binlog fetch connection may be interrupted
Full or Incremental Phase Error: Received error packet: errno - 1047, solstate - HY000 errmsg = Unknown command
Incremental Phase Error: not equals to target db column count
Incremental Phase Error: The MySQL server is running with the --super-read-only option
Incremental Phase Error: you need (at least one of) the SUPER privilege(s) for this operation
Incremental Phase Error: Can't DROP ***; check that column/key exists
Incremental Phase Error: Can't find file: *** (errno: 2 - No such file or directory)
Incremental Phase Error: Data truncation: Data too long for column
Incremental Phase Error: Failed to read file header from
Incremental Phase Error: Lock wait timeout exceeded
Incremental Phase Error: Must seek before attempting to read next event
Incremental Phase Error: Table *** already exists
Incremental Phase Error: Table *** doesn't exist
Incremental Phase Error: Table *** not found in database
Incremental Phase Error: source has more columns than target
Incremental Phase Error: Unknown storage engine
Incremental Phase Error: Unknown table
Incremental Phase Error: You have an error in your SQL syntax
Incremental Phase Error: not illegal for mariaDb gtid position
Incremental Phase Error: without PK execute failed
Incremental Phase Error: Deadlock found when trying to get lock
Incremental Phase Error: current serverUUID not equals to this session
Incremental Phase Error: Slave has more GTIDs than the master has, using the master's SERVER_UUID.
Incremental Phase Error: Operation not allowed when innodb_force_recovery > 0
Incremental Phase Error: filter data in config condition filter error
Real-Time Migration and Synchronization from MySQL to GaussDB(for MySQL)
Full or Incremental Phase Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation
Real-Time Synchronization from MySQL to CSS/ES
Incremental Synchronization Error: write table *** failed: null
Real-Time Synchronization from PostgreSQL to PostgreSQL
Task Startup Error: Initialize logical replication stream failed, the source database may have a long transaction: ****.
Full Synchronization Error: function *** does not exist
Full Synchronization Error: relation *** does not exist
Full Synchronization Error: GC overhead limit exceeded
Full Synchronization Error: Java heap space
Full Synchronization Error: column *** of relation *** does not exist
Full Synchronization Error: column *** does not exist
Full Synchronization Error: type 'hstore' does not exist
Full Synchronization Error: type 'geometry' does not exist
Full Synchronization Error: Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
Full Synchronization Error: invalid locale name
Full Synchronization Error: password must not equal user name
Full Synchronization Error: permission denied for schema ***
Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: ***
Full or Incremental Phase Error: Initialize logical replication stream failed, the source database may have a long transaction
Full or Incremental Phase Error: memory required is *** MB, maintenance_work_mem is *** MB
Full or Incremental Phase Error: temporary file size exceeds temp_file_limit
Incremental Synchronization Error: Table *** not found in target database
Incremental Synchronization Error: remaining connection slots are reserved
Incremental Synchronization Error: PL/pgSQL function *** line *** at SQL statement
Incremental Synchronization Error: The replication slot does not exist and the task is not started for the first time.
Real-Time Synchronization with Oracle Serving as the Source
Full Synchronization Error: has date/datetime: *** which is outside of dest allowed range
Full or Incremental Phase Error: Got minus one from a read call
Incremental Synchronization Error: Source supplemental log level is PK/UI. Missing column data at delete+insert on ***"
Incremental Synchronization Error: timeout when get next file log, maybe has been deleted, please check it.
Incremental Synchronization Error: Failed to construct kafka producer.
Incremental Synchronization Error: Topic *** not present in metadata after 300000 ms
Real-Time Synchronization with GaussDB Serving as the Source
Task Startup Error: Initialize logical replication stream failed, the source database may have a long transaction: ****.
Incremental Synchronization Error: The replication slot does not exist and the task is not started for the first time.
Real-Time DR with MySQL Serving as the Source
DR Error: A dml without pk write target db fail
Backup Migration
Backup Migration Failed Because Backup Files Cannot Be Found
Backup Migration Failed Because a Backup Database Cannot Be Found in the Backup Files
Backup Migration Failed Because the Database with the Same Name Already Exists
Backup Migration Failed Because an Incremental Backup File Is Used
Backup Migration Failed Because an Log Backup File Is Used
Backup Migration Failed Because the Backup File Verification Failed
Backup Migration Failed Because of Insufficient Space
Backup Migration Failed Because Database Names Are Not Specified
Backup Migration Failed Because a Full Backup File Is Used
Backup Migration Failed Because the LSNs of Incremental Backup Files Are Inconsecutive
Backup Migration Failed Because the Number of Databases to Be Restored Exceeds the Destination Database Threshold
Workload Replay
Parsing Failed, and a Message Is Displayed Indicating That the OBS Connection Failed
Data-Level Comparison
Data-Level Comparison Error: service SDV failed! cause by: the size of records in one shard[ *** ] of target database, exceeds the max size 200000
Videos
More Documents
User Guide (Paris Region)
Service Overview
What Is DRS?
Advantages
Functions and Features
Real-Time Migration
Backup Migration
Real-Time Synchronization
Mapping Data Types
Oracle->MySQL
Oracle->PostgreSQL
Basic Concepts
Security Suggestions
Accessing DRS
Instructions
Compliance Description
Related Services
Real-Time Migration
To the Cloud
From MySQL to MySQL
From Oracle to PostgreSQL
From MongoDB to DDS
Out of the Cloud
From MySQL to MySQL
From DDS to MongoDB
Task Management
Creating a Migration Task
Querying the Migration Progress
Viewing Migration Logs
Comparing Migration Items
Managing Objects
Migrating Accounts
Parameters for Comparison
Task Life Cycle
Viewing Task Details
Editing Migration Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Migration Task
Resuming a Migration Task
Resetting a Migration Task
Pausing a Migration Task
Stopping a Migration Task
Deleting a Migration Task
Task Statuses
Tag Management
Interconnecting with Cloud Eye
Supported Metrics
Configuring Alarm Rules
Viewing Monitoring Metrics
Backup Migration
Creating an RDS Backup Migration Task
Creating a Backup Using OBS Buckets
Task Management
Viewing Task Details
Editing Migration Task Information
Viewing Migration Logs
Deleting a Migration Task
Task Statuses
Tag Management
Real-Time Synchronization
Data Synchronization Topologies
To the Cloud
From MySQL to MySQL
From PostgreSQL to PostgreSQL
From Oracle to MySQL
From Oracle to PostgreSQL
Out of the Cloud
From MySQL to MySQL
From MySQL to Kafka
Task Management
Creating a Synchronization Task
Querying the Synchronization Progress
Viewing Synchronization Logs
Comparing Synchronization Items
Managing Objects
Editing Synchronization Objects
Mapping Object Names
Viewing Synchronization Mapping Information
Processing Data
Task Life Cycle
Viewing Task Details
Modifying Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Synchronization Task
Resuming a Synchronization Task
Pausing a Synchronization Task
Resetting a Synchronization Task
Stopping a Synchronization Task
Deleting a Synchronization Task
Task Statuses
Tag Management
Interconnecting with Cloud Eye
Supported Metrics
Configuring Alarm Rules
Viewing Monitoring Metrics
Operation Reference in Synchronization Scenarios
Kafka Message Format
Kafka Authentication
Forcibly Stopping Synchronization of PostgreSQL
Creating Triggers and Functions to Implement Incremental DDL Synchronization for PostgreSQL
FAQs
Product Consulting
What Are Regions and AZs?
What Is DRS?
Can DRS Migrate RDS Primary/Standby Instances?
Does DRS Support Resumable Uploads?
What Are the Differences Between Real-Time Migration and Real-Time Synchronization?
How Do I Solve the Table Bloat Issue?
How Do I Select RDS Read Replicas on the DRS Console?
How Does DRS Affect the Source and Destination Databases?
Can DRS Migrates Table Structures Only?
Network and Security
What Security Protection Policies Does DRS Have?
What Can I Do If the Network Is Disconnected During the Migration?
How Can I Configure a VPC Security Group to Allow Traffic from an EIP?
What Can I Do If the Network Connection Between the Replication Instance and Database Is Abnormal?
Permissions Management
Which MySQL Permissions Are Required for DRS?
How Can I Import Users and Permissions from the Source to the Destination Database?
Real-Time Migration
When Can I Stop a Migration Task?
How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
How Do I Ensure that All Services on the Database Are Stopped?
What Can I Do When Scheduled Task Failed to Start Leaving Message "can not get agency token"
What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
What Can I Do When OOM Occurs During the Migration of MongoDB Databases?
How Do I Disable the Balancer?
How Do I Export and Import Events and Triggers in Batches?
How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
How Do I Delete Orphaned Documents in MongoDB Sharded Clusters?
Backup Migration
What Should I Do If the Last Backup File Is Incorrectly Selected in the Backup Migration Scenario?
Manual Configuration
Real-Time Synchronization
Can DRS Sync Tables of Different Schemas to the Same Schema?
Can Online DDL Tools Be Used for Real-time Synchronization?
Which MySQL DDL Statements Can Be Directly Executed in GaussDB(DWS)?
Why Do I Use the SCAN IP Address to Connect to an Oracle RAC Cluster?
How Do I Check Supplemental Logging of the Source Oracle Database?
Garbled Characters or Synchronization Failure Due to Incompatible Character Sets
Data-Level Comparison
Which of the Following Data Types Are Not Supported By Value Comparison?
What Impact Does a DRS Comparison Task Have on Databases?
How Long Does a DRS Comparison Task Take?
General Operations
What Can I Do When Information Overlaps on the DRS Console?
Is the Destination Instance Set to Read-only or Read/Write?
How Do I Set Global binlog_format=ROW to Take Effect Immediately?
How Do I Set binlog_row_image=FULL to Take Effect Immediately?
How Do I Change the Destination Database Password to Meet the Password Policy?
How Do I Configure the Shard Key for a MongoDB Sharded Cluster?
Does Bandwidth Expansion Affect the Running DRS Tasks?
Why Data in MariaDB and SysDB Cannot Be Migrated?
Constraints and Operation Suggestions on Many-to-One Scenario
Where Can I View DRS Operation Logs?
Can a Completed Task Be Restarted?
What Are the Differences Between Resetting a Task and Recreating a Task?
What Do I Do After Changing the Password of the Source or Destination Database?
Delay
Why Does the Delay of DR Tasks Increase?
Why Is the Delay High In MongoDB Replication Scenarios?
Troubleshooting
Solutions to Failed Check Items
Disk Space
Checking Whether the Destination Database Has Sufficient Storage Space
Checking Whether the Destination Server Has Sufficient Storage Space
Database Parameters
Checking Whether the Source Database Binlog Is Enabled
Checking Whether the Source Database Binlog Is Row-Based
Checking Whether the Binlog Retention Period Is Set on the Source Database
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether the Source Database server_id Meets the Incremental Migration Requirements
Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
Checking Whether the Source Database Contains Object Names with Non-ASCII Characters
Checking Whether the TIME_ZONE Values of the Source and Destination Databases Are the Same
Checking Whether the COLLATION_SERVER Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_UUID Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_ID Values of the Source and Destination Databases Are Different
Checking Whether the Source Database Contains Invalid sql_mode Values
Checking Whether the SQL_MODE Values of the Source and Destination Databases Are the Same
Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION
Checking Whether the innodb_strict_mode Values of the Source and Destination Databases Are the Same
Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured
Checking Whether the WAL_LEVEL Value in the Source Database Is Correct
Checking Whether the MAX_REPLICATION_SLOTS Value in the Source Database Is Correct
Checking Whether the Source Database Is on Standby
Checking Whether the log_slave_updates Value of the Source Database Is Correctly Configured
Checking Whether the BLOCK_SIZE Value of the Source Database Is the Same as That of the Destination Database
Checking Whether the binlog_row_image Value is FULL
Checking Whether the Transaction Isolation Levels are Consistent
Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same
Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters
Checking Whether the Source Database Collections Contain More Than 10 Indexes
Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Checking Whether the Databases and Tables Exist
Checking Whether session_replication_role of the Destination Database Is correctly Set
Checking Whether the MongoDB Instance Type Matches the Migration Mode
Checking the Physical Standby Database
Checking Whether the Values of group_concat_max_len Are Consistent
Checking Whether the Character Sets Are Compatible
Checking Replication Attribute of Primary Key Columns
Checking Whether the Source and Destination Database Character Sets Are Consistent
Source DB Instance Statuses
Checking Whether the Source and Destination Databases Are of the Same Type
Checking Whether the ChangeStream API of the source DB instance is available
Destination DB Instance Statuses
Checking Whether the Destination Database Is Involved in Another Migration Task
Checking Whether the Destination Database Has a Read Replica
Checking Whether the Extensions Are Supported
Checking Whether the Destination DB Instance Is Available
Database User Permissions
Whether the Source Database User Has Sufficient Permissions
Checking Whether the Destination Database User Has Sufficient Permissions
Database Versions
Checking Whether the Source Database Version Is Supported
Checking Whether the Destination Database Version Is Supported
Checking Whether the Migration Is from an Earlier Database Version to the Same or a Later Version
Networks
Checking Whether the Source Database Is Connected
Checking Whether the Destination Database Is Connected
Checking Whether the Destination Database Can Connect to the Source Database
Database Objects
Checking Whether the Source Database Contains a MyISAM Table
Checking Whether the Source Database Contains the Functions or Stored Procedures that the Source Database User Is Not Authorized to Migrate
Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database
Checking Whether the Source Database Tables Contain Primary Keys
Checking Whether the Source Database Contains Triggers or Events
Database Configuration Items
Checking Whether the Source Database Name Is Valid
Checking Whether the Source Database Table Name Is Valid
Checking Whether the Source Database View Name Is Valid
Checking Whether the Shard Key Can Be Obtained from the Source Database
Conflicts
Checking Whether the Names of the Source and Destination Databases Are the Same
Checking Whether the Destination Database Contains a Non-Empty Collection with the Same Name As the Source Database
SSL Connections
Checking Whether the SSL Connection Is Correctly Configured
Checking Whether the SSL Connection Is Enabled for the Source Database
Checking Whether the SSL Certificate of the Destination Database Exists
Object Dependencies
Checking Whether Referenced Tables Are Selected for Migration
Failure Cases
Backup Migration Failed Because Backup Files Cannot Be Found
Backup Migration Failed Because a Backup Database Cannot Be Found in the Backup Files
Change History
User Guide (ME-Abu Dhabi Region)
Service Overview
What Is DRS?
Advantages
Functions and Features
Real-Time Migration
Backup Migration
Basic Concepts
Billing
Security Suggestions
Accessing DRS
Permissions Management
Compliance Description
Related Services
Preparations
Overview
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
Real-Time Migration
To the Cloud
From MySQL to MySQL
Out of the Cloud
From MySQL to MySQL
Task Management
Creating a Migration Task
Querying the Migration Progress
Viewing Migration Logs
Comparing Migration Items
Managing Objects
Migrating Accounts
Parameters for Comparison
Task Life Cycle
Viewing Task Details
Editing Migration Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Migration Task
Resuming a Migration Task
Resetting a Migration Task
Pausing a Migration Task
Stopping a Migration Task
Deleting a Migration Task
Task Statuses
Backup Migration
Migration Overview
Creating an RDS Backup Migration Task
Creating a Backup Using OBS Buckets
Task Management
Viewing Task Details
Editing Migration Task Information
Viewing Migration Logs
Deleting a Migration Task
Task Statuses
Tag Management
FAQs
Product Consulting
What Is DRS?
Can DRS Migrate RDS Primary/Standby Instances?
Does DRS Support Resumable Uploads?
How Do I Solve the Table Bloat Issue?
Why Cannot I Select RDS Read Replicas on the DRS Console?
How Does DRS Affect the Source and Destination Databases?
Network and Security
What Security Protection Policies Does DRS Have?
What Can I Do If the Network Is Disconnected During the Migration?
How Can I Configure a VPC Security Group to Allow Traffic from an EIP?
What Can I Do If the Network Connection Between the Replication Instance and Database Is Abnormal?
Permissions Management
Which MySQL Permissions Are Required for DRS?
How Can I Import Users and Permissions from the Source to the Destination Database?
Real-Time Migration
When Can I Stop a Migration Task?
How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
How Do I Ensure that All Services on the Database Are Stopped?
What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
How Do I Export and Import Events and Triggers in Batches?
How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
Backup Migration
What Should I Do If the Last Backup File Is Incorrectly Selected in the Backup Migration Scenario?
Manual Configuration
Data-Level Comparison
Which of the Following Data Types Are Not Supported By Value Comparison?
What Impact Does a DRS Comparison Task Have on Databases?
How Long Does a DRS Comparison Task Take?
General Operations
What Can I Do When Information Overlaps on the DRS Console?
Is the Destination Instance Set to Read-only or Read/Write?
How Do I Set Global binlog_format=ROW to Take Effect Immediately?
How Do I Set binlog_row_image=FULL to Take Effect Immediately?
How Do I Change the Destination Database Password to Meet the Password Policy?
Does Bandwidth Expansion Affect the Running DRS Tasks?
Why Data in MariaDB and SysDB Cannot Be Migrated?
Constraints and Operation Suggestions on Many-to-One Scenario
Where Can I View DRS Operation Logs?
Can a Completed Task Be Restarted?
What Are the Differences Between Resetting a Task and Recreating a Task?
Troubleshooting
Solutions to Failed Check Items
Disk Space
Checking Whether the Destination Database Has Sufficient Storage Space
Checking Whether the Destination Server Has Sufficient Storage Space
Database Parameters
Checking Whether the Source Database Binlog Is Enabled
Checking Whether the Source Database Binlog Is Row-Based
Checking Whether the Binlog Retention Period Is Set on the Source Database
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether the Source Database server_id Meets the Incremental Migration Requirements
Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
Checking Whether the Source Database Contains Object Names with Non-ASCII Characters
Checking Whether the TIME_ZONE Values of the Source and Destination Databases Are the Same
Checking Whether the COLLATION_SERVER Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_UUID Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_ID Values of the Source and Destination Databases Are Different
Checking Whether the Source Database Contains Invalid sql_mode Values
Checking Whether the SQL_MODE Values of the Source and Destination Databases Are the Same
Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION
Checking Whether the innodb_strict_mode Values of the Source and Destination Databases Are the Same
Checking Whether the log_slave_updates Value of the Source Database Is Correctly Configured
Checking Whether the binlog_row_image Value is FULL
Checking Whether the Transaction Isolation Levels are Consistent
Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters
Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Checking Whether the Databases and Tables Exist
Checking Whether the Values of group_concat_max_len Are Consistent
Destination DB Instance Statuses
Checking Whether the Destination Database Is Involved in Another Migration Task
Checking Whether the Destination Database Has a Read Replica
Checking Whether the Destination DB Instance Is Available
Database User Permissions
Checking Whether the Source Database User Has Sufficient Permissions
Checking Whether the Destination Database User Has Sufficient Permissions
Database Versions
Checking Whether the Source Database Version Is Supported
Checking Whether the Destination Database Version Is Supported
Checking Whether the Migration Is from an Earlier Database Version to the Same or a Later Version
Networks
Checking Whether the Source Database Is Connected
Checking Whether the Destination Database Is Connected
Checking Whether the Destination Database Can Connect to the Source Database
Database Objects
Checking Whether the Source Database Contains a MyISAM Table
Checking Whether the Source Database Contains the Functions or Stored Procedures that the Source Database User Is Not Authorized to Migrate
Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database
Checking Whether the Source Database Tables Contain Primary Keys
Checking Whether the Source Database Contains Triggers or Events
Database Configuration Items
Checking Whether the Source Database Name Is Valid
Checking Whether the Source Database Table Name Is Valid
Checking Whether the Source Database View Name Is Valid
Conflicts
Checking Whether the Names of the Source and Destination Databases Are the Same
SSL Connections
Checking Whether the SSL Connection Is Correctly Configured
Checking Whether the SSL Certificate of the Destination Database Exists
Object Dependencies
Checking Whether Referenced Tables Are Selected for Migration
Failure Cases
Backup Migration Failed Because Backup Files Cannot Be Found
Backup Migration Failed Because a Backup Database Cannot Be Found in the Backup Files
Change History
User Guide (Kuala Lumpur Region)
Service Overview
What Is DRS?
Advantages
Functions and Features
Real-Time Migration
Backup Migration
Real-Time Synchronization
Basic Concepts
Security Suggestions
Accessing DRS
Compliance Description
Related Services
Real-Time Migration
To the Cloud
From MySQL to MySQL
PostgreSQL->PostgreSQL
Out of the Cloud
From MySQL to MySQL
Task Management
Creating a Migration Task
Querying the Migration Progress
Viewing Migration Logs
Comparing Migration Items
Managing Objects
Migrating Accounts
Parameters for Comparison
Task Life Cycle
Viewing Task Details
Editing Migration Task Information
Modifying Migration Information
Editing a Migration Task
Resuming a Migration Task
Resetting a Migration Task
Pausing a Migration Task
Modifying the Flow Control Mode
Stopping a Migration Task
Deleting a Migration Task
Task Statuses
Backup Migration
Migration Overview
Creating an RDS Backup Migration Task
Creating a Backup Using OBS Buckets
Task Management
Viewing Task Details
Editing Migration Task Information
Viewing Migration Logs
Deleting a Migration Task
Task Statuses
Tag Management
Real-Time Synchronization
Data Synchronization Topologies
To the Cloud
From MySQL to MySQL
From PostgreSQL to PostgreSQL
From DDM to MySQL
Out of the Cloud
From MySQL to MySQL
From DDM to MySQL
Task Management
Creating a Synchronization Task
Viewing the Synchronization Progress
Viewing Synchronization Logs
Comparing Items
Managing Objects
Editing Synchronization Objects
Mapping Object Names
Viewing Synchronization Mapping Information
Processing Data
Task Life Cycle
Viewing Task Details
Modifying Task Information
Modifying Synchronization Information
Editing a Synchronization Task
Resuming a Synchronization Task
Pausing a Synchronization Task
Resetting a Synchronization Task
Modifying the Flow Control Mode
Stopping a Synchronization Task
Deleting a Synchronization Task
Task Statuses
Operation Reference in Synchronization Scenarios
Forcibly Stopping Synchronization of PostgreSQL
Creating Triggers and Functions to Implement Incremental DDL Synchronization for PostgreSQL
FAQs
Product Consulting
What Is DRS?
Can DRS Migrate RDS Primary/Standby Instances?
Does DRS Support Resumable Uploads?
What Are the Differences Between Data Migration and Synchronization?
How Do I Solve the Table Bloat Issue?
Why Cannot I Select RDS Read Replicas on the DRS Console?
How Does DRS Affect the Source and Destination Databases?
Network and Security
What Security Protection Policies Does DRS Have?
What Can I Do If the Network Is Disconnected During the Migration?
How Can I Set a VPC Security Group to Access to an Outside EIP?
What Can I Do If the Network Connection Between the Replication Instance and Database Is Abnormal?
Permissions Management
Which MySQL Permissions Are Required for DRS?
How Can I Import Users and Permissions from the Source to the Destination Database?
Real-Time Migration
When Can I Stop a Migration Task?
How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
How Do I Ensure that All Services on the Database Are Stopped?
What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
How Do I Export and Import Events and Triggers in Batches?
How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
Backup Migration
What Should I Do If the Last Backup File Is Incorrectly Selected in the Backup Migration Scenario?
Manual Configuration
Real-Time Synchronization
Can DRS Sync Tables of Different Schemas to the Same Schema?
Can Online DDL Tools Be Used for Real-time Synchronization?
Which MySQL DDL Statements Can Be Directly Executed in GaussDB(DWS)?
Why Do I Use the SCAN IP Address to Connect to an Oracle RAC Cluster?
How Do I Check Supplemental Logging of the Source Oracle Database?
Data-Level Comparison
Which of the Following Data Types Are Not Supported By Value Comparison?
General Operations
What Can I Do When Information Overlaps on the DRS Console?
How Do I Set Global binlog_format=ROW to Take Effect Immediately?
How Do I Set binlog_row_image=FULL to Take Effect Immediately?
How Do I Change the Destination Database Password to Meet the Password Policy?
Does Bandwidth Expansion Affect the Running DRS Tasks?
Why Data in MariaDB and SysDB Cannot Be Migrated?
Constraints and Operation Suggestions on Many-to-One Scenario
Where Can I View DRS Operation Logs?
Can a Completed Task Be Restarted?
What Are the Differences Between Resetting a Task and Recreating a Task?
Troubleshooting
Solutions to Failed Check Items
Disk Space
Checking Whether the Destination Database Has Sufficient Storage Space
Checking Whether the Destination Server Has Sufficient Storage Space
Database Parameters
Checking Whether the Source Database Binlog Is Enabled
Checking Whether the Source Database Binlog Is Row-Based
Checking Whether the Binlog Retention Period Is Set on the Source Database
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether the Source Database server_id Meets the Incremental Migration Requirements
Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
Checking Whether the Source Database GTID Is Enabled
Checking Whether the Source Database Contains Object Names with Non-ASCII Characters
Checking Whether the Source and Destination Database TIME_ZONE Values Are Consistent
Checking Whether the COLLATION_SERVER Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_UUID Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_ID Values of the Source and Destination Databases Are Different
Checking Whether the Source Database Contains Invalid sql_mode Values
Checking Whether the SQL_MODE Values of the Source and Destination Databases Are the Same
Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION
Checking Whether the innodb_strict_mode Values of the Source and Destination Databases Are the Same
Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured
Checking Whether the WAL_LEVEL Value in the Source Database Is Correct
Checking Whether the MAX_REPLICATION_SLOTS Value in the Source Database Is Correct
Checking Whether the Source Database Is on Standby
Checking Whether the log_slave_updates Value of the Source Database Is Correctly Configured
Checking Whether the binlog_row_image Value is FULL
Checking Whether the Transaction Isolation Levels are Consistent
Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same
Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters
Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Checking Whether the Databases and Tables Exist
Destination DB Instance Statuses
Checking Whether the Destination Database Is Involved in Another Migration Task
Checking Whether the Destination Database Has a Read Replica
Checking Whether the Extensions Are Supported
Checking Whether the Destination DB Instance Is Available
Database User Permissions
Checking Whether the Source Database User Has Sufficient Permissions
Checking Whether the Destination Database User Has Sufficient Permissions
Database Versions
Checking Whether the Source Database Version Is Supported
Checking Whether the Destination Database Version Is Supported
Checking Whether the Migration Is from an Earlier Database Version to the Same or a Later Version
Networks
Checking Whether the Source Database Is Connected
Checking Whether the Destination Database Is Connected
Checking Whether the Destination Database Can Connect to the Source Database
Database Objects
Checking Whether the Source Database Contains a MyISAM Table
Checking Whether the Source Database Contains the Functions or Stored Procedures that the Source Database User Is Not Authorized to Migrate
Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database
Checking Whether the Source Database Tables Contain Primary Keys
Checking Whether the Source Database Contains Triggers or Events
Database Configuration Items
Checking Whether the Source Database Name Is Valid
Checking Whether the Source Database Table Name Is Valid
Checking Whether the Source Database View Name Is Valid
Conflicts
Checking Whether the Names of the Source and Destination Databases Are the Same
SSL Connections
Checking Whether the SSL Connection Is Correctly Configured
Checking Whether the SSL Connection Is Enabled for the Source Database
Checking Whether the SSL Certificate of the Destination Database Exists
Object Dependencies
Checking Whether Referenced Tables Are Selected for Migration
Failure Cases
Backup Migration Failed Because Backup Files Cannot Be Found
Backup Migration Failed Because a Backup Database Cannot Be Found in the Backup Files
Change History
User Guide (Ankara Region)
Service Overview
What Is DRS?
Supported Databases
Advantages
Functions and Features
Real-Time Migration
Real-Time Synchronization
Real-Time Disaster Recovery
Product Architecture and Function Principles
Mapping Data Types
MySQL->PostgreSQL
MySQL->Oracle
Oracle->MySQL
Oracle->PostgreSQL
Instructions
Permissions Management
Accessing DRS
Related Services
Basic Concepts
Preparations
Overview
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
From the Public Cloud to the Public Cloud
Accessing the Public Cloud Through a VPC (Same Region and Same VPC)
Accessing the Public Cloud Through a VPC (Same Region and Different VPCs)
Accessing the Public Cloud over a Public Network (Different Regions)
Accessing the Public Cloud Through a VPN (Different Regions)
From ECS Databases on the Public Cloud to the Public Cloud
Accessing the Public Cloud Through a VPC (Same Region and Same VPC)
Accessing the Public Cloud Through a VPC (Same Region and Different VPCs)
Accessing the Public Cloud over a Public Network (Different Regions)
Accessing the Public Cloud Through a VPN (Different Regions)
Real-Time Migration
Migration Overview
To the Cloud
From MySQL to MySQL
Out of the Cloud
From MySQL to MySQL
Task Management
Creating a Migration Task
Querying the Migration Progress
Viewing Migration Logs
Comparing Migration Items
Managing Objects
Migrating Accounts
Parameters for Comparison
Task Life Cycle
Viewing Task Details
Editing Migration Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Migration Task
Resuming a Migration Task
Resetting a Migration Task
Pausing a Migration Task
Stopping a Migration Task
Deleting a Migration Task
Task Statuses
Real-Time Synchronization
Synchronization Overview
Data Synchronization Topologies
To the Cloud
From MySQL to MySQL
From MySQL to PostgreSQL
From PostgreSQL to PostgreSQL
From Oracle to MySQL
From Oracle to PostgreSQL
Out of the Cloud
From MySQL to MySQL
From MySQL to Kafka
From MySQL to Oracle
Between Self-built Databases
From MySQL to Kafka
From Oracle to Kafka
Task Management
Creating a Synchronization Task
Querying the Synchronization Progress
Viewing Synchronization Logs
Comparing Synchronization Items
Managing Objects
Editing Synchronization Objects
Importing Synchronization Objects
Mapping Object Names
Viewing Synchronization Mapping Information
Processing Data
Task Life Cycle
Viewing Task Details
Modifying Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a Synchronization Task
Resuming a Synchronization Task
Pausing a Synchronization Task
Resetting a Synchronization Task
Stopping a Synchronization Task
Deleting a Synchronization Task
Task Statuses
Operation Reference in Synchronization Scenarios
Kafka Message Format
Kafka Authentication
Forcibly Stopping Synchronization of PostgreSQL
Creating Triggers and Functions to Implement Incremental DDL Synchronization for PostgreSQL
Real-Time Disaster Recovery
DR Overview
DR Scenarios
From MySQL to MySQL (Single-Active DR)
From MySQL to MySQL (Dual-Active DR)
Task Management
Creating a DR Task
Querying the DR Progress
Viewing DR Logs
Comparing DR Items
Task Life Cycle
Viewing DR Data
Editing DR Task Information
Modifying Connection Information
Modifying the Flow Control Mode
Editing a DR Task
Resuming a DR Task
Pausing a DR Task
Viewing DR Metrics
Performing a Primary/Standby Switchover for DR Tasks
Stopping a DR Task
Deleting a DR Task
Task Statuses
FAQs
Product Consulting
What Are Regions and AZs?
What Is DRS?
Can DRS Migrate RDS Primary/Standby Instances?
Does DRS Support Resumable Uploads?
What Is Single-Active/Dual-Active Disaster Recovery?
What Are the Differences Between Real-Time Migration, Real-Time DR, and Real-Time Synchronization?
How Do I Solve the Table Bloat Issue During MySQL Migration?
How Does DRS Affect the Source and Destination Databases?
Can DRS Migrates Table Structures Only?
Which Operations on the Source or Destination Database Affect the DRS Task Status?
Why Cannot Standby Read Replicas on Some Other Clouds Be Used as the Source Database?
Network and Security
What Security Protection Policies Does DRS Have?
What Can I Do If the Network Is Disconnected During the Migration?
How Do I Configure a VPC Security Group to Allow Network Communication?
What Can I Do If the Network Connection Between the Replication Instance and Database Is Abnormal?
Permissions Management
Which MySQL Permissions Are Required for DRS?
How Can I Import Users and Permissions from the Source to the Destination Database?
Real-Time Migration
When Can I Stop a Migration Task?
How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
How Do I Ensure that All Services on the Database Are Stopped?
What Can I Do When Message "can not get agency token" Is Displayed in the Migration Log
What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
How Do I Export and Import Events and Triggers in Batches?
How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
What Can I Do If There Is an Extra Backslash (\) After a MySQL Account Is Migrated?
Real-Time Synchronization
Can DRS Sync Tables of Different Schemas to the Same Schema?
Can Online DDL Tools Be Used for Real-time Synchronization?
Why Do I Use the SCAN IP Address to Connect to an Oracle RAC Cluster?
How Do I Check Supplemental Logging of the Source Oracle Database?
Garbled Characters or Synchronization Failure Due to Incompatible Character Sets
How Do I Specify the Start Point for DRS Incremental Synchronization?
Real-Time Disaster Recovery
What Are RPO and RTO of DRS Disaster Recovery?
How Do I Select Active Database 1 and 2 for Dual-Active DR?
What Is the Meaning of Forward and Backward Subtasks in Dual-Active Disaster Recovery?
Common Exceptions in Real-Time Disaster Recovery
Is a Primary/Standby Switchover Triggered Automatically or Manually for DR Tasks?
Can Real-Time DR Be Performed for Specified Databases?
Why Does a Real-Time DR Task Not Support Triggers and Events?
Data-Level Comparison
Which of the Following Data Types Are Not Supported By Value Comparison?
What Impact Does a DRS Comparison Task Have on Databases?
How Long Does a DRS Comparison Task Take?
General Operations
What Can I Do When Information Overlaps on the DRS Console?
Is the Destination Instance Set to Read-only or Read/Write?
How Do I Set Global binlog_format=ROW to Take Effect Immediately?
How Do I Set binlog_row_image=FULL to Take Effect Immediately?
How Do I Change the Destination Database Password to Meet the Password Policy?
Does Bandwidth Expansion Affect the Running DRS Tasks?
Why Data in MariaDB and SysDB Cannot Be Migrated?
Constraints and Operation Suggestions on Many-to-One Scenario
Where Can I View DRS Operation Logs?
Can a Completed Task Be Restarted?
What Are the Differences Between Resetting a Task and Recreating a Task?
What Do I Do After Changing the Password of the Source or Destination Database?
What Can I Do If a DRS Task Times Out Due to Too Many Tables?
Can I Change the Source or Destination Database After a DRS Task Is Created?
Delay
What Are Possible Causes of Slow Migration or Suspended Progress in Full Phase?
What Are Possible Causes of High Latency in DRS Incremental Phase?
Troubleshooting
Solutions to Failed Check Items
Disk Space
Checking Whether the Destination Database Has Sufficient Storage Space
Checking Whether the Destination Server Has Sufficient Storage Space
Database Parameters
Checking Whether the Source Database Binlog Is Enabled
Checking Whether the Source Database Binlog Is Row-Based
Checking Whether the Binlog Retention Period Is Set on the Source Database
Checking Whether the Source and Destination Database Character Sets Are Consistent
Checking Whether the Source Database server_id Meets the Incremental Migration Requirements
Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
Checking Whether the Source Database Contains Object Names with Non-ASCII Characters
Checking Whether the TIME_ZONE Values of the Source and Destination Databases Are the Same
Checking Whether the COLLATION_SERVER Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_UUID Values of the Source and Destination Databases Are the Same
Checking Whether the SERVER_ID Values of the Source and Destination Databases Are Different
Checking Whether the Source Database Contains Invalid sql_mode Values
Checking Whether the sql_mode Values of the Source and Destination Databases Are the Same
Checking Whether the sql_mode Value in the Destination Database Is Not no_engine
Checking Whether the innodb_strict_mode Values of the Source and Destination Databases Are the Same
Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured
Checking Whether the WAL_LEVEL Value in the Source Database Is Correct
Checking Whether the MAX_REPLICATION_SLOTS Value in the Source Database Is Correct
Checking Whether the Source Database Is on Standby
Checking Whether the log_slave_updates Value of the Source Database Is Correctly Configured
Checking Whether the BLOCK_SIZE Value of the Source Database Is the Same as That of the Destination Database
Checking Whether the binlog_row_image Value is FULL
Checking Whether the Transaction Isolation Levels are Consistent
Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same
Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters
Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Checking Whether the Source Database User Has the Permission to Parse Logs
Checking Whether the Databases and Tables Exist
Checking Whether the Supplemental Log Level of the Source Database Meets Requirements
Checking Whether session_replication_role of the Destination Database Is correctly Set
Checking the Physical Standby Database
Checking Whether the Values of group_concat_max_len Are Consistent
Checking Whether the Character Sets Are Compatible
Checking Replication Attribute of Primary Key Columns
Checking Whether the Source and Destination Database Character Sets Are Consistent
Whether the Selected Table Contains Delay Constraints
Whether the Source Database Tables Contain Primary Keys
Whether the Source Table Structure Contains Newline Characters
Whether There Are Tables Containing Fields of the bytea or text Type in the Synchronization Object
Whether the max_allowed_packet Value of the Source Database Is Too Small
block_encryption_mode Consistency Check
Character Type and Sorting Rule Check in the Destination Database
Destination DB Instance Statuses
Checking Whether the Destination Database Is Involved in Another Migration Task
Checking Whether the Destination Database Has a Read Replica
Checking Whether the Extensions Are Supported
Checking Whether the Destination DB Instance Is Available
Database User Permissions
Whether the Source Database User Has Sufficient Permissions
Checking Whether the Destination Database User Has Sufficient Permissions
Database Versions
Checking Whether the Source Database Version Is Supported
Checking Whether the Destination Database Version Is Supported
Checking Whether the Migration Is from an Earlier Database Version to the Same or a Later Version
Networks
Checking Whether the Source Database Is Connected
Checking Whether the Destination Database Is Connected
Checking Whether the Destination Database Can Connect to the Source Database
Database Objects
Checking Whether the Source Database Contains a MyISAM Table
Checking Whether the Source Database Contains the Functions or Stored Procedures that the Source Database User Is Not Authorized to Migrate
Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database
Checking Whether the Source Database Tables Contain Primary Keys
Checking Whether the Source Database Contains Triggers or Events
Database Configuration Items
Checking Whether the Source Database Name Is Valid
Checking Whether the Source Database Table Name Is Valid
Checking Whether the Source Database View Name Is Valid
Conflicts
Checking Whether the Names of the Source and Destination Databases Are the Same
SSL Connections
Checking Whether the SSL Connection Is Correctly Configured
Checking Whether the SSL Connection Is Enabled for the Source Database
Checking Whether the SSL Certificate of the Destination Database Exists
Object Dependencies
Checking Whether Referenced Tables Are Selected for Migration
Change History
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions