Service Overview
- What Is DDM?
- Basic Concepts
- Core Functions
- Product Specifications
- Use Constraints
- Regions and AZs
- Application Scenarios
- Permissions Management
Getting Started
- Process of Using DDM
- Precautions for Creating a DDM Instance
- Step 1: Create a DDM Instance and an RDS for MySQL Instance
- Step 2: Create a DDM Account
- Step 3: Create a Schema and Associate It with an RDS for MySQL Instance
- Step 4: Log In to the DDM Schema
Function Overview
Permissions Management
- Creating a User and Granting Permissions
- Creating a Custom Policy
- Database Accounts and Permissions
Instance Management
- Instance Statuses
- Creating a DDM instance
- Splitting Read-only and Read-Write Services
  - What Is Read-only Service Isolation?
  - How Are Read-only Services Split from Read-Write Services
- Changing Node Class
- Scaling Out a DDM Instance
- Scaling In a DDM Instance
- Restarting a DDM Instance or an Instance Node
- Deleting a DDM Instance
- Reloading Table Data
- Changing a Parameter Template
- Modifying Parameters of a DDM Instance
- Rolling Back the Version of a DDM Instance
- Upgrading the Version of a DDM Instance
- Version Change
Connection Management
- Configuring Access Control
- Binding and Unbinding an EIP
- Changing the DDM Service Port
- Changing the Security Group of a DDM Instance
Schema Management
- Creating a Schema
- Exporting Schema Information
- Importing Schema Information
- Deleting a Schema
- Configuring a SQL Blacklist
- Viewing Schemas
Shard Configuration
- Overview and Application Scenarios
- Assessment
- Pre-check
- Operation Guide
Data Nodes
- Overview
- Synchronizing Data Node Information
- Enabling Read/Write Splitting
- Configuring Read Weights
- Configuring Read/Write Splitting
Parameter Template Management
- Instance Parameters
- Creating a Parameter Template
- Modifying a Custom Parameter Template
- Comparing Two Parameter Templates
- Viewing Parameter Change History
- Replicating a Parameter Template
- Applying a Parameter Template
- Viewing Application Records of a Parameter Template
- Modifying the Description of a Parameter Template
- Deleting a Parameter Template
Account Management
- Adding an Administrator Account
- Creating an Account
- Modifying an account
- Deleting an Account
- Resetting the Password of an Account
- Account Permissions
Backups and Restorations
- Backup Principles
- Consistent Backups
- Restoring Data to a New Instance
- Restoring Metadata
Data Migration
- Overview
- Migration Evaluation
- Scenario 1: Migrating Data from an On-Premises MySQL Instance to DDM
- Scenario 2: Migrating Data from a Third-Party Cloud MySQL Instance to DDM
- Scenario 3: Migrating Data from an ECS-hosted MySQL Instance to DDM
- Scenario 4: Exporting Data from a DDM Instance
Session Management
Slow Queries
Monitoring
- Supported Metrics
  - DDM Instance Metrics
  - Network Metrics
- Viewing Metrics
  - Viewing Instance Metrics
  - Viewing Network Metrics
- Creating Monitoring Alarm Rules
- Event Monitoring
  - Overview
  - Viewing Event Monitoring Data
  - Creating an Alarm Rule for Event Monitoring
  - Events Supported by Event Monitoring
Task Center
Tags
Auditing
- Key Operations Recorded by CTS
- Querying Traces
SQL Syntax
- Introduction
- DDL
- DML
- Online DDL
- Functions
- Unsupported Objects and Use Constraints
- Supported SQL Statements
  - CHECK TABLE
    - Checking DDL Consistency of Physical Tables in All Logical Tables
    - Checking DDL Consistency of All Physical Tables Corresponding to One Logical Table
  - SHOW RULE
  - SHOW TOPOLOGY
  - SHOW DATA NODE
  - TRUNCATE TABLE
  - HINT- ALLOW_ALTER_RERUN
  - LOAD DATA
  - SHOW PHYSICAL PROCESSLIST
  - Customized Hints for Read/Write Splitting
  - Setting a Hint to Skip the Cached Execution Plan
  - Specifying a Shard Using a Hint When You Execute a SQL Statement
- Global Sequence
  - Overview
  - Using NEXTVAL or CURRVAL to Query Global Sequence Numbers
  - Using Global Sequences in INSERT or REPLACE Statements
- Database Management Syntax
- Advanced SQL Functions
FAQs
- General Questions
- DDM Usage
  - How Does DDM Perform Sharding?
  - What Do I Do If I Fail to Connect to a DDM Instance Using the JDBC Driver?
  - Why It Takes So Long Time to Export Data from MySQL Using mysqldump?
  - What Do I Do If a Duplicate Primary Key Error Occurs When Data Is Imported into DDM?
  - What Should I Do If an Error Message Is Returned When I Specify an Auto-Increment Primary Key During Migration?
  - What Do I Do If an Error Is Reported When Parameter Configuration Does Not Time Out?
  - Which Should I Delete First, a Schema or its Associated RDS Instances?
  - Can I Manually Delete Databases and Accounts Remained in Data Nodes After a Schema Is Deleted?
- SQL Syntax
- RDS-related Questions
- Connection Management
  - How Can I Handle Garbled Characters Generated When I Connect a MySQL Instance to a DDM Instance?
Change History

TRUNCATE TABLE