Document Center
Search
Search by Current Product
remote login
data migration
reset password
MySQL
server
Document Center
ApsaraDB for RDS
ApsaraDB for RDS
Product Introduction
What is RDS
Benefits
Inexpensive and easy-to-use
High performance
High reliability
High security
Comparison between ApsaraDB for RDS and local databases
System architecture
Data link service
High-availability service
Backup and recovery service
Monitoring service
Scheduling service
Product editions
General introduction to product series
Basic Edition
Cluster Edition (AlwaysOn Edition)
Instance types
Instance type overview
Instance type list
Typical applications
Diversified data storage
Open search
Read/write splitting function
Big data analysis
RDS usage instructions
Purchase Guide
Billing items and billing methods
Billing details about configuration change
Renewal
Expiration and overdue payment
View purchase details
Quick Start for MySQL
Limits
General process to use RDS
Create an instance
Initial configuration
Set the whitelist
Apply for an Internet IP address
Create accounts and databases
Connect to an instance
Scale instances
Read-only instance
Introduction to read-only instances
Create a read-only instance
Disaster recovery instances
Quick Start for SQL Server
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set the whitelist
Apply for an Internet address
Creating accounts and databases
Create accounts and databases (SQL Server 2008 R2)
Create accounts and databases (SQL Server 2012 or 2016)
Create accounts and databases (SQL Server 2017)
Connect to an instance
Read-only instances
Introduction to read-only instances
Create a read-only instance
Function differences between SQL Server versions
API differences between SQL Server versions
Stored procedures
Quick Start for PostgreSQL
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set a whitelist
Create database and account
Connect to an instance
Read/write external data files using oss_fdw
Appendix
Appendix: User and schema management
Release notes
Apply for an Internet IP address
Quick Start for PPAS
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set a whitelist
Apply for an Internet IP address
Create databases and accounts
Connect to an instance
Read/write external data files using oss_fdw
Appendix
User and schema management
PPAS development driver
Appendix: PPAS compatibility description
Common management functions
User Guide
Preface
Quick start
Billing management
Change the billing method
Enable auto-renewal for a Subscription instance
Manually renew a Subscription instance
Instance management
Restart an instance
Configure the maintenance period
Migrate instance across zones
Switch between master and slave instances
Modify the data replication mode
Create a read-only instance
Release an instance
Upgrade the database version
RDS for MySQL release notes
Change configurations
SQL Server DBCC function
End connections for SQL Server instances
Set instance parameters
Set parameters through the RDS console
Use SQL commands to set parameters
Read/write splitting
Introduction to read/write splitting
Enable read/write splitting
Modify the latency threshold and read weights
Switch read/write splitting address type
Disable read/write splitting
Monitor read/write splitting performance
Test read/write splitting performance
Verify read/write splitting effect
Use SQL audit to verify read/write splitting effects
Use internal SQL statements to verify read/write splitting effects
Verify read weight distribution
Rules of weight distribution by system
Account management
Create an account
Reset the instance password
Change account permissions
Authorize a service account
Delete an account
Manage the LOGIN user for SQL Server instances
Manage users for SQL Server instances
Database management
Create a database
Delete a database
Copy a database for SQL Server
Copy data between instances
Copy a database to SQL Server 2008 R2
Copy a database to SQL Server 2012 or later
Manage databases of SQL Server instances
Connection management
Set the access mode
Set network type
Hybrid access solution for smooth migration from classic networks to VPCs
Set intranet and Internet addresses
Monitoring and Alarming
Set the monitoring frequency
Set monitoring rules
Database proxy
Database proxy overview
Brute-force attack prevention
Persistent connections
Transparent switching
Security
SQL audit
Switch the IP whitelist to enhanced security mode
Set whitelist
Set SSL encryption
Set TDE
Log management
Backup
Back up RDS data
View the free quota of the backup space
Download data and log backup files
Logical backup and recovery for PPAS
Recovery
Create a clone instance
Recover data directly to an instance
Recover data to the master instance through a temporary instance
Tag management
Create tags
Delete tags
Filter instances by tag
Data migration
Migrate from other cloud databases to ApsaraDB RDS
Use mysqldump to migrate MySQL data
Migrate RDS data to the local database
Migrate RDS for MySQL data to a local MySQL database
Migrate RDS for SQL Server data to a local SQL Server database
Migrate RDS for PostgreSQL data to a local PostgreSQL database
Migrate RDS for PPAS data to a local Oracle database
Migrate RDS for PPAS data to a local PPAS database
Compress data
Use psql to migrate PostgreSQL data
Migrate SQL Server to cloud
Migrate data to RDS for SQL Server 2008 R2
Migrate data to RDS for SQL Server 2012/2016
Migrate a MySQL database from Tencent Cloud to Alibaba Cloud
Migrate a MySQL database from Google Cloud to Alibaba Cloud
Typical applications
Cached data persistence
Multi-structure data storage
Appendix
Commonly used SQL statements for MySQL
View intranet/Internet IP addresses and port number of an instance
Performance White Paper
For MySQL
Product overview
Test approach
Test environment
Test tool
Test commands
Test model
Test indicators
For MySQL 5.6
Instance types
Test result
For SQL Server
Product 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
Security White Paper
Product overview
Security solutions
Access control
Network isolation
Data Encryption
Backup and recovery
Disaster tolerance
Software upgrade
Service authorization
Best Practices
MySQL
Precautions on comparing ECS user-created databases and ApsaraDB for RDS instances in terms of performance
Select and create an optimal index for faster data access
Parameter optimization for MySQL instances
SQL Server
Use SSMS and BCP to migrate a SQL Server database
PostgreSQL
CREATE DATABASE usage instructions
Set the localized information and string sorting rules for a database
Functions and usage of PostgreSQL UPSERT
Update, delete, and insert data in batches
Locate the SQL statements with the greatest resource consumption
API Reference
API overview
Use APIs
Public parameters
Request structure
Signature
Instance management
CreateDBInstance
DeleteDBInstance
RestartDBInstance
RenewInstance
View instance attributes
View the RDS instance list
Change the RDS instance type
View RDS region and zone information
View RDS zone information and data replication statuses
Migrate RDS instance zone
Clear RDS instance logs
Upgrade the database version of RDS instance
Modify the description of an RDS instance
Modify the RDS instance maintenance time
Modify the instance data replication mode and high availability switching rules
Switch between the master and slave databases of an RDS instance
Create a read-only instance
Database management
Create a database
Delete database
View the database list
Modify database remarks
Copy a database for SQL Server 2008 R2
Copy databases between instances
Read/Write splitting
Apply for a read/write splitting address
Check system-distributed weights
Modify the basic information of read/write splitting
Release a read/write splitting address
Account management
Create an account
Delete an account
View the account list
Grant account permissions
Revoke account permissions
Modify account description
Reset the instance password
Reset an account
Security management
View the IP address whitelist of an RDS instance
View SSL information
View the data encryption status of an instance
Modify SSL links of an instance
Modify the data encryption status of an instance
Modify the IP address whitelist of an RDS instance
Network management
Apply for an Internet connection string
View all connection strings
Change the expiration time of the original classic endpoint
Modify connection string
Modify the network type of an RDS instance
Release an internet connection string
Apply for an intranet connection string (Originally, switch between the intranet and Internet)
Log management
View the slow log list
View slow log details
View error logs
View binlogs
Query whether SQL audit is enabled
ModifySQLCollectorPolicy
Query SQL audit logs
Query the SQL audit file list
Backup and recovery
Create backup
Clone RDS instances
View the backup list
Create a temporary instance
View the backup policy
Modify the backup policy
Recover a backup set to an instance
Delete data backup files
View log files
Migrate SQL Server to the cloud
Create a task of migrating data to RDS
Get the task list of migrating data to RDS
Check the file details about the task of migrating data to RDS
Monitoring management
View instance resource usage
View instance performance data
Query monitoring behaviors
Modify monitoring behaviors
Parameter management
View database parameter templates
View the list of currently running instance database parameters
Modify the database parameter list
Data migration
Obtain a file upload address
View the database file list
View the import list
Migrate from other RDS instances
CancelImport
Tag management
Bind tags
Query tags
Unbind tags
Appendix
Client error code table
Server error code table
Instance status table
Performance parameter table
Forbidden keywords table
SDK Reference
SDK reference
FAQs
Database/account/table
Network/IP
Functions and billing methods
Technical Operation and Maintenance
Use MySQL
Use SQL Server
Use PostgreSQL
Network connection
Product Usage
Backup recovery
Console
Use DMS
Performance monitoring
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
Best practice of primary account security
Create an AccessKey
ICP Filing
Glossary
ApsaraDB for RDS
Product Introduction
Download PDF
What is RDS
Benefits
System architecture
Product editions
Instance types
Typical applications
RDS usage instructions
Show more
Show less
Purchase Guide
Download PDF
Billing items and billing methods
Billing details about configuration change
Renewal
Expiration and overdue payment
View purchase details
Show more
Show less
Quick Start for MySQL
Download PDF
Limits
General process to use RDS
Create an instance
Initial configuration
Connect to an instance
Scale instances
Show more
Show less
Quick Start for SQL Server
Download PDF
Limits
General procedure to use RDS
Create an instance
Initial configuration
Connect to an instance
Read-only instances
Function differences between SQL Server versions
API differences between SQL Server versions
Stored procedures
Show more
Show less
Quick Start for PostgreSQL
Download PDF
Limits
General procedure to use RDS
Create an instance
Initial configuration
Connect to an instance
Read/write external data files using oss_fdw
Appendix
Apply for an Internet IP address
Show more
Show less
Quick Start for PPAS
Download PDF
Limits
General procedure to use RDS
Create an instance
Initial configuration
Connect to an instance
Read/write external data files using oss_fdw
Appendix
Show more
Show less
User Guide
Download PDF
Preface
Quick start
Billing management
Instance management
Read/write splitting
Account management
Database management
Connection management
Monitoring and Alarming
Database proxy
Security
Log management
Backup
Recovery
Tag management
Data migration
Typical applications
Appendix
Show more
Show less
Performance White Paper
Download PDF
For MySQL
For SQL Server
Show more
Show less
Security White Paper
Product overview
Security solutions
Show more
Show less
Best Practices
MySQL
SQL Server
PostgreSQL
Show more
Show less
API Reference
Download PDF
API overview
Use APIs
Instance management
Database management
Read/Write splitting
Account management
Security management
Network management
Log management
Backup and recovery
Migrate SQL Server to the cloud
Monitoring management
Parameter management
Data migration
Tag management
Appendix
Show more
Show less
SDK Reference
SDK reference
Show more
Show less
FAQs
Database/account/table
Network/IP
Functions and billing methods
Show more
Show less
Technical Operation and Maintenance
Use MySQL
Use SQL Server
Use PostgreSQL
Network connection
Show more
Show less
Product Usage
Backup recovery
Console
Use DMS
Performance monitoring
Show more
Show less
Free Trial
Free Trial