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
High-availability Edition
Cluster Edition (AlwaysOn Edition)
Instance types
Instance type overview
Instance type list
Storage types
Typical applications
Remote disaster recovery
Diversified data storage
Open search
Read/write splitting function
Big data analysis
RDS usage instructions
[Notice] Supplementary service agreement for RDS for SQL Server 2008 R2
[Important] RDS network link upgrade
Purchase Guide
Billing methods and billable 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
Configure a whitelist
Apply for an Internet address
Create accounts and databases
Connect to an RDS for MySQL instance
Scale instances
Read-only instance
Introduction to MySQL read-only instances
Create an RDS for MySQL read-only instance
Quick Start for SQL Server
Limits
General process
Create an RDS for SQL Server instance
Initial configuration
Configure a whitelist
Apply for an Internet address
Creating accounts and databases
Create databases and accounts for an RDS for SQL Server 2017 instance
Create databases and accounts for an RDS for SQL Server 2012 or 2016 instance
Create databases and accounts for an RDS for SQL Server 2008 R2 instance
Connect to an RDS for SQL Server instance
Read-only instances
Introduction to SQL Server read-only instances
Create an RDS for SQL Server read-only instance
Function differences between SQL Server versions
Stored procedures
Quick Start for PostgreSQL
Limits
General procedure to use RDS
Create an instance
Initial configuration
Configure 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 RDS for PPAS instance
Initial configuration
Configure 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
Apply for an Internet address
Quick Start for MariaDB TX
Create an RDS for MariaDB TX instance
Initial configuration
Configure a whitelist
Apply for an Internet address
Create accounts and databases
Connect to an RDS for MariaDB TX 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 user-created 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
Data Integration
Migrate SQL Server to cloud
Migrate full backup data to RDS for SQL Server 2008 R2
Migrate full backup data to RDS for SQL Server 2012/2016/2017
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 an RDS instance across zones in the same region
Switch between master and slave instances
Set network type
Modify the data replication mode
Create a read-only instance
Release an RDS for MySQL instance
Upgrade the database version
Upgrade SQL Server 2008 R2
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
Hybrid access solution for smooth migration from classic networks to VPCs
Set connection addresses
Use DMS to log on to an RDS instance
View intranet/Internet IP addresses and port number of an instance
Disabling the database proxy mode
Monitoring and Alarming
Set the monitoring frequency
Set monitoring rules
Security
SQL audit
Switch the IP whitelist to enhanced security mode
Configure a 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
Cross-region backup
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)
Cross-region restoration
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
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
ST_BestPyramidLevel
Coordinate system conversion
ST_Rast2WorldCoord
ST_World2RastCoord
ST_ClipDimension
ST_Clip
ST_Update
ST_MosaicFrom
ST_MosaicTo
ST_CheckGPU
Overview operations
ST_BuildOverview
ST_UpdateOverview
ST_EraseOverview
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_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_length
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
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
Request structure
Signature
Public parameters
RAM authorization
Instance management
CreateDBInstance
DeleteDBInstance
RestartDBInstance
RenewInstance
DescribeDBInstanceAttribute
DescribeDBInstances
ModifyDBInstanceSpec
DescribeRegions
DescribeDBInstanceHAConfig
MigrateToOtherZone
PurgeDBInstanceLog
UpgradeDBInstanceEngineVersion
ModifyDBInstanceDescription
ModifyDBInstanceMaintainTime
ModifyDBInstanceHAConfig
SwitchDBInstanceHA
CreateReadOnlyDBInstance
DestroyDBInstance
ModifyDBInstanceDelayReplicationTime
Database management
CreateDatabase
DeleteDatabase
DescribeDatabases
ModifyDBDescription
CopyDatabase
Copy databases between instances
Read/Write splitting
AllocateReadWriteSplittingConnection
CalculateDBInstanceWeight
ModifyReadWriteSplittingConnection
ReleaseReadWriteSplittingConnection
Account management
CreateAccount
DeleteAccount
DescribeAccounts
GrantAccountPrivilege
RevokeAccountPrivilege
ModifyAccountDescription
ResetAccountPassword
ResetAccount
Security management
DescribeDBInstanceIPArrayList
DescribeDBInstanceSSL
DescribeDBInstanceTDE
MigrateSecurityIPMode
ModifyDBInstanceSSL
ModifyDBInstanceTDE
ModifySecurityIps
Network management
AllocateInstancePublicConnection
DescribeDBInstanceNetInfo
Change the expiration time of the original classic endpoint
ModifyDBInstanceConnectionString
ModifyDBInstanceNetworkType
ReleaseInstancePublicConnection
SwitchDBInstanceNetType
Log management
DescribeSlowLogs
DescribeSlowLogRecords
DescribeErrorLogs
DescribeBinlogFiles
DescribeSQLCollectorPolicy
ModifySQLCollectorPolicy
DescribeSQLLogRecords
DescribeSQLLogFiles
Backup and recovery
CreateBackup
Clone RDS instances
DescribeBackups
CreateTempDBInstance
DescribeBackupPolicy
ModifyBackupPolicy
RestoreDBInstance
Delete data backup files
DescribeBackupTasks
View log files
Migrate SQL Server to the cloud
Create a task of migrating data to RDS
CreateOnlineDatabaseTask
Get the task list of migrating data to RDS
Check the file details about the task of migrating data to RDS
Monitoring management
DescribeResourceUsage
DescribeDBInstancePerformance
DescribeDBInstanceMonitor
ModifyDBInstanceMonitor
Parameter management
DescribeParameterTemplates
DescribeParameters
ModifyParameter
Data migration
ImportDatabaseBetweenInstances
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
How to connect/cannot connect
Data backup/recovery
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
[Notice] Supplementary service agreement for RDS for SQL Server 2008 R2
[Important] RDS network link upgrade
Show more
Show less
Purchase Guide
Download PDF
Billing methods and billable 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 RDS for MySQL instance
Scale instances
Show more
Show less
Quick Start for SQL Server
Download PDF
Limits
General process
Create an RDS for SQL Server instance
Initial configuration
Connect to an RDS for SQL Server instance
Read-only instances
Function 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 RDS for PPAS instance
Initial configuration
Connect to an instance
Read/write external data files using oss_fdw
Appendix
Apply for an Internet address
Show more
Show less
Quick Start for MariaDB TX
Download PDF
Create an RDS for MariaDB TX instance
Initial configuration
Connect to an RDS for MariaDB TX 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
Access control
Network isolation
Data Encryption
Backup and recovery
Disaster tolerance
Software upgrade
Service authorization
Show more
Show less
Best Practices
MySQL
SQL Server
PostgreSQL
Show more
Show less
API Reference
Download PDF
API overview
Request structure
Signature
Public parameters
RAM authorization
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
Download PDF
How to connect/cannot connect
Data backup/recovery
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