Document Center
PolarDB-X
Brand upgrade
Product Introduction
PolarDB-X overview
PolarDB-X scenarios
Features
High availability and disaster recovery
Strongly consistent distributed transactions
Distributed linear scalability
Compatibility with the MySQL ecosystem
GSI
HTAP
Global data change logging
Data backup and restoration
End-to-end monitoring and auditing
Quick Start
Get started
Create an instance
Create a database
Connect to a PolarDB-X database
Basic SQL operations
User Guide
Instance types
View and update the version of an instance
Instance management
Change instance specifications
Release an instance
Update the version of an instance
Restart an instance
Renew an instance
Read-only PolarDB-X instances
Network and connection
Connect to a database
Cluster endpoints and read-only routing endpoints
Apply for or release a public endpoint
Import and export data
Use DTS to import and export data
Use mysqldump to migrate data
Use a program to import data
Use Batch Tool to export and import data
Accounts and Security
Register and log on to an Alibaba Cloud account
Configure whitelists
Configure SSL encryption
Configure TDE
Three-role mode
Overview
Enable and disable the three-role mode
Manage the accounts for the three roles
Permission verification
Parameter settings
Monitoring and alert
Monitor computing resources
Storage monitoring
Configure alert rules
Diagnosis and optimization
SQL audit and analysis
Overview
Enable SQL audit and analysis
Log fields
Log analysis
Log reports
Performance trend
Instance sessions
Storage analysis
Backup and restoration
Back up data
Restore data
Use PolarDB-X together with other Alibaba Cloud services
Query global binary logs
Developer Guide
Limits on database development
SQL syntax overview
Data types
Numeric data types
String data types
Collation types
Date and time data types
JSON data types
Operators
Logical operators
Arithmetic operators
Comparison operators
Bitwise operators
Assignment operators
Operator precedence
Functions
Sharding functions
HASH
STR_HASH
UNI_HASH
RANGE_HASH
RIGHT_SHIFT
MM
DD
YYYYDD
WEEK
MMDD
YYYYMM
YYYYWEEK
Date and time functions
String functions
Conversion functions
Aggregate functions
Mathematical functions
Comparison functions
Bit functions
Flow control functions
Information functions
Encryption functions and compression functions
Window functions
JSON functions
Other functions
PolarDB-X 1.0
Product Introduction
Overview
Architecture
Scenarios
Pricing
Quick Start
Step 1: Create a PolarDB-X 1.0 instance
Step 2: Create a database
Step 3: Create a table
Step 4: Connect to PolarDB-X 1.0
Basic SQL operations
How It Works
Scalability
Distributed transactions
Read/write splitting
Global secondary indexes
User Guide
Instance Management
Overview of instances
Change the instance configurations
Upgrade the version
Set parameters
Manage accounts
Monitoring and Alerts
Monitor instances
Monitor databases
Monitor storage nodes
Manage alert rules
Switch zones
Data Recovery
Backup and recovery
SQL Flashback
Table recycle bin
Database Management
Overview
View database information
Create a DRDS database
Network and Connection
Fix database shard connections
Apply for or release a public IP address
Storage management
Table Management
Query table schema
Delete tables
Adjust shard keys
Disable full table scan
Set an IP address whitelist
Transactions
Distributed transactions based on MySQL 5.6
Import and Export Data
Overview of data migration or synchronization solutions
Evaluate Import
Migrate data from RDS to PolarDB-X 1.0
Import and export data through mysqldump
Import big data through a program
Import and export data through Data Integration
Evaluate Import
Import data from MyCat DRDS
Evaluate data import from RDS database to DRDS
Customized Control Commands
Introduction
Help statements
Statements for displaying rules and node topologies
SQL optimization statements
Statistic query statements
SHOW PROCESSLIST and KILL
SHOW PROCESSLIST and KILL of the old version
Recycle bin
Database Management
Query details about slow SQL queries
Basic concepts of SQL tuning
SQL tuning methods and practices
Advanced SQL tuning
Introduction to the query optimizer
SQL rewrite and pushdown
Introduction to the query executor
Execution plans and basic operators
Optimize and execute JOINs and subqueries
Aggregation and sorting optimization
Manage execution plans
Intelligent index recommendation
System Operations
Automatic protection against high-risk SQL statements
Pending events
Global Secondary Index
Use global secondary indexes
Notes for using GSIs
Access Control
Register and log on to an Alibaba Cloud account
Use RAM in PolarDB-X 1.0
Activate authorization for PolarDB-X 1.0 to access ApsaraDB for RDS
Use RAM in the DRDS console
Use RAM for resource authorization
SQL Reference
SQL limits
Instructions for sharding function
HASH
STR_HASH
UNI_HASH
RANGE_HASH
RIGHT_SHIFT
MM
DD
WEEK
MMDD
YYYYDD
YYYYMM
YYYYWEEK
Overview
Manage DDL tasks
Overview
Job management statements
Control parameters for DDL execution engine
Considerations and limits
Best practices
DDL
CREATE TABLE
DROP TABLE
ALTER TABLE
TRUNCATE TABLE
RENAME TABLE
CREATE INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
DDL FAQ
DML
SELECT
Subquery
INSERT
REPLACE
UPDATE
DELETE
Limits of global secondary indexes on DML
SHOW
SHOW HELP
Rule and topology query statements
Slow SQL queries
Statistics queries
SHOW PROCESSLIST
SHOW GLOBAL INDEX
SHOW INDEX
SHOW METADATA LOCK
DAL
Manage accounts and permissions
CHECK TABLE
CHECK GLOBAL INDEX
KILL
USE
Sequence
Overview
Limits
Explicit sequences
Implicit sequences
Outline
Usage notes
Error codes
Prepare SQL
Introduction to the prepared statement protocol
Hint
Overview
Read/write splitting
Specify a custom time-out period for an SQL statement
Specify database shards where an SQL statement is to be executed
Scan all or some of the table shards in all or some of the database shards
INDEX HINT
Functions
Functions
Date and time functions
String functions
Conversion functions
Aggregate functions
Mathematical functions
Comparison functions
Bit functions
Flow control functions
Information functions
Encryption functions and compression functions
Window functions
Other functions
GROUPING SETS, ROLLUP, and CUBE extensions
Operator
Logical operators
Arithmetic operators
Comparison operators
Bitwise operators
Assignment operators
Operator precedence
Data types
Data types
Numeric data types
String data types
Collation types
Date and time data types
Practical SQL statements
TRACE
Cross-schema queries
Multiple statements
EXPLAIN and execution plans
Best Practice
Select instance specifications
Determine shard keys
Select the number of shards
Determine the time for selecting configuration upgrade
Choose a database connection pool for an application
Handle DDL exceptions
How to scan data efficiently
Determine the number of values in the IN clause of a query
Performance Metrics
Test the DRDS performance based on TPC-C
TPC-H test
Test the DRDS performance based on Sysbench
Sysbench user guide
API Reference
2019-01-23 Version
API overview
Request syntax
Common parameters
Signature method
Instance management
CreateDrdsInstance
DescribeDrdsInstance
DescribeDrdsInstances
RestartDrdsInstance
ModifyDrdsInstanceDescription
UpdateResourceGroupAttribute
Database management
CreateDrdsDB
CheckDrdsDbName
RemoveDrdsDbFailedRecord
RemoveDrdsDb
DescribeDrdsShardingDbs
DescribeDrdsDBs
DescribeDrdsDB
Storage resource management
DescribeRdsPerformanceSummary
DescribeRdsSuperAccountInstances
DescribeDrdsDBCluster
DescribeDrdsDbInstance
DescribeDrdsDbInstances
DescribeDrdsDbRdsNameList
ModifyRdsReadWeight
ModifyPolarDbReadWeight
ResetDrdsToRdsConnections
DescribeRDSPerformance
DescribeDbInstances
DescribeDbInstanceDbs
DescribeStorageInstanceSubDbInfo
DescribeRdsCommodity
GetDrdsDbRdsRelationInfo
Account management
CreateInstanceAccount
DescribeInstanceAccounts
RemoveInstanceAccount
Backup and restore
StartRestore
RemoveBackupsSet
DescribeBackMenu
DescribeBackupTimes
DescribeRestoreOrder
DescribeBackupDbs
PutStartBackup
SetBackupPolicy
EnableSqlFlashbackMatchSwitch
DescribeBackupSets
Networking and connectivity
Task management
Table sharding
ValidateShardTask
DescribeExpandLogicTableInfoList
DescribeShardTaskList
DatalinkReplicationPrecheck
CreateShardTask
DescribeShardTaskInfo
DeleteShardTasks
Broadcast Tables
DescribeBroadcastTables
DescribeGlobalBroadcastType
Table management
DescribeTable
DescribeTables
DescribeTableListByType
SetupTable
Tag and parameter settings
TagResources
UntagResources
ListTagResources
DescribeDrdsParams
SetupDrdsParams
Instance versions
DescribeDrdsInstanceVersion
RollbackInstanceVersion
UpgradeInstanceVersion
Monitor the performance
DescribeDrdsInstanceMonitor
DescribeDrdsInstanceDbMonitor
Other operations
DescribeDrdsDBIpWhiteList
ModifyDrdsIpWhiteList
DescribeInstanceSwitchAzone
DescribeDrdsSlowSqls
FAQ
Sharding
Data compatibility
Performance FAQ
all-products-head
This Product
This Product
All Products
All Products
Show more
Show less