Document Center
ApsaraDB for RDS
Promotions and Notifications
Release notes
[Notice] End of updates and maintenance for shared proxy starting from April 1, 2021
[Notice] End of service for ApsaraDB RDS for PPAS starting from May 1, 2021
[Notice] End of the provision of free snapshot backups to ApsaraDB RDS for PostgreSQL instances with standard or enhanced SSDs
[Notice] Migration of ApsaraDB for RDS instances
[Notice] The storage engine was switched from TokuDB to InnoDB
[Notice] The feature of restoring individual databases or tables has been released in Singapore since February 19
[Notice] Instance restoration in overwriting mode was disabled on February 25
[Important] RDS network link upgrade
Product Introduction
What is ApsaraDB for RDS?
Why choose ApsaraDB for RDS
Customized database engines
Cost effective and easy to use
High performance
High availability and disaster tolerance
High security
Competitive advantages of ApsaraDB RDS instances over self-managed databases
Product editions
Overview of ApsaraDB RDS editions
Basic Edition
High-availability Edition
Cluster Edition
Enterprise Edition
Product specifications
Instance families
Primary instance types
Read-only instance types
Storage types
Features
Q&A
Typical applications
Remote disaster recovery
Diversified data storage
Read/write splitting
Big data analysis
ApsaraDB for RDS usage notes
Purchase Guide
Price adjustments
Pricing, billable items, and billing methods
Specification change fees
Subscription renewal
Unlock or rebuild an expired or overdue ApsaraDB RDS instance
View the spending details of an ApsaraDB for RDS instance
Quick Start
Purchase guide
Quick Start
Dedicated cluster
Proprietary AliSQL
Overview of AliSQL features
Release notes of minor AliSQL versions
X-Engine
X-Engine overview
Usage notes
Convert tables from InnoDB, TokuDB, or MyRocks to X-Engine
Benefits of X-Engine
Feature
Thread Pool
Statement outline
Sequence Engine
Returning
Performance
Fast query cache
Binlog in Redo
Statement Queue
Inventory Hint
Stability
Faster DDL
Statement concurrency control
Performance Agent
Purge Large File Asynchronously
Performance Insight
Security
Data Protect
Recycle Bin
Best practices
Convert the storage engine of DRDS from InnoDB to X-Engine
DingTalk secures App Store top rank with X-Engine
Storage engine that processes trillions of Taobao orders
Use DMS to archive data to X-Engine
Best practices for X-Engine testing
Proprietary AliPG
AliPG benefits
Release notes of minor AliPG versions
Functional modules of AliPG
Plug-ins supported
Query vertical industry-specific data
Use the TimescaleDB plug-in
Use the smlar plug-in
Use the PASE plug-in
Use the roaringbitmap plug-in
Use the varbitx plug-in
Use the RDKit plug-in
Run cross-database queries
Read and write external data files by using oss_fdw
Use mysql_fdw to read and write data to a MySQL database
Use the log_fdw plug-in
Use the tds_fdw plug-in
Use the oracle_fdw plug-in
Use the dblink and postgre_fdw plug-ins for cross-database operations
Use the hll plug-in
Use the pg_cron plug-in to configure scheduled tasks
Use the PL/Proxy plug-in for horizontal sharding
Fuzzy query (PG_ bigm)
Use the wal2json plug-in
Use the ZomboDB plug-in to integrate with Elasticsearch
Use the sql_firewall plug-in
Use the failover slot feature for logical subscriptions
Use the pg_concurrency_control plug-in
Use the RUM plug-in
Use the fuzzystrmatch plug-in to compute similarity between strings
Use the pg_hint_plan plug-in to customize query plans
RDS MySQL Database
Overview of ApsaraDB RDS for MySQL
Limits of ApsaraDB RDS for MySQL
Memory management of an ApsaraDB RDS for MySQL instance
Features of ApsaraDB RDS for MySQL
Quick start
General workflow to use RDS for MySQL
Create an ApsaraDB RDS for MySQL instance
Set the whitelist
Control access to an ApsaraDB RDS for MySQL instance
Create accounts and databases for an ApsaraDB RDS for MySQL instance
Connect to an ApsaraDB RDS for MySQL instance
What do I do if I cannot connect an ECS instance to an ApsaraDB for RDS instance?
Data Migration
Overview of data migration
Create a PolarDB for MySQL cluster by using the Migration from RDS method
Create a PolarDB for MySQL cluster by using the Clone from RDS method
Data Migration from a User-created Database to an ApsaraDB RDS MySQL Instance
Migrate data from a user-created MySQL database to an ApsaraDB RDS for MySQL instance
Migrate data from a user-created Oracle database to an ApsaraDB RDS for MySQL instance
Migrate data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL database
Migrate data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance across Alibaba Cloud accounts
Migrate data from a user-created Db2 database to an ApsaraDB RDS for MySQL instance
Migrate data from a self-managed MySQL instance to an ApsaraDB RDS for MySQL instance by using mysqldump
Migrate data from a third-party cloud database to ApsaraDB for RDS
Migrate a MySQL database from Google Cloud to Alibaba Cloud
Migrate data from an Amazon RDS for MySQL instance to an ApsaraDB RDS for MySQL instance
Migrate data between ApsaraDB RDS for MySQL instances
Migrate data from an ApsaraDB RDS for MySQL database to a user-created MySQL database
Data Synchronization
Overview of data synchronization
Synchronize data from MySQL to MySQL
Configure one-way data synchronization between ApsaraDB RDS for MySQL instances
Configure two-way data synchronization between ApsaraDB RDS for MySQL instances
Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance
Synchronize data between ApsaraDB RDS for MySQL instances that belong to different Alibaba Cloud accounts
Synchronize data from an ApsaraDB RDS for MySQL instance to a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway
Synchronize data from an ECS-hosted user-created MySQL instance to an ApsaraDB RDS for MySQL instance
Synchronize data from MySQL to other databases
Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for MySQL cluster
Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a user-created Kafka cluster
Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance
Synchronize data from an ApsaraDB RDS MySQL instance to a MaxCompute project
Manage pending events
Instance Lifecycle
Create an ApsaraDB RDS for MySQL instance
Restart an ApsaraDB RDS for MySQL instance
Renew
Manually renew an ApsaraDB RDS for MySQL instance
Enable auto-renewal for an ApsaraDB RDS for MySQL instance
Release or unsubscribe from an ApsaraDB RDS for MySQL instance
Manage ApsaraDB RDS for MySQL instances in the recycle bin
Database connection
Connect to an ApsaraDB RDS for MySQL instance
Apply for or release a public endpoint for an ApsaraDB RDS for MySQL instance
Use DMS to log on to an ApsaraDB RDS for MySQL instance
Connect to an ApsaraDB RDS instance by using an application
View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for MySQL instance
Change the network type of an ApsaraDB RDS for MySQL instance
Switch an ApsaraDB RDS for MySQL instance to a new VPC and a new vSwitch
Configure the hybrid access solution for an ApsaraDB RDS for MySQL instance
Instance Change
Change the specifications of an ApsaraDB RDS for MySQL instance
Configure automatic storage expansion for an ApsaraDB RDS for MySQL instance
Perform a manual or automatic switchover of services between a primary ApsaraDB RDS for MySQL instance and its secondary instance
Reasons for primary/secondary switchovers
Set the maintenance window of an ApsaraDB RDS for MySQL instance
Migrate an ApsaraDB RDS for MySQL instance across zones in the same region
Change the data replication mode of an ApsaraDB RDS for MySQL instance
Switch an ApsaraDB RDS for MySQL instance from pay-as-you-go to subscription
Switch an ApsaraDB RDS for MySQL instance from subscription to pay-as-you-go
Version upgrade
Update the minor engine version of an ApsaraDB RDS for MySQL instance.
Upgrade the database engine version of an RDS MySQL instance
Instance parameters
Reconfigure the parameters of an ApsaraDB RDS for MySQL instance
Use a parameter template to manage parameters
Optimize parameters of an ApsaraDB RDS for MySQL instance
Backup
Back up an ApsaraDB RDS for MySQL instance
View the free quota for backup storage of an ApsaraDB RDS for MySQL instance
Download data and log backup files of an ApsaraDB RDS for MySQL instance
Back up an ApsaraDB RDS for MySQL instance across regions
Configure policies to delete binary log files from an ApsaraDB RDS for MySQL instance
Query data from the remote backup files of an ApsaraDB RDS for MySQL instance
Restoration
Overview of data recovery
Restore the data of an ApsaraDB RDS for MySQL instance
Restore individual databases and tables of an ApsaraDB RDS for MySQL instance
Restore the data of an ApsaraDB RDS for MySQL instance across regions
Use a physical backup file to restore an ApsaraDB RDS for MySQL instance to a user-created MySQL database
Restore the data of an ApsaraDB RDS for MySQL instance from a logical backup file to a self-managed MySQL instance
Read-only instances
Overview of read-only ApsaraDB RDS for MySQL instances
Create a read-only ApsaraDB RDS for MySQL instance
Set a replication delay for an RDS MySQL read-only instance
Disaster recovery instances
Create a disaster recovery ApsaraDB RDS for MySQL instance
Billing cases for disaster recovery instances
Performance optimization and diagnosis (autonomy service)
DAS overview
Diagnostics
Diagnostics
Sessions Management
Real-time Monitoring
Autonomy center
Capacity assessment
Storage Analysis
Deadlock analysis
Performance insight
Dashboard
Slow Query Logs
Full SQL statistics
Report
Monitoring and alerts
View the resource, engine, and deployment metrics of an ApsaraDB RDS for MySQL instance
Set the monitoring frequency of an ApsaraDB RDS for MySQL instance
Configure an alert rule for an ApsaraDB RDS for MySQL instance
Database proxy (read/write splitting)
Introduction to dedicated proxy
What are dedicated proxies?
Release notes of dedicated proxy versions
Billing for dedicated proxies
FAQ about dedicated proxies
Manage the dedicated proxy endpoints of an ApsaraDB RDS for MySQL instance
Read/write splitting
Enable the read/write splitting feature for an ApsaraDB RDS for MySQL instance
FAQ about read/write splitting
Set the connection pool type of an ApsaraDB RDS for MySQL instance
Enable the transaction splitting feature for an ApsaraDB RDS for MySQL instance
View the monitoring data of dedicated proxies on an ApsaraDB RDS for MySQL instance
Configure SSL encryption for a dedicated proxy endpoint on an ApsaraDB RDS for MySQL instance
Other features
Upgrade an ApsaraDB RDS for MySQL instance from shared proxy to dedicated proxy
Upgrade the dedicated proxy version of an ApsaraDB RDS for MySQL instance
Adjust the number of dedicated proxies on an ApsaraDB RDS for MySQL instance
Disable the dedicated proxy service for an ApsaraDB RDS for MySQL instance
Execute hints on an ApsaraDB RDS for MySQL instance
Account
Create an account on an ApsaraDB RDS for MySQL instance
Reset the password of an account on an ApsaraDB RDS for MySQL instance
Reset the permissions of the privileged account for an ApsaraDB RDS for MySQL instance
Authorize the service account of an ApsaraDB RDS for MySQL instance
Delete a standard account from an ApsaraDB RDS for MySQL instance
Account permission
Modify the permissions of a standard account on an ApsaraDB RDS for MySQL instance
Account permissions
Limit permissions of a specific IP address on a database
Authorize accounts to manage tables, views, and fields
System accounts
Database
Create a database on an ApsaraDB RDS for MySQL instance
Delete a database from an ApsaraDB RDS for MySQL instance
Data security
Switch an ApsaraDB RDS for MySQL instance to the enhanced whitelist mode
Configure a whitelist for an ApsaraDB RDS for MySQL instance
Configure SSL encryption on an ApsaraDB RDS for MySQL instance
Configure TDE for an ApsaraDB RDS for MySQL instance
Configure disk encryption for an ApsaraDB RDS for MySQL instance
Best practices for data security
Audit
SQL Explorer
Manage logs
View the event history of an ApsaraDB RDS for SQL Server instance
View the slow log details of an ApsaraDB RDS for MySQL instance
Tag
Bind tags to ApsaraDB RDS for MySQL instances
Unbind tags from an ApsaraDB RDS for MySQL instance
Use tags to filter ApsaraDB RDS for MySQL instances
MySQL
Best practices of X-Engine
Import data from Excel to ApsaraDB RDS for MySQL
Configure a cyclic event on an ApsaraDB RDS for MySQL instance
Select and create an optimal index for faster data access
Appendixes
Commonly used SQL statements for MySQL
Grant backup file download permissions to a RAM user with only read-only permissions
Cached data persistence
Multi-structure data storage
Authorize an ApsaraDB RDS for MySQL instance to access KMS
RDS SQL Server Database
Overview of ApsaraDB RDS for SQL Server
Limits of ApsaraDB RDS for SQL Server
Features of ApsaraDB RDS for SQL Server
Quick start
General workflow to use RDS SQL Server
Create an ApsaraDB RDS for SQL Server instance
Configure a whitelist for an ApsaraDB RDS for SQL Server instance
Create databases and accounts
Create accounts and databases for an ApsaraDB RDS instance that runs SQL Server 2012, 2016, 2017 SE, or 2019
Create accounts and databases for an ApsaraDB RDS instance that runs SQL Server 2008 R2
Create accounts and databases for an ApsaraDB RDS instance that runs SQL Server 2017 EE
Connect to an ApsaraDB RDS for SQL Server instance
Read-only instances
Overview of read-only ApsaraDB RDS for SQL Server instances
Create a read-only ApsaraDB RDS for SQL Server instance
Features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions
Stored procedures
Data migration
Data migration solutions
Migrate data from a user-created database to an RDS SQL Server database
Restore SQL Server backup data to the cloud
Migrate full backup data to ApsaraDB RDS for SQL Server 2008 R2
Migrate full backup data to ApsaraDB RDS for SQL Server 2012, 2014, 2016, 2017, or 2019
Migrate incremental backup data to ApsaraDB RDS for SQL Server 2012, 2014, 2016, 2017, or 2019
Migrate data from an on-premises SQL Server instance to an ApsaraDB RDS for SQL Server instance
Migrate the data of an ApsaraDB RDS for SQL Server database to an on-premises SQL Server database
Billing
Switch an ApsaraDB RDS for SQL Server instance from pay-as-you-go to subscription
Switch an ApsaraDB RDS for MySQL instance from subscription to pay-as-you-go
Manually renew an ApsaraDB RDS for SQL Server instance
Enable auto-renewal for an ApsaraDB RDS for SQL Server instance
Manage pending events
Version upgrade
Upgrade from Basic Edition to High-availability Edition
Upgrade an instance from SQL Server 2012 to SQL Server 2016
Upgrade a local SSD-based instance from SQL Server 2008 R2 to SQL Server 2012 or 2016
Instance
Create an ApsaraDB RDS for SQL Server instance
Change the specifications of an ApsaraDB RDS for SQL Server instance
Restart an ApsaraDB RDS for SQL Server instance
Perform a manual or automatic switchover of services between primary and secondary ApsaraDB RDS for SQL Server instances
Set the maintenance window of an ApsaraDB RDS for SQL Server instance
Migrate an ApsaraDB RDS for SQL Server instance across zones in the same region
Release or unsubscribe from an ApsaraDB RDS for SQL Server instance
DBCC features of ApsaraDB RDS for SQL Server
Reconfigure parameters for an RDS for SQL Server instance
Reconfigure parameters in the ApsaraDB for RDS console
Reconfigure parameters by using SQL commands
Manage ApsaraDB RDS for SQL Server instances in the recycle bin
Database connection
Connect to an ApsaraDB RDS for SQL Server instance
Apply for or release a public endpoint on an ApsaraDB RDS for SQL Server instance
View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for SQL Server instance
Use DMS to log on to an ApsaraDB for RDS instance
Configure a hybrid access solution to smoothly migrate an RDS instance from the classic network to a VPC
Change the network type of an ApsaraDB RDS for SQL Server instance
Kill connections of ApsaraDB RDS SQL Server
Read/write splitting
Read/write splitting overview
Create a read-only ApsaraDB RDS for SQL Server instance
Enable the read-only routing endpoint of an ApsaraDB RDS for SQL Server instance
Modify the read weights
Disable cluster management for an RDS SQL Server instance
Rules of weight distribution by the system
Account
Create an account for an RDS SQL Server instancy
Reset the password of an account on an ApsaraDB RDS for SQL Server instance
Modify the permissions of a standard account on an ApsaraDB RDS for SQL Server instance
Authorize a service account for an ApsaraDB RDS for SQL Server instance
Delete an account for an RDS SQL Server instance
Manage ApsaraDB RDS SQL Server logins
Manage ApsaraDB RDS SQL Server users
Database
Create a database on an ApsaraDB RDS for SQL Server instance
Delete a database from an ApsaraDB RDS for SQL Server instance
Change the character set collation and the time zone of system databases
Manage databases with SQL statements
Database replication
Copy a database of ApsaraDB RDS SQL Server 2012 or later
Copy a database of ApsaraDB RDS SQL Server 2008 R2
Copy database data between instances
Monitoring and alerts
View the resource and engine metrics of an ApsaraDB RDS for SQL Server instance
Set the monitoring frequency
Configure an alert rule for an ApsaraDB RDS for SQL Server instance
Data security
Configure a whitelist for an ApsaraDB RDS for SQL Server instance
Configure SSL encryption on an ApsaraDB RDS for SQL Server instance
Configure TDE for an ApsaraDB RDS for SQL Server instance
Configure disk encryption for an ApsaraDB RDS for SQL Server instance
Configure a distributed transaction whitelist for an ApsaraDB RDS for SQL Server instance
Audit
View the logs of an ApsaraDB RDS for SQL Server instance
View the event history of an ApsaraDB RDS for SQL Server instance
Backup
Back up an ApsaraDB RDS for SQL Server instance
Back up an ApsaraDB RDS for SQL Server instance across regions
View the free quota for backup usage of an ApsaraDB RDS for SQL Server instance
Download data and log backup files from an ApsaraDB RDS for SQL Server instance
Restoration
Restore the data of an ApsaraDB RDS for SQL Server instance
Restore the data of an ApsaraDB RDS for SQL Server instance across regions
Restore the data of an ApsaraDB RDS for SQL Server instance by using a temporary RDS instance
Log on to a temporary ApsaraDB RDS for SQL Server instance
Disable the database proxy mode on an ApsaraDB RDS for SQL Server instance
Tag
Create tags
Delete tags
Use tags to filter ApsaraDB RDS for SQL Server instances
Best practices
Create a linked server for an ApsaraDB RDS for SQL Server instance
Connect an ApsaraDB RDS for SQL Server instance to a user-created domain
Connect Kingdee K/3 WISE to ApsaraDB RDS for SQL Server
Use SSRS for an ApsaraDB RDS SQL Server instance
RDS PostgreSQL Database
Overview of ApsaraDB RDS for PostgreSQL
Limits of RDS PostgreSQL
Features of ApsaraDB RDS for PostgreSQL
Quick start
General workflow to use RDS PostgreSQL
Create an ApsaraDB RDS for PostgreSQL instance
Configure a whitelist for an ApsaraDB RDS for PostgreSQL instance
Create a database and an account on an ApsaraDB RDS for PostgreSQL instance
Connect to an ApsaraDB RDS for PostgreSQL instance
Data Migration
Overview of data migration
Migrate data between ApsaraDB for RDS instances
Migrate data from an ApsaraDB RDS for PostgreSQL database to an on-premises PostgreSQL database
Manually migrate data from a user-created PostgreSQL database to an ApsaraDB RDS for PostgreSQL database
Migrate the data of an ApsaraDB RDS for PostgreSQL instance from the ApsaraDB RDS for PostgreSQL console
Billing
Switch from pay-as-you-go billing to subscription billing
Switch an ApsaraDB RDS for MySQL instance from subscription to pay-as-you-go
Manually renew an ApsaraDB RDS for PostgreSQL instance
Enable auto-renewal for an ApsaraDB RDS for PostgreSQL instance
Manage pending events
SQL translation
Instance
Create an ApsaraDB RDS for PostgreSQL instance
Change the specifications of an ApsaraDB RDS for PostgreSQL instance
Upgrade the kernel version of an ApsaraDB RDS for PostgreSQL instance
Restart an ApsaraDB RDS for PostgreSQL instance
Manually or automatically switch over services between the RDS PostgreSQL master and slave instances
Set the maintenance window of an ApsaraDB RDS for PostgreSQL instance
Migrate an ApsaraDB RDS for PostgreSQL instance across zones in the same region
Release or unsubscribe from an ApsaraDB RDS for PostgreSQL instance
Reconfigure parameters for an RDS PostgreSQL instance
Set the protection level of an ApsaraDB RDS for PostgreSQL instance
Manage ApsaraDB RDS PostgreSQL instances that are in the recycle bin
RDS for PostgreSQL read-only instances
Overview of read-only ApsaraDB RDS for PostgreSQL instances
Create a read-only ApsaraDB RDS for PostgreSQL instance
Database connections
Connect to an ApsaraDB RDS for PostgreSQL instance
Apply for or release a public endpoint
Use DMS to log on to an ApsaraDB RDS for PostgreSQL instance
View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for PostgreSQL instance
Account
Create an account on an ApsaraDB RDS for PostgreSQL instance
Reset the password of an account on an ApsaraDB RDS for PostgreSQL instance
Permissions on system tables and views
Lock or delete an account from an ApsaraDB RDS for PostgreSQL instance
Authorize the service account of an RDS PostgreSQL instance
Database
Create a database on an ApsaraDB RDS for PostgreSQL instance
Delete a database from an ApsaraDB RDS for PostgreSQL instance
Change the time zone of an ApsaraDB RDS for PostgreSQL instance
Network, VPC, and VSwitch
Configure a hybrid access solution to smoothly migrate the database from the classic network to a VPC
Change the network type of an ApsaraDB RDS for PostgreSQL instance
Switch to a new VSwitch for an RDS PostgreSQL instance
Monitoring and alerts
View the resource and engine metrics of an ApsaraDB RDS for PostgreSQL instance
Set the monitoring frequency of an ApsaraDB RDS for PostgreSQL instance
Configure an alert rule on an ApsaraDB RDS for PostgreSQL instance
Data security
Configure data encryption for an RDS PostgreSQL instance
Configure a whitelist for an ApsaraDB RDS for PostgreSQL instance
Switch an ApsaraDB RDS for PostgreSQL instance to the enhanced whitelist mode
Create a fully encrypted database on an ApsaraDB RDS for PostgreSQL instance
Audit
Enable and disable SQL Audit (database audit) on an ApsaraDB RDS for PostgreSQL instance
View logs
View the event history of an ApsaraDB RDS for SQL Server instance
Backup
Back up an ApsaraDB RDS for PostgreSQL instance
View the free quota for backup storage of an ApsaraDB RDS for PostgreSQL instance
Download data and log backup files from an ApsaraDB RDS for PostgreSQL instance
Create a full backup of an ApsaraDB RDS for PostgreSQL instance
Create a logical backup for an ApsaraDB RDS for PostgreSQL instance
Restoration
Restore the data of an ApsaraDB RDS for PostgreSQL instance
Restore data from a logical backup file
Tag
Bind tags to ApsaraDB RDS for MySQL instances
Unbind tags from an ApsaraDB RDS for MySQL instance
Use tags to filter ApsaraDB RDS for MySQL instances
Best Practices
Migrate data from a user-created PostgreSQL database to an ApsaraDB RDS for PostgreSQL database
CREATE DATABASE usage instructions
Configure the collation of a database on an ApsaraDB RDS for PostgreSQL instance
Functions and usage of PostgreSQL UPSERT
Update, delete, and insert data in batches
Locate the SQL statements with the greatest resource consumption
Use event triggers to implement the DDL recycle bin, firewall, and incremental synchronization features
Configure automatic failover and read/write splitting
Logical subscription
Application Solutions
Second-level flashback for real-time disaster recovery
User preference recommendation system
Real-time precision marketing (user selection)
Use pgpool for read/write splitting in ApsaraDB RDS for PostgreSQL
Image recognition, face recognition, similarity-based retrieval, and similarity-based audience spotting
Use ShardingSphere to develop ApsaraDB RDS for PostgreSQL
RDS PPAS Database
Preface
Limits
Features of ApsaraDB RDS for PPAS
Quick start
General workflow to use RDS PPAS
Create an ApsaraDB RDS for PPAS instance
Configure a whitelist for an ApsaraDB RDS for PPAS instance
Create databases and accounts for an ApsaraDB RDS for PPAS instance
Connect to an ApsaraDB RDS for PPAS instance
Read-only instances
Overview of read-only ApsaraDB RDS for PPAS instances
Create an RDS PPAS read-only instance
Data migration
Use DTS to migrate PPAS data
Migrate data between ApsaraDB RDS for PPAS instances
Migrate data from an ApsaraDB RDS PPAS instance to an on-premises Oracle database
Migrate data from an ApsaraDB RDS PPAS instance to an on-premises PPAS database
Migrate data from the on-premises databases to the ApsaraDB for RDS instances
Billing
Switch an ApsaraDB RDS for PPAS instance from pay-as-you-go to subscription
Manually renew an ApsaraDB RDS for PPAS instance
Switch an ApsaraDB RDS for MySQL instance from subscription to pay-as-you-go
Configure auto-renewal for an ApsaraDB RDS for PPAS instance
Manage pending events
Instance
Create an ApsaraDB RDS for PPAS instance
Restart an ApsaraDB RDS for MySQL instance
Set the maintenance window of an ApsaraDB RDS instance
Migrate an ApsaraDB RDS for PPAS instance across zones
Switch over services between the RDS PPAS master and slave instances
Release an RDS PPAS instance
Change the configuration of an RDS PPAS instance
Modify the parameters of an ApsaraDB RDS for PPAS instance
Manage ApsaraDB RDS for PPAS instances in the recycle bin
Database connection
Connect to an ApsaraDB RDS for PPAS instance
Apply for or release a public endpoint for an ApsaraDB RDS for PPAS instance
Configure a hybrid access solution to smoothly migrate an RDS instance from the classic network to a VPC
Use DMS to log on to an ApsaraDB RDS for PPAS instance
View and modify the internal and public endpoints and ports of an ApsaraDB RDS for PPAS instance
Change the network type of an ApsaraDB RDS for PPAS instance
Account
Create an account on an ApsaraDB RDS for PPAS instance
Reset the password of an account on an ApsaraDB RDS for PPAS instance
Database
Create a database on an ApsaraDB RDS for PPAS instance
Delete a database from an ApsaraDB RDS for PPAS instance
Monitoring and alerts
View resource monitoring data
Set the monitoring frequency
Configure alert rules for an ApsaraDB RDS for PPAS instance
Data security
Switch an ApsaraDB RDS for PPAS instance to the enhanced whitelist mode
Configure an IP address whitelist on an ApsaraDB RDS for PPAS instance
Audit
Enable and disable SQL Audit (database audit) on an ApsaraDB RDS for PPAS instance
View the event history of an ApsaraDB RDS for SQL Server instance
Backup
Back up an ApsaraDB RDS for PPAS instance
View the free quota for backup storage of an ApsaraDB RDS for PPAS instance
Download the backup files of an RDS PPAS instance
Create a logical backup and restore data from a logical backup
Restoration
Restore the data of an ApsaraDB RDS for PPAS instance
Manage logs
Tag
Bind tags to ApsaraDB RDS for MySQL instances
Use tags to filter ApsaraDB RDS for MySQL instances
Unbind tags from an ApsaraDB RDS for MySQL instance
Plug-ins
Plug-ins supported
Read and write external data files by using the oss_fdw plugin
PPAS development driver
Common management functions
Appendix: PPAS compatibility description
RDS MariaDB TX Database
Preface
Limits of RDS MariaDB
Features of ApsaraDB RDS for MariaDB TX
Quick start
General workflow to use RDS MariaDB
Creates an ApsaraDB RDS for MariaDB instance
Configure a whitelist for an ApsaraDB RDS for MariaDB TX instance
Create a database and account on an ApsaraDB RDS for MariaDB instance
Connect to an ApsaraDB RDS for MariaDB instance
Data migration
Migrate data from an on-premises MariaDB database to an ApsaraDB RDS for MariaDB TX instance by using mysqldump
Migrate data between RDS MariaDB instances
Billing
Change the billing method of an ApsaraDB RDS for MariaDB instance from pay-as-you-go to subscription
Manually renew an ApsaraDB RDS for MariaDB instance
Switch an ApsaraDB RDS for MySQL instance from subscription to pay-as-you-go
Enable auto-renewal for an ApsaraDB RDS for MariaDB TX instance
Manage pending events
Instance
Creates an ApsaraDB RDS for MariaDB instance
Restart an ApsaraDB RDS for MySQL instance
Set the maintenance window of an ApsaraDB RDS instance
Switch over services between the master and slave RDS MariaDB instances
Release an RDS MariaDB instance
Change the configuration of an RDS MariaDB instance
Modify parameters for an RDS for MariaDB instance
Manage ApsaraDB RDS for MySQL instances that are in the recycle bin
Database connection
Connect to an ApsaraDB RDS for MariaDB instance
Apply for or release a public endpoint for an ApsaraDB RDS for MariaDB TX instance
View and change internal and public endpoints and ports
Account
Create an account on an ApsaraDB RDS for MariaDB instance
Reset the password of an account on an ApsaraDB RDS for MariaDB TX instance
Modify the permissions of a standard account on an ApsaraDB RDS for MariaDB TX instance
Delete an account for an RDS MariaDB instance
Database
Create a database on an ApsaraDB RDS for MariaDB TX instance
Delete a database from an ApsaraDB RDS for MariaDB TX instance
Monitoring and alerts
View the resource and engine metrics of an ApsaraDB RDS for MariaDB instance
Set the monitoring frequency
Configure alert rules for an ApsaraDB RDS for MariaDB TX instance
Data security
Switch an ApsaraDB RDS for MariaDB TX instance to the enhanced whitelist mode
Configure a whitelist for an ApsaraDB RDS for MariaDB instance
Backup
Automatically back up the data of an RDS MariaDB instance
View the free quota for backup storage of an ApsaraDB RDS for MariaDB TX instance
Download the log backup files of an RDS MariaDB instance
Restoration
Restore data of an RDS for MariaDB instance
Manage logs
View the event history of an ApsaraDB RDS for SQL Server instance
Tag
Use tags to filter ApsaraDB RDS for MySQL instances
Unbind tags from an ApsaraDB RDS for MySQL instance
Bind tags to ApsaraDB RDS for MySQL instances
Spatio-temporal Database
Overview
Release notes of Ganos
Models
Geometry model
Raster model
Path model
Point cloud model
Trajectory model
Grid model
Vector pyramid
Advanced usage
Enable spatio-temporal two-phase query optimization
Enable spatio-temporal parallel query
Enable GPU-accelerated computing
Raster SQL reference
Concepts
Raster creation
ST_CreateRast
Import and export
ST_ImportFrom
ST_ExportTo
ST_AsImage
ST_AsPNG
ST_AsJPEG
Pyramid operations
ST_BuildPyramid
ST_deletePyramid
ST_BestPyramidLevel
Coordinate system conversion
ST_Rast2WorldCoord
ST_World2RastCoord
Pixel value operations
ST_ClipDimension
ST_Clip
ST_ClipToRast
ST_Values
ST_AddZ
ST_Update
S​T_MosaicFrom
S​T_MosaicTo
Overview operations
ST_BuildOverview
ST_UpdateOverview
S​T_EraseOverview
DEM operations
ST_Slope
ST_Hillshade
ST_Flow_direction
ST_Aspect
ST_Overflow
Attribute query and update
ST_Name
ST_SetName
ST_MetaData
ST_Width
ST_Height
ST_NumBands
ST_Value
ST_RasterID
ST_CellDepth
ST_CellType
ST_InterleavingType
ST_TopPyramidLevel
ST_Extent
ST_Srid
ST_ConvexHull
ST_SetSrid
ST_Envelope
ST_ScaleX
ST_Georeference
ST_IsGeoreferenced
ST_ScaleY
ST_UnGeoreference
ST_SetScale
ST_SkewX
ST_SetGeoreference
ST_SkewY
ST_NoData
ST_SetSkew
ST_SetNoData
ST_ColorTable
ST_UpperLeftX
ST_SetColorTable
ST_UpperLeftY
ST_Statistics
ST_SetUpperLeft
ST_SetStatistics
ST_PixelWidth
ST_SummaryStats
ST_PixelHeight
ST_ColorInterp
ST_SetColorInterp
ST_Histogram
ST_SetHistogram
ST_BuildHistogram
ST_StatsQuantile
ST_Quantile
ST_MD5Sum
ST_SetMD5Sum
ST_XMin
ST_YMin
ST_XMax
ST_YMax
ST_ChunkHeight
ST_ChunkWidth
ST_ChunkBands
ST_MetaItems
ST_SetMetaData
ST_BeginDateTime
ST_EndDateTime
ST_SetBeginDateTime
ST_SetEndDateTime
ST_DateTime
ST_SetDateTime
Algebra and Analysis Functions
ST_MapAlgebra
ST_Reclassify
Raster Image Processing
ST_Resize
ST_SubRaster
ST_Transform
ST_Rescale
Operators
Greater than or equal to operator (>=)
Equal to operator (=)
Greater than operator (>)
Less than or equal to operator (<=)
Less than operator (<)
Functions for Identifying Spatial Relationships
ST_ContainsProperly
ST_Contains
ST_CoveredBy
ST_Covers
ST_Disjoint
ST_Intersects
ST_overlaps
ST_Touches
ST_Within
Auxiliary functions
ST_AKId
ST_SetAccessKey
ST_SetAKId
ST_SetAKSecret
ST_CheckGPU
SpatialRef SQL reference
ST_SrEqual
ST_SrReg
ST_SrFromEsriWkt
Point cloud SQL reference
Constructors
ST_makePatch
ST_makePoint
ST_Patch
Attribute functions
ST_asText
ST_get
ST_numPoints
ST_pcID
ST_summary
Object operations
ST_patchMin
ST_patchMax
ST_isSorted
ST_sort
ST_boundingDiagonalGeometry
ST_compress
ST_envelopeGeometry
ST_explode
ST_filterBetween
ST_filterEquals
ST_filterGreaterThan
ST_filterLessThan
ST_patchAvg
ST_patchAvg
ST_patchMax
ST_patchMin
ST_pointN
ST_range
ST_setPcid
ST_transform
ST_unCompress
ST_union
OGC WKB operations
ST_asBinary
ST_boundingDiagonalAsBinary
ST_envelopeAsBinary
Spatial relationship judgment
ST_intersects
Spatial processing
ST_intersection
Trajectory SQL reference
Basic concepts
Constructors
Overview
ST_makeTrajectory
ST_append
Edit and process functions
ST_CompressSED
ST_deviation
ST_attrDeduplicate
ST_Compress
ST_sort
Attribute metadata
ST_attrDefinition
ST_attrLength
ST_attrName
ST_attrNullable
ST_attrSize
ST_attrType
Event functions
ST_addEvent
ST_eventTime
ST_eventTimes
ST_eventType
ST_eventTypes
Attribute functions
ST_startTime
ST_endTime
ST_trajectorySpatial
ST_trajectoryTemporal
ST_trajAttrs
ST_attrIntMax
ST_attrIntMin
ST_attrIntAverage
ST_attrFloatMax
ST_attrFloatMin
ST_attrFloatAverage
ST_leafType
ST_leafCount
ST_duration
ST_timeAtPoint
ST_pointAtTime
ST_velocityAtTime
ST_accelerationAtTime
ST_timeToDistance
ST_timeAtDistance
ST_cumulativeDistanceAtTime
ST_timeAtCumulativeDistance
ST_subTrajectory
ST_subTrajectorySpatial
ST_samplingInterval
ST_attrIntFilter
ST_attrTimestampFilter
ST_attrFloatFilter
ST_attrNotNullFilter
ST_attrNullFilter
ST_trajAttrsAsBool
ST_trajAttrsAsDouble
ST_trajAttrsAsInteger
ST_trajAttrsAsText
ST_trajAttrsAsTimestamp
ST_trajAttrsMeanMax
Functions to process bounding boxes
ST_MakeBox
ST_MakeBox{Z|T|2D|2DT|3D|3DT}
ST_BoxndfToGeom
ST_Has{xy|z|t}
ST_{X|Y|Z|T}Min
ST_{X|Y|Z|T}Max
ST_ExpandSpatial
Operators to process bounding boxes
Basic concepts
INTERSECT operators
INCLUDE operators
INCLUDED operators
Spatial relationship judgment
ST_equals
ST_intersects
ST_distanceWithin
Spatial processing
ST_intersection
ST_difference
Spatial statistics
ST_nearestApproachPoint
ST_nearestApproachDistance
Spatio-temporal relationship judgment
ST_intersects
ST_equals
ST_distanceWithin
ST_durationWithin
ST_{Z|T|2D|2DT|3D|3DT}Intersects
ST_{2D|2DT|3D|3DT}Intersects_IndexLeft
ST_{2D|2DT|3D|3DT}DWithin
ST_{2D|2DT|3D|3DT}DWithin_IndexLeft
ST_{T|2D|2DT|3D|3DT}Contains
ST_{T|2D|2DT|3D|3DT}Within
Spatio-temporal processing
ST_intersection
Spatio-temporal statistics
ST_nearestApproachPoint
ST_nearestApproachDistance
Distance measurement
ST_length
ST_euclideanDistance
ST_mdistance
Similarity analysis
ST_lcsSimilarity
ST_lcsDistance
ST_lcsSubDistance
Indexing
GiST indexing
TrajGiST indexing
Variables
ganos.trajectory.attr_string_length
GeomGrid SQL reference
Usage notes
Functions for output
ST_AsText
ST_AsBinary
ST_AsGeometry
ST_AsBox
Functions for input
ST_GridFromText
ST_GridFromBinary
Functions to query spatial relationships
ST_Intersects
ST_Contains
ST_Within
Operators
@>
<@
Functions to compute grids
ST_AsGrid
Geometry Pyramid SQL reference
Usage notes
Functions to build pyramids
ST_BuildPyramid
Functions to delete pyramids
ST_DeletePyramid
Functions to view pyramids
ST_Tile
Map services
Overview
Publish geometry data
Publish raster data
Desktop applications
Use uDig to access Ganos data
Use QGIS to access Ganos data
Use OpenJump to access Ganos data
FAQ
Load raster data
Load vector data
Trajectory FAQ
Best practice
Trajectory best practices
Performance White Paper
RDS for MySQL
ApsaraDB RDS for MySQL performance overview
Test guidelines
Test details
Test environment
Test scenarios
Test tools
Test procedure
Test metrics
Test results of ApsaraDB RDS for MySQL 8.0
Test results of ApsaraDB RDS for MySQL 5.7
Test results of ApsaraDB RDS for MySQL 5.6
RDS for SQL Server
ApsaraDB RDS for SQL Server performance overview
Test approach
Test environment
Test tool
Test approach
Test model
Test indicators
Test result
SQL Server 2008 R2 High-Availability Edition
SQL Server 2012 Enterprise edition
RDS for PostgreSQL
ApsaraDB RDS for PostgreSQL performance overview
Test method
Test environment
Test tool
Test metrics
Test procedure
Test result
RDS for PPAS
ApsaraDB RDS for PPAS performance overview
Test method
Test environment
Test tool
Test procedure
Test metrics
Test result
Considerations for performance comparison between a user-created database and an ApsaraDB for RDS instance
Security White Paper
Performance overview
Attack protection
Access control
Network isolation
Data encryption
Backup and restoration
Instance disaster tolerance
Software upgrade
Service Authorization
Best Practices
Overview of best practices
Build a high availability architecture
Use DMS to import a logical backup file into an ApsaraDB for RDS instance
Authorize a RAM user to manage ApsaraDB for RDS instances
Use DTS to perform vertical splitting on a database
API Reference
API overview
Request structure
Signature
Public parameters
RAM authorization
Billing
Query available resources
Queries renewal fees
Change billing method
Manually renew an ApsaraDB for RDS instance
Instance management
Create instance
Release instance
Restart an ApsaraDB for RDS instance
Change instance configuration
Query available zones
Query instance details
Query ApsaraDB for RDS instances
Query available regions and zones
Migration zone
Change instance name
Modify the maintenance time
Version upgrade
Upgrade database engine version
Upgrade minor version
Change the method to update the minor version
Database Connection
Apply for public endpoint
Query endpoints
Modify the endpoint and port of an ApsaraDB for RDS instance
Change the expiration time of a classic network endpoint
Switch between internal and public endpoints
Release a public endpoint
Change the network type of an ApsaraDB for RDS instance
Primary/Secondary High Availability and Data Replication
Change the high availability mode and data replication mode
Query high availability mode
Switch services between a primary ApsaraDB for RDS instance and its secondary instance
Enable or disable automatic primary/secondary switchover
Query settings of automatic primary/secondary switchover
Event History
Query events of ApsaraDB for RDS instances in a region
Query status of the event history feature
Enable or disable the event history feature
Account management
Create account
Delete database account
Reset account password
Lock account
Unlock account
Query accounts
Modify the description of a database account
Account permission
Grant permissions to account
Revoke database access permissions of an account
Reset permissions of the privileged account
Database management
Create database
Delete database
Modify the database description
Copy database
Query databases
Query collations and time zones
Read-Only Instances
Create read-only instance
Query latency between a primary ApsaraDB for RDS instance and its read-only instance
Modify replication latency of read-only RDS instance
Shared proxy (phased-out)
Apply for read-only routing endpoint
Release read/write splitting endpoint
Query read weights
Modify read weights and latency threshold
Query shared proxy settings
Dedicated proxy (read/write splitting)
Enable or disable the Dedicated Proxy feature
Modify settings of a dedicated proxy
Modify dedicated proxy endpoint
Query dedicated proxy details
Query the endpoint of the dedicated proxy
Query performance metrics of a dedicated proxy
Create proxy endpoint
Modify proxy endpoint
Delete proxy endpoint
Configure SSL encryption for dedicated proxy endpoint
Query SSL encryption settings of dedicated proxy endpoint
Security management
Query ECS security groups to which an ApsaraDB for RDS instance is added
Change the ECS security group for an ApsaraDB for RDS instance
Query IP address whitelists
Modify IP address whitelist
Query SSL settings
Modify settings of SSL encryption
Query settings of TDE
Enable the TDE function
Switch the network isolation mode from standard whitelist to enhanced whitelist
Query the hostname of an ApsaraDB for RDS instance
Query distributed transaction whitelists
Configure a distributed transaction whitelist
Log management
Query SQL Explorer (SQL Audit) status
Enable or disable SQL Explorer (SQL Audit)
Query SQL Explorer (SQL audit) logs
Query SQL Explorer (SQL audit) files
Modify retention period of SQL Explorer logs
Query the log retention period allowed for the SQL explorer feature
Query error logs
Query slow query logs
Query summary of slow query logs
Clear logs
Backup and recovery
Create backup set
Query backup sets
Query backup settings
Modify backup settings
Delete backup sets
Query backup tasks
Query log backup files
Restoration
Restore databases
Clone instance
Create a temporary instance
Query the time range for restoration
Restore individual databases or tables
Cross-region backup and restoration
Check whether an ApsaraDB for RDS instance can be restored across regions
Create disaster recovery instance
Modify cross-region backup settings
Query cross-region backup settings
Query cross-region data backup files
Query cross-region log backup files
Query regions that support cross-region backup
Query the time range to which you can restore data by using a cross-region backup set
Query ApsaraDB for RDS instances on which cross-region backup is enabled
Migrate SQL Server to the cloud
Open the database to which backup data is migrated
Query backup data files of migration task
Query migration tasks
Create a migration task
Monitoring management
Query storage usage
Query performance metrics
Query the monitoring frequency of an ApsaraDB for RDS instance
Change the monitoring frequency
Parameter management
Query parameter configurations
Modify parameters of an ApsaraDB for RDS instance
Query parameter configuration logs
Query the parameter template of an ApsaraDB for RDS instance
Create a parameter template
Modify a parameter template
Copy a parameter template
Query parameter templates
Query information of a parameter template
Delete a parameter template
Data migration
Migrate data across instances
Cancel migration task
Tag management
Create and bind tags
Unbind tags
Query tags
Appendix
Client error codes
Server error code table
Instance state table
Performance parameter table
Forbidden keywords table
SDK Reference
SDK reference
Install and use RDS SDK for Python
Install and use RDS SDK for Java
FAQs
FAQ overview
Purchases and Payments
Connections and Networks
Migration and Synchronization
Backup and Restoration
Read-only Instances and Read/Write Splitting
Performance
Accounts
Databases
Logs
SQL
Parameters
General Reference
Guidelines for the use of documentation
Alibaba Cloud documentation
Instructions for open source documentation
Open-Source Documentation Code of Conduct
Editing Open-Source Documentation
Alibaba Cloud console
Regions and zones
Service limits
Create an AccessKey pair
ICP Filing
Glossary
All Products
Search
Document Center
ApsaraDB for RDS
FAQs
SQL
This Product
This Product
All Products
ApsaraDB for RDS
What do I do if my ApsaraDB RDS for MySQL instance reports Error 1709?
How to use postgres_fdw and the dblink plugin to implement cross-database query in apsaradb RDS for PostgreSQL
Apsaradb RDS for MySQL uses the utf8mb4 character set to store emoticons
"OPERATION need to be executed set by ADMIN" is displayed when you call the RDS Database after installing the ThinkSNS website
The system prompts "Out of resources when opening file './xxx.MYD' (Errcode: 24)" error when using an RDS MySQL instance
Solution to the error "the table '/home /MySQL /xxxx/xxxx/#tab_name' is full" appears in RDS mysql
The error message "relation" xxx "already exists" is returned when apsaradb RDS for PostgreSQL modifies the uppercase table name
"SELECT command denied to user 'username '@' ip' for table 'user '" error when using apsaradb RDS for MySQL
RDS MySQL prompts "Specified key was too long; max key length is 767 bytes"
The query is inaccurate because the decimal field of apsaradb for MySQL is too large.
Issues related to the group_concat function in apsaradb RDS for MySQL instances
Free Trial
Free Trial