Distributed Database Middleware
Distributed Database Middleware
All results for "
" in this service
All results for "
" in this service
What's New
Service Overview
Overview
Basic Concepts
Core Functions
Product Specifications
Usage Constraints
Network Access
Data Nodes
Unavailable Features and Limitations
High-risk Operations
Regions and AZs
Application Scenarios
Permissions Management
Change History
Getting Started
Overview
Step 1: Buy a DDM Instance and an RDS for MySQL Instance
Step 2: Create a Schema and Associate It with an RDS for MySQL Instance
Step 3: Create a DDM Account
Step 4: Log In to the DDM Schema
Change History
User Guide
Function Overview
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
Instance Management
Buying 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 Class of a DDM Node
Scaling Out a DDM Instance
Scaling In a DDM Instance
Changing Billing Mode of a DDM Instance
Renewing a DDM Instance
Restarting a DDM Instance
Restarting a DDM Instance
Restarting a Node
Unsubscribing from a DDM Instance
Deleting a DDM Instance
Modifying Parameters of a DDM Instance
Splitting Read and Write Requests
Configuring a Parameter Template
Connection Management
Configuring Access Control
Modifying the Floating IP Address of a DDM Instance and a Group
Binding and Unbinding an EIP
Changing a Database Port
Changing the Security Group of a DDM Instance
Parameter Template Management
Creating a Parameter Template
Editing a 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
Task Center
Schema Management
Creating a Schema
Exporting Schema Information
Importing Schema Information
Deleting a Schema
Configuring the SQL Blacklist
Shard Configuration
Overview and Application Scenarios
Assessment
Pre-check
Operation Guide
Data Node Management
Overview
Configuring Read Weights
Synchronizing Data Node Information
Reloading Table Data
Account Management
Creating an Account
Modifying an Account
Deleting an Account
Resetting the Password of an Account
Managing Permissions
Account Permissions
Account Requirements
Managing Permissions
Backups and Restorations
Overview
Consistent Backups
Restoring Data to a New Instance
Restoring Metadata
Data Migration
Overview
Migration Evaluation
Scenario 1: Migrating Data from Huawei Cloud RDS to DDM
Scenario 2: Migrating Data from an On-Premises RDS Instance for MySQL to DDM
Scenario 3: Migrating Data from a Third-Party RDS for MySQL Instance to DDM
Scenario 4: Migrating Data from a Self-Built MySQL Instance to DDM
Scenario 5: Migrating Data from Heterogeneous Databases to DDM
Scenario 6: Exporting Data from a DDM Instance
Slow Queries
Monitoring Management
Metrics
Viewing Metrics
Network Metrics
Auditing
Key Operations Recorded by CTS
Querying Traces
SQL Syntax
Introduction
DDL
Overview
Creating a Table
Sharding Algorithm Overview
Sharding Algorithms
MOD_HASH
MOD_HASH_CI
RIGHT_SHIFT
MM
DD
WEEK
MMDD
YYYYMM
YYYYDD
YYYYWEEK
HASH
Range
DML
INSERT
REPLACE
DELETE
UPDATE
SELECT
SELECT JOIN Syntax
SELECT UNION Syntax
SELECT Subquery Syntax
Unsupported DML Statements
Supported System Schema Queries
Functions
Use Constraints
Supported SQL Statements
CHECK TABLE
Checking DDL Consistency of Physical Tables in All Logical Tables
Checking DDL Consistency of Physical Tables in One Logical Table
SHOW RULE
SHOW TOPOLOGY
SHOW DATA NODE
TRUNCATE TABLE
HINT-DB
HINT-TABLE
HINT-DB/TABLE
Additional Information
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 Executing 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
Quotas
Change History
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Returned Values
APIs (Recommended)
DDM Instances
Buying a DDM instance
Querying DDM Instances
Querying Details of a DDM Instance
Modifying the Name of a DDM Instance
Modifying the Security Group of a DDM Instance
Deleting a DDM Instance
Restarting a DDM Instance
Reloading Table Data
Scaling out a DDM instance
Scaling in a DDM instance
Modifying the Read Policy of the Associated DB Instance
Synchronizing Data Node Information
Querying Nodes of a DDM Instance
Querying Details of a DDM Instance Node
Querying Parameters of a Specified DDM Instance
Modifying Parameters of a DDM Instance
Querying DDM Engine Information
Querying DDM Node Classes Available in an AZ
Changing the Node Class of a DDM Instance
Schemas
Creating a Schema
Querying Schemas
Querying Details of a Schema
Deleting a Schema
Querying DB Instances Available for Creating a Schema
DDM Accounts
Creating a DDM Account
Querying DDM Accounts
Modifying a DDM Account
Deleting a DDM Account
Resetting the Password of a DDM Account
Managing the Administrator Password
Validating Password Strength
Monitoring
Monitoring Slow Query Logs
APIs (Unavailable Soon)
Monitoring the Read/Write Ratio
Appendix
Abnormal Request Results
Status Codes
Error Codes
Instance Specifications
Obtaining a Project ID
Status Description
Change History
SDK Reference
SDK Overview
Best Practices
Overview
Formulating Sharding Rules
Determining the Number of Shards in a Schema
Using Broadcast and Unsharded Tables
Transaction Models
SQL Standards
Migrating an Entire RDS Database to DDM
Migrating an Entire MyCat Database to DDM
Accessing DDM Using a JDBC Connection Pool
Logging In to a DDM Instance Using Navicat
Migrating Data from RDS for MySQL to DDM Using DRS
Overview
Resource and Cost Planning
Operation Process
Preparing for the Source RDS for MySQL Instance
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Creating a VPN for the Source
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 VPN for the Destination
Modifying the VPN Configuration for the Source
Creating a DRS Migration Task
Checking Migration Results
Performance White Paper
Sysbench
FAQs
General Questions
What High-Reliability Mechanisms Does DDM Provide?
How Do I Select and Configure a Security Group?
What Do I Do If My Database Time Is 13 or 14 Hours Later than Beijing Time?
Can Data Nodes Associated with a DDM Instance Share Data?
What Data Nodes Can Be Associated with a DDM Instance?
DDM Usage
How Does DDM Perform Sharding?
What Do I Do If I Fail to Connect to a DDM Instance Using the JDBC Driver?
What Version and Parameters Should I Select?
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
Does DDM Support Distributed JOINs?
How Do I Optimize SQL Statements?
Does DDM Support Forced Conversion of Data Types?
What Should I Do If an Error Is Reported When Multiple Data Records Are Inserted into Batches Using the INSERT Statement?
RDS-related Questions
Is the Name of a Database Table Case-Sensitive?
What Risky Operations on RDS for MySQL Will Affect DDM?
How Do I Handle Data with Duplicate Primary Keys in a Table?
How Can I Query RDS for MySQL Information by Running Command show full innodb status?
Connection Management
How Can I Handle Garbled Characters Generated When I Connect a MySQL Instance to a DDM Instance?
Resource Freezing, Release, Deletion, and Unsubscription
Change History
Videos