Document Center
ApsaraDB for RDS
Product Introduction
What is ApsaraDB for RDS
Benefits
Low costs and easy-to-use
High performance
Disaster tolerance
High security
Comparison between ApsaraDB for RDS and local databases
Product series
Product series overview
Basic Edition
Cluster Edition (AlwaysOn Edition)
Instance types
Instance type overview
Instance type list
Storage types
Typical applications
Diversified data storage
Open search
Read/write splitting function
Big data analysis
RDS usage instructions
[Important] RDS network link upgrade
Purchase Guide
Billing methods and billing items
Billing details about configuration change
Renewal
Impact of expiration and overdue payment
View purchase details
Quick Start for MySQL
Limits
General process
Create an RDS for MySQL instance
Initial configuration
Set the whitelist
Apply for an Internet address
Create accounts and databases
Connect to an instance
Scale instances
Read-only instance
Introduction to MySQL read-only instances
Create a read-only instance
Quick Start for SQL Server
Limits
General process
Create an instance
Initial configuration
Set the whitelist
Apply for an Internet address
Creating accounts and databases
Create accounts and databases (SQL Server 2017)
Create accounts and databases (SQL Server 2012 or 2016)
Create accounts and databases (SQL Server 2008 R2)
Connect to an instance
Read-only instances
Introduction to SQL Server 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
Apply for an Internet address
Create database and account
Connect to an instance
Read/write external data files using oss_fdw
Appendix
Appendix: User and schema management
Release notes
Quick Start for PPAS
Limits
General procedure to use RDS
Create an instance
Initial configuration
Set a whitelist
Create databases and accounts
Apply for an Internet address
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
Quick Start for MariaDB TX
Create an instance
Initial configuration
Set the whitelist
Apply for an Internet IP address
Create accounts and databases
Connect to an instance
User Guide
Preface
Quick start
Data migration
Migrate from other cloud databases to ApsaraDB RDS
Use mysqldump to migrate MySQL data
Migrate data from self-hosted databases to RDS
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
Billing management
Change the billing method
Manually renew a Subscription instance
Enable auto-renewal for 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
Security
SQL audit
Switch the IP whitelist to enhanced security mode
Set the whitelist
Set SSL encryption
Set TDE
Log management
SQL explorer
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
Restore MySQL data
Restore MySQL databases or tables
Restore SQL Server Data
Restore PostgreSQL or PPAS data
Restore MariaDB data
Recover data to a temporary instance (RDS for SQL Server)
Tag management
Create tags
Delete tags
Filter instances by tag
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
Spatio-temporal Database
Introduction
Models
Geometry model
Raster model
Path model
Point cloud model
Trajectory model
Advanced usage
Enable GPU-accelerated computing
Enable spatio-temporal parallel query
Raster SQL reference
Basic concepts
Raster creation
ST_CreateRast
Import and export
ST_ImportFrom
ST_ExportTo
Pyramid operations
ST_BuildPyramid
Coordinate system conversion
ST_World2RastCoord
ST_Rast2WorldCoord
Image operations
ST_ClipDimension
ST_Clip
ST_Update
ST_MosaicFrom
ST_MosaicTo
ST_BestPyramidLevel
Auxiliary functions
ST_CheckGPU
Overview operations
ST_BuildOverview
ST_EraseOverview
ST_UpdateOverview
Attribute query and update
ST_MetaData
ST_Width
ST_Height
ST_NumBands
ST_RasterID
ST_CellDepth
ST_CellType
ST_InterleavingType
ST_TopPyramidLevel
ST_Extent
ST_Srid
ST_Georeference
ST_IsGeoreferenced
ST_NoData
ST_ColorTable
ST_Statistics
ST_SummaryStats
ST_ColorInterp
ST_Histogram
ST_BuildHistogram
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_boundingDiagonalGeometry
ST_compress
ST_envelopeGeometry
ST_explode
ST_filterBetween
ST_filterEquals
ST_filterGreaterThan
ST_filterLessThan
ST_isSorted
ST_patchAvg
ST_patchAvg
ST_patchMax
ST_patchMax
ST_patchMin
ST_pointN
ST_range
ST_setPcid
ST_sort
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
Constructor overview
ST_makeTrajectory
ST_append
Edit and process functions
ST_attrDeduplicate
ST_Compress
ST_CompressSED
ST_deviation
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_attrFloatFilter
ST_attrIntFilter
ST_attrNotNullFilter
ST_attrNullFilter
ST_attrTimestampFilter
ST_length
ST_trajAttrsAsBool
ST_trajAttrsAsDouble
ST_trajAttrsAsInteger
ST_trajAttrsAsText
ST_trajAttrsAsTimestamp
Spatial relationship judgment
ST_intersects
ST_distanceWithin
ST_equals
Spatial processing
ST_intersection
ST_difference
Spatial statistics
ST_nearestApproachPoint
ST_nearestApproachDistance
Spatio-temporal relationship judgment
ST_distanceWithin
ST_durationWithin
ST_equals
ST_intersects
Spatio-temporal processing
ST_intersection
Spatio-temporal statistics
ST_nearestApproachPoint
ST_nearestApproachDistance
Distance measurement
ST_euclideanDistance
ST_mdistance
Trajectory best practices
Trajectory FAQ
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
Use APIs
Public parameters
Request structure
Signature
Instance management
CreateDBInstance
DeleteDBInstance
RestartDBInstance
RenewInstance
DescribeDBInstanceAttribute
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
DestroyDBInstance
ModifyDBInstanceDelayReplicationTime
Database management
Create a database
Delete database
View the database list
Modify database remarks
CopyDatabase
Copy databases between instances
Read/Write splitting
AllocateReadWriteSplittingConnection
CalculateDBInstanceWeight
ModifyReadWriteSplittingConnection
ReleaseReadWriteSplittingConnection
Account management
CreateAccount
DeleteAccount
DescribeAccounts
GrantAccountPrivilege
RevokeAccountPrivilege
ModifyAccountDescription
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
DescribeBinlogFiles
Query whether SQL audit is enabled
ModifySQLCollectorPolicy
DescribeSQLLogRecords
DescribeSQLLogFiles
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
DescribeBackupTasks
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
ModifyDBInstanceMonitor
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
RAM authorization
Appendix
Client error code table
Server error code table
Instance status table
Performance parameter table
Forbidden keywords table
API overview
SDK Reference
SDK reference
FAQs
Network/IP
Functions and billing methods
Space/Memory
Technical Operation and Maintenance
Use MySQL
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
all-products-head
This Product
This Product
All Products
ApsaraDB for RDS
ApsaraDB for RDS
All Products
Product Introduction
Download PDF
What is ApsaraDB for RDS
Benefits
Product series
Instance types
Storage types
Typical applications
RDS usage instructions
[Important] RDS network link upgrade
Show more
Show less
Purchase Guide
Download PDF
Billing methods and billing items
Billing details about configuration change
Renewal
Impact of expiration and overdue payment
View purchase details
Show more
Show less
Quick Start for MySQL
Download PDF
Limits
General process
Create an RDS for MySQL instance
Initial configuration
Connect to an instance
Scale instances
Show more
Show less
Quick Start for SQL Server
Download PDF
Limits
General process
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
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
Quick Start for MariaDB TX
Create an instance
Initial configuration
Connect to an instance
Show more
Show less
User Guide
Download PDF
Preface
Quick start
Data migration
Billing management
Instance management
Read/write splitting
Account management
Database management
Connection management
Monitoring and Alarming
Security
Log management
SQL explorer
Backup
Recovery
Tag management
Typical applications
Appendix
Show more
Show less
Spatio-temporal Database
Download PDF
Introduction
Models
Advanced usage
Raster SQL reference
Point cloud SQL reference
Trajectory SQL reference
Trajectory best practices
Trajectory FAQ
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
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
RAM authorization
Appendix
API overview
Show more
Show less
SDK Reference
SDK reference
Show more
Show less
FAQs
Network/IP
Functions and billing methods
Space/Memory
Show more
Show less
Technical Operation and Maintenance
Use MySQL
Show more
Show less
Free Trial
Free Trial