Relational Database Service
Relational Database Service
Relational Database Service
RDS for SQL Server
RDS for MariaDB
RDS for MySQL
RDS for PostgreSQL
All results for "
" in this service
Relational Database Service
RDS for SQL Server
RDS for MariaDB
RDS for MySQL
RDS for PostgreSQL
All results for "
" in this service
Function Overview
Service Overview
Billing
Getting Started
Kernels
User Guide
Best Practices
Performance White Paper
API Reference
Before You Start
Overview
API Calling
Constraints
Concepts
API Types
API Overview
Calling APIs
Making an API Request
Authentication
Response
API v3.1 (Recommended)
Applying a Parameter Template
Modifying Parameters of a Specified Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (RDS for MySQL)
Querying Database Error Logs (MySQL)
Querying Database Slow Logs (RDS for MySQL)
Deleting a Database (RDS for SQL Server)
Shrinking Database Logs
API v3 (Recommended)
Querying Version Information About APIs
Querying API Versions
Querying a Specified API Version
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
Querying Storage Usage of a DB Instance
DB Instance Management
Creating a DB Instance
Creating a DB Instance (API v5)
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Stopping an Instance
Starting an Instance
Changing a DB Instance Name
Changing the Description of a DB Instance
Applying for a Private Domain Name
Modifying a Private Domain Name
Querying the Domain Name of a DB Instance
Querying the IPv6 Domain Name of a DB Instance
Obtaining the Replication Status of a DB Instance
Querying Available Instance Classes for a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Configuring an Autoscaling Policy
Querying an Autoscaling Policy
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying DB Instances
Binding and Unbinding an EIP
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Replication Mode of Primary/Standby DB Instances
Changing Read/Write Permissions
Migrating a Standby DB Instance
Configuring the Maintenance Window
Upgrading the Minor Version of a DB Instance
Configuring an Automatic Minor Version Upgrade Policy for a DB Instance (RDS for PostgreSQL)
Querying the Automatic Minor Version Upgrade Policy of a DB Instance (RDS for PostgreSQL)
Configuring a Monitoring by Seconds Policy
Querying a Monitoring by Seconds Policy
Enabling TDE for a DB Instance (RDS for SQL Server)
Querying TDE Status of a DB Instance (RDS for SQL Server)
Unlocking a DB Instance from the Read-Only State
DR Instances (RDS for PostgreSQL)
Querying DR relationships
Configuring the DR Capability for a Primary DB Instance
Configuring the DR Capability for a DR Instance
Promoting a DR Instance to Be the Primary DB Instance
Querying the DR Replication Status
Querying DR Instances in Batches
Removing the DR Relationship from a DB Instance
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Floating IP Address
Backup and Restoration
Setting an Automated Backup Policy
Setting a Cross-Region Backup Policy
Obtaining an Automated Backup Policy
Querying Information About a Cross-Region Backup Policy
Creating a Manual Backup
Obtaining Backups
Querying Cross-Region Backups
Querying DB Instances for Which Cross-Region Backups Are Created
Obtaining the Link for Downloading a Backup
Deleting a Manual Backup
Querying the Restoration Time Range
Querying the Restoration Time Range of a Cross-Region Backup
Restoring Data to a New DB Instance
Stopping a Backup (RDS for PostgreSQL)
Checking Whether Fast Restoration Can Be Used for Restoring Databases or Tables (RDS for MySQL)
Querying Tables That Can Be Restored to a Specified Point in Time (RDS for PostgreSQL)
Querying Databases That Can Be Restored to a Specified Point in Time
Restoring Tables to a Specified Point in Time (RDS for PostgreSQL)
Restoring Databases to a Specified Point in Time
Querying Databases Contained in a Database-Level Backup (RDS for PostgreSQL)
Transferring Backups to an OBS Bucket (RDS for MySQL)
Querying Transfer Tasks (RDS for MySQL)
Upgrading a Major Version
Querying the Target Version to Which a DB Instance Can Be Upgraded (RDS for PostgreSQL)
Performing a Major Version Upgrade Pre-Check for a DB Instance (RDS for PostgreSQL)
Querying the Major Version Check Status or Upgrade Status of a DB Instance (RDS for PostgreSQL)
Querying the Major Version Upgrade Check History of a DB Instance (RDS for PostgreSQL)
Upgrading a Major Version of a DB Instance (RDS for PostgreSQL)
Querying the Major Version Upgrade History of a DB Instance (RDS for PostgreSQL)
Log Information Queries
Querying Slow Query Logs Through LTS
Querying Error Logs Through LTS
(Recommended) Querying Database Error Logs
(Recommended) Querying Slow Query Logs
Showing Original Logs
Querying Slow Query Log Files (SQL Server)
Querying Extended Logs (RDS for SQL Server)
Obtaining Links for Downloading Extended Logs (RDS for SQL Server)
Obtaining Slow Query Log Statistics (RDS for MySQL)
Obtaining Links for Downloading Slow Query Logs
Obtaining Links for Downloading Error Logs (RDS for PostgreSQL)
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining Audit Logs
Obtaining the Links for Downloading Audit Logs
Setting the Local Retention Period of Binlogs
Obtaining the Local Retention Period of Binlogs
Querying LTS Configurations
Instance Diagnosis
Obtaining the Number of Instances After Diagnosis
Obtaining the Result of a Specific Diagnosis Item
SQL Throttling (RDS for PostgreSQL)
Adding a SQL Throttling Rule for a Database
Deleting a SQL Throttling Rule
Modifying a SQL Throttling Rule
Querying SQL Throttling Rules
Enabling or Disabling a SQL Throttling Rule or Disabling All SQL Throttling Rules
Database Proxy (RDS for MySQL)
Enabling Database Proxy
Querying Database Proxies
Querying Database Proxy Specifications
Configuring the Routing Policy for a Database Proxy
Disabling Database Proxy
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About a Database (Discarded)
Querying Databases
Querying Authorized Databases of a Specified User
Modifying the Database Remarks of a Specified DB Instance
Deleting a Database
Creating a Database Account
Querying Database Users of a DB Instance (Discarded)
Querying Database Users
Querying Authorized Users of a Specified Database
Modifying Remarks of a Database Account
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Resetting the Password for User root
Database and Account Management (PostgreSQL)
Creating a Database
Creating a Database Account
Creating a Database Schema
Granting Read or Write Permissions to a Database Account
Resetting a Password for a Database Account
Querying Databases
Querying Database Users
Querying Database Schemas
Configuring Account Permissions
Changing the Database Owner
Granting a Role to a User
Revoking a Role from a User
Querying Roles
Querying pg_hba.conf of a DB Instance
Modifying or Adding One or More Records in pg_hba.conf
Overwriting pg_hba.conf
Deleting One or More Records from pg_hba.conf
Querying the pg_hba.conf Change History of a DB Instance
Database and Account Management (Microsoft SQL Server)
Querying the Available SQL Server Character Set
Creating a Database
Querying Databases
Creating a Database Account
Configuring a Password for a Database Account
Querying Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Adding Host Addresses for MSDTC
Querying MSDTC Hosts
Parameter Management
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Replicating a Parameter Template
Querying Change History of Instance Parameters
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Extension Management (RDS for PostgreSQL)
Creating an Extension
Querying Extensions
Updating an Extension
Deleting an Extension
Modifying the Value of a Specified Parameter for an Instance
Obtaining the Value of a Specified Parameter for an Instance
Configuring Replication Delay for a Read Replica (RDS for PostgreSQL)
Obtaining the Delayed Replay Status of WAL Logs
Querying the Recovery Time Window of WAL Logs
Pausing or Resuming WAL Log Replay
Querying the Databases That Can Be Restored to the Primary DB Instance from a Read Replica
Restoring a Database from a Read Replica to the Primary DB Instance
Recycling a DB Instance
Modifying Recycling Policy
Querying the Recycling Policy
Querying Instances in the Recycle Bin
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Querying Tags of a DB Instance
Quota Management
Querying Resource Quotas
Obtaining Task Information
Querying Scheduled Tasks
Querying Instant Tasks
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified DB Instance in a Specified Time Range (RDS for SQL Server)
Historical APIs
API v3
Querying API Versions
Upgrading a Minor Version
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (RDS for MySQL)
Deleting a Database (RDS for SQL Server)
Shrinking Database Logs (Not Recommended)
Database Proxy (PostgreSQL)
Enabling Database Proxy
Disabling Database Proxy
Querying Information About Database Proxy
Modifying Read Weight
Changing the Delay Threshold of Read/Write Splitting
Changing the Instance Class of a DB Proxy Instance
Querying Available Instance Classes for a DB Proxy Instance (v3.1)
Permissions and Supported Actions
Introduction
RDS Actions
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode
Monitoring Metrics
RDS for MySQL Metrics
RDS for PostgreSQL Metrics
RDS for SQL Server Metrics
Idempotent Requests
SDK Reference
SDK Overview
FAQs
Troubleshooting
Videos
Glossary
More Documents
User Guide (ME-Abu Dhabi Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Getting Started with RDS for SQL Server
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to RDS for MySQL
Restoring a DB Instance to a Point in Time
Restoring a Table to a Specified Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Permissions to a User
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password
Changing Permissions
Deleting an Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring from Backup Files to RDS for PostgreSQL
Downloading a Backup File
Downloading an Incremental Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
Managing Tags
Working with RDS for SQL Server
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introduction to Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring from Backup Files to RDS for SQL Server
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading System Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating an Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
Managing Tags
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify Data Corruption?
API Reference (ME-Abu Dhabi Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Querying the Available SQL Server Character Set
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Resetting a Database Password
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Synchronize Model of Primary/Standby DB Instances
Migrating a Standby DB Instance
Configuring the Maintenance Window
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Database and Account Management (Microsoft SQL Server)
Querying Details About Databases
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Paris Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Working with RDS for MySQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Restoring a DB Instance from a Backup
Restoring a DB Instance to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Configuring a Security Group Rule
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Error Logs
Viewing Slow Query Logs
Viewing Failover/Switchover Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring a DB Instance from a Backup
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
API Reference (Paris Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Response
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying Details About DB Instances
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing or Original DB Instance
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Kuala Lumpur Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Getting Started with RDS for SQL Server
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Parameter Tuning
Suggestions on MySQL Parameter Tuning
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Upgrading a Major Version
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica Into a Single DB Instance
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Setting a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to DB Instances
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Database Permissions
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for a Database Account
Deleting a Database Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Parameter Tuning
Suggestions on PostgreSQL Parameter Tuning
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
PostgreSQL Kernel Functions
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Set a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Restoring from Backup Files to RDS for PostgreSQL
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Plugin Management
Creating or Deleting a Plugin
Supported Plugins
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for SQL Server
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Restoring from Backup Files to RDS for SQL Server
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating a Database Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other User Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
How Do I Create an AD Domain?
What Can I Do About Slow Respond of Websites When They Use RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why Is an Error Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
Does MySQL Support SSL Connections?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump or pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permissions?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Available Storage of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data For?
Can My Database Be Used in the Backup Window?
How Can I Back Up an RDS Database to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
Log Management
How Long Is the Delay for RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to a Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
API Reference (Kuala Lumpur Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Response
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Querying the Available SQL Server Character Set
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Resetting a Database Password
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Synchronize Model of Primary/Standby DB Instances
Migrating a Standby DB Instance
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Obtaining Slow Query Log Statistics
Obtaining Links for Downloading Slow Query Logs
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining an Audit Log List
Obtaining the Link for Downloading an Audit Log
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Database and Account Management (Microsoft SQL Server)
Creating a Database
Querying Details About Databases
Deleting a Database
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified SQL Server DB Instance in a Specified Time Range
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Ankara Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Permissions Management
Constraints
RDS for MySQL Constraints
RDS for PostgreSQL Constraints
Related Services
Getting Started with RDS for MySQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to an RDS for MySQL DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to an RDS for MySQL DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Working with RDS for MySQL
Database Migration
Migrating Data to RDS for MySQL Using mysqldump
Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS
Parameter Tuning
Suggestions on RDS for MySQL Parameter Tuning
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica Into a Single DB Instance
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Setting a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Restoring from Backup Files to DB Instances
Restoring a DB Instance to a Point in Time
Restoring a Table to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Configuring a Security Group Rule
Database Proxy (Read/Write Splitting)
Introducing Read/Write Splitting
Best Practices for Database Proxy
Enabling Read/Write Splitting
Configuring Delay Threshold and Distributing Read Weight
Changing the Read/Write Splitting Address
Changing the Instance Class of a DB Proxy Instance
Upgrading the Kernel Version of Database Proxy
Enabling or Disabling Access Control
Disabling Read/Write Splitting
Rules for Distributing Weights
Testing Read/Write Splitting Performance
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Database Migration
Migrating Data to RDS for PostgreSQL Using psql
Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
Parameter Tuning
Suggestions on RDS for PostgreSQL Parameter Tuning
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Set a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Restoring from Backup Files to RDS for PostgreSQL
Restoring a DB Instance to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Plugin Management
Creating or Deleting a Plugin
Supported Plugins
Using pg_repack
Tablespace Management
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Error Logs
Viewing Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
What Is the Availability of RDS DB Instances?
Does RDS Support Cross-AZ High Availability?
What Can I Do About Slow Responses of Websites When They Use RDS?
Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
What Is the Time Delay for Primary/Standby Replication?
What Are the Restrictions on MySQL DB Instances After GTID Is Enabled?
How Many Databases Can Run on an RDS DB Instance?
What Is the Maximum Size Allowed for a Single Table in MySQL Instances?
Resource and Disk Management
How Long Does It Take to Create a DB Instance?
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
How Much Storage Space Is Required for DDL Operations?
Database Connection
What Should I Do If I Can't Connect to My RDS DB Instance?
Can an External Server Access the RDS Database?
What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to an RDS for PostgreSQL Database Through JDBC?
Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
How Can I Obtain the IP Addreenabled SQL auditss of an Application?
Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
How Do I View All IP Addresses Connected to a Database?
Can I Access Standby RDS DB Instances?
How Do I Check the Connections to an RDS for MySQL Instance?
Database Migration
Why Do I Need to Use the mysqldump or pg_dump Tools for Migration?
What Should I Do When a Large Number of Binlog Files Cause Storage Space Insufficiency During an RDS MySQL Instance Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permissions?
RDS for MySQL Built-in Accounts
Does RDS for MySQL Support Multiple Accounts?
How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
Database Storage
What Storage Engines Does RDS for MySQL Support?
What Types of Storage Does RDS Use?
Does RDS for MySQL Support Stored Procedures and Functions?
What Should I Do If My Data Exceeds the Available Storage of an RDS for MySQL Instance?
How Do I View the Storage Usage of My RDS Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install a PostgreSQL Client?
Database Usage
Does MySQL 8.0 Support Full-Text Search?
How Do I Use the mysqlbinlog Tool?
How Do I View Session IDs and Login and Logout Time of a Database?
Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
Backup and Restoration
How Long Does RDS Store Backup Data For?
How Do I Clear RDS Backup Space?
Can My Database Be Used in the Backup Window?
How Do I View My Backup Storage Usage?
How Can I Back Up an RDS Database to an ECS?
Will Backups Be Retained After My RDS Instance Is Deleted?
Why Has My Automated Backup Failed?
Why Is a Table or Data Missing from My Database?
How Do I Restore a Local Database Backup to RDS?
Does RDS for PostgreSQL Support Table PITR?
Can I Dump Backup Files to OBS Buckets?
Does RDS for MySQL Support Table-Level Backup to a Specified OBS Bucket?
Can I Delete the RDS for MySQL Backup Policy?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
How Can I Calculate the Memory Usage of an RDS DB Instance?
How Do I Set an Alarm Rule for the Replication Delay Between Primary and Standby DB Instances?
Capacity Expansion and Specification Change
Are My RDS DB Instances Still Available During Storage Scale-up and Instance Class Change?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Can I Change the VPC that My RDS DB Instance Belongs To?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the RDS for PostgreSQL Database?
How Can I Change the Time Zone?
How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
How Do I Change the RDS Transaction Isolation Level?
Does RDS for PostgreSQL Support the test_decoding Plugin?
How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?
Can I Use SQL Commands to Modify Global Parameters?
How Do I Set Case Sensitivity for RDS for MySQL Table Names?
Can I Enable Query Caching for My RDS for MySQL Instance?
Network Security
What Security Protection Policies Does RDS Have?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Do I Configure a Security Group to Enable Access to RDS DB Instances?
How Can I Import the Root Certificate to a Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
What Are the Possible Causes for Data Corruption?
Version Upgrade
Does RDS for MySQL Support Version Upgrades?
Does RDS for MySQL Support Version Downgrades?
Change History
API Reference (Ankara Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
API v3 (Recommended)
Querying Version Information About APIs
Querying API Versions
Querying a Specified API Version
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Stopping an Instance
Starting an Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Replication Mode of Primary/Standby DB Instances
Migrating a Standby DB Instance
Configuring the Maintenance Window
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Setting a Cross-Region Backup Policy
Obtaining an Automated Backup Policy
Querying Information About a Cross-Region Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Querying Details About Cross-Region Backups
Querying Details About DB Instances for Which Cross-Region Backups Are Created
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Querying the Restoration Time Range of a Cross-Region Backup
Restoring Data to a New DB Instance
Restoring Data to an Existing or Original DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Obtaining Slow Query Log Statistics
Obtaining Links for Downloading Slow Query Logs
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining an Audit Log List
Obtaining the Link for Downloading an Audit Log
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About a Database User
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Resetting the Password for User Root
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode
RDS Monitoring Metrics Description
Change History
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions