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
Cheap and ease-to-use
High performance
High security
High reliability
Comparison between ApsaraDB for RDS and local databases
System architecture
Data link service
High-availability service
Backup and recovery service
Monitoring service
Scheduling service
Migration service
Concept and terminology
RDS usage instructions
Product editions
General introduction to product series
Basic Edition
Instance types
Instance type overview
Dedicated instance
Instance type list
Typical applications
Diversified data storage
Read/write splitting function
Purchase Guide
Billing items and billing methods
Billing details for configuration change
Renewal
Expiration and overdue payment
Quick Start for MySQL
Limits
General process
Create an instance
Initial configuration
Set whitelist
Apply for an Internet address
Create database and account
Create account and database for MySQL 5.7 High-availability Edition/5.5/5.6 instances
Create account and database for MySQL 5.7 Basic Edition
Create master account
Connect to an instance
Scale instances
Read-only instance
Introduction to read-only instance
Create a read-only instance
Manage read-only instances
Quick Start for SQL Server
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set whitelist
Apply for an Internet address
Create database and account
Create database and account for SQL Server 2008 R2
Create account and database for SQL Server 2012 and 2016
Connect to an instance
Function differences between SQL Server versions
API differences between SQL Server versions
Quick Start for PostgreSQL
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set a whitelist
Apply for an Internet address
Create database and account
Connect to an instance
Read/write the external data files using oss_fdw
Appendix
Appendix: User and schema management
Release notes
Quick Start for PPAS
Limits
Process overview
Create an instance
Initial configuration
Set whitelist
Apply for an Internet address
Create database and account
Connect to an instance
Appendix
User and schema management
PPAS development driver
Appendix: PPAS compatibility description
Management functions
User Guide
Preface
Quick start
Introduction to RDS console
Logon and logout
The homepage of RDS console
The instance management interface for MySQL
The instance management interface for SQL Server
The instance management interface for PostgreSQL
The instance management interface for PPAS
Instance management
Restart an instance
Change billing method
Configure the maintenance period
Instance migration across zones
Switch master/slave instance
Modify the data replication mode
Release an instance
Upgrade the database
Manually renew the subscription instance
Enable auto-renewal of the subscription instance
Change configurations
SQL Server DBCC function
End connection for SQL Server instances
Set instance parameters
Set parameters through RDS console
Use SQL commands to set parameters
Account management
Create an account
Reset instance password
Change account permissions
Authorize a service account
Delete an account
LOGIN user management of SQL Server instances
User management of SQL Server instances
Read/write splitting
Introduction to read/write splitting
Enable read/write splitting
Modify the latency threshold and read weight distribution
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 internal SQL commands to verify the read/write splitting effect
Verify read weight distribution
Rules of weight distribution by system
Database management
Create a database
Delete a database
Copy a database for SQL Server
Copy a database for SQL Server 2008 R2
Copy a database for SQL Server 2012 or later versions
Database management of SQL Server instances
Network management
Set access mode
Set network types
Hybrid access solution for the seamless migration from classic network to VPC
Set intranet and Internet addresses
Security management
Set whitelist
Set SSL encryption
Set Transparent Data Encryption
Monitoring and Alarms
Set monitoring frequency
Set monitoring rules
Log management
Linked server of SQL Server instances
Backup and recovery
Recover MySQL data
Recovering from a clone or temporary instance to a primary instance
Recover data directly to the master instance
Recover SQL Server/PPAS/PostgreSQL data
Recover data directly to the master instance
Back up RDS data
View the free quota of the backup space
Download RDS data and log backup
Create a clone instance
Logical backup and recovery for PPAS
Tag management
Create tags
Delete tags
Filter instances by tag
Data migration
Use mysqldump to migrate MySQL data
Migrating RDS data to the local database
Migrate RDS for PPAS to local Oracle
Migrate RDS for MySQL data to the local MySQL database
Migrate RDS for SQL Server data to the local SQL Server database
Migrate RDS for PostgreSQL data to the local PostgreSQL database
Migrate RDS for PPAS to local PPAS
Compress data with TokuDB for MySQL 5.6
Use the psql command to migrate PostgreSQL data
Migrate SQL Server to cloud
Migrate data to ApsaraDB for RDS SQL Server 2008 R2
Migrate data to ApsaraDB for RDS SQL Server 2012/2016
Typical applications
Cached data persistence
Multi-structure data storage
Appendix
Commonly used SQL commands for MySQL
View instance intranet/Internet address and port number
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
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
Use APIs
API overview
Public parameters
Request structure
Signature
API Reference
Instance management
CreateDBInstance
DeleteDBInstance
RestartDBInstance
DescribeDBInstanceAttribute
View RDS instance list
Change the RDS instance type
Modify the RDS instance access mode
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 RDS instance maintenance time
Switch between the master and slave databases of an RDS instance
Create an RDS read-only instance
Database management
Create database
Delete database
View the database list
Modify database remarks
Copy a database for SQL Server 2008 R2
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
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
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
Get a file upload address
View the database file list
View the import list
Migrate from other RDS instances
Cancel migration
Schedules
Client error code table
Server error code table
Instance status table
Performance parameter table
Forbidden keywords table
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
Network management
Apply for an Internet connection string
View all connection strings
Modify connection string
Change the expiration time of the original classic endpoint
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)
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
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
Tag management
Bind tags
Query tags
Unbind tags
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
ICP Filing
Create an AccessKey
Glossary
ApsaraDB for RDS
Product Introduction
Download PDF
What is RDS
Benefits
System architecture
Concept and terminology
RDS usage instructions
Product editions
Instance types
Typical applications
Show more
Show less
Purchase Guide
Download PDF
Billing items and billing methods
Billing details for configuration change
Renewal
Expiration and overdue payment
Show more
Show less
Quick Start for MySQL
Download PDF
Limits
General process
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
Function differences between SQL Server versions
API differences between SQL Server versions
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 the external data files using oss_fdw
Appendix
Show more
Show less
Quick Start for PPAS
Limits
Process overview
Create an instance
Initial configuration
Connect to an instance
Appendix
Show more
Show less
User Guide
Download PDF
Preface
Quick start
Introduction to RDS console
Instance management
Account management
Read/write splitting
Database management
Network management
Security management
Monitoring and Alarms
Log management
Linked server of SQL Server instances
Backup and 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
Use APIs
API Reference
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