Relational Database Service
Relational Database Service
All results for "
" in this service
All results for "
" in this service
What's New
Function Overview
Product Bulletin
Vulnerability Notice
Vulnerability Fixing Policies
Product Notices
[Product Discontinuation Notice] RDS for PostgreSQL 12 Will Be Discontinued on May 1, 2025, 00:00:00 GMT+08:00
[Offline Notice] RDS for PostgreSQL 10 and 11 Will Go Offline on November 1, 2024, 00:00:00 GMT+08:00
[Product Discontinuation Notice] RDS for MySQL 5.6 Will Be Discontinued on July 1, 2024, 00:00:00 GMT+08:00
[Product Discontinuation Notice] RDS for PostgreSQL 10 and 11 Will Be Discontinued on July 1, 2024, 00:00:00 GMT+08:00
[Offline Notice] RDS for PostgreSQL 9.5 and 9.6 Will Go Offline on July 1, 2024, 00:00:00 GMT+08:00
[Notice] OBT for Memory Acceleration of RDS for MySQL Starts from May 28, 2024
Product Release Notes
RDS for MySQL Version Release Notes
RDS for MySQL Lifecycle
RDS for MySQL Kernel Release History
RDS for PostgreSQL Version Release Notes
RDS for PostgreSQL Versioning Policy
RDS for PostgreSQL Kernel Release History
RDS for SQL Server Versioning Policy
Service Overview
RDS Infographics
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Performance
High Security
High Reliability
Comparison Between RDS and On-Premises Databases
Product Series
RDS for MySQL Product Series
RDS for MariaDB Product Series
RDS for PostgreSQL Product Series
RDS for SQL Server Product Series
Functions of RDS for SQL Server Versions
RDS for SQL Server 2012
RDS for SQL Server 2014
RDS for SQL Server 2016
RDS for SQL Server 2017
RDS for SQL Server 2019
RDS for SQL Server 2022
Function Differences Among Standard, Web, and Enterprise Editions
DB Instance Description
DB Instance Types
DB Instance Storage Types
DB Engines and Versions
DB Instance Statuses
DB Instance Classes
RDS for MySQL Instance Classes
RDS for MariaDB Instance Classes
RDS for PostgreSQL Instance Classes
RDS for SQL Server Instance Classes
Typical Use Cases
Reducing Read Pressure with RDS Read/Write Splitting
Storing Diverse Data Types with RDS and Other Services
Security
Shared Responsibilities
Identity Authentication and Access Control
Data Protection
Audit and Logs
Resilience
Risk Monitoring
Fault Recovery
Certificates
Permissions
Constraints
RDS for MySQL Constraints
RDS for MariaDB Constraints
RDS for PostgreSQL Constraints
RDS for SQL Server Constraints
Related Services
Change History
Billing
Billed Items
Billing Modes
Comparison of Billing Modes
Yearly/Monthly Billing
Pay-per-Use Billing
Billing Examples
Billing Mode Changes
Pay-per-Use to Yearly/Monthly
Yearly/Monthly to Pay-per-Use
Renewing Subscriptions
Manually Renewing a DB Instance
Auto-renewing a DB Instance
Bills
Arrears
Billing Termination
Cost Management
Cost Composition
Cost Allocation
Cost Analysis
Cost Optimization
Getting Started
Getting Started with RDS for MySQL
Buying a DB Instance and Connecting to It Using a MySQL Client
Buying a DB Instance and Connecting to It Using MySQL-Front
Getting Started with RDS for MySQL Common Practices
Getting Started with RDS for MariaDB
Step 1: Set Up for RDS
Step 2: Buy a DB Instance
Step 3: Connect to a DB Instance
Overview
Connecting to a DB Instance Through a Private Network
Overview
Configuring Security Group Rules
Connecting to a DB Instance Using a MariaDB Client
Connecting to a DB Instance Through a Public Network
Overview
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Using a MariaDB Client
Connecting to a DB Instance Through DAS
Example: Buy and Connect to an RDS for MariaDB Instance
Getting Started with RDS for PostgreSQL
Step 1: Set Up for RDS
Step 2: Buy a DB Instance
Step 3: Connect to a DB Instance
Overview
Connecting to a DB Instance Through DAS (Recommended)
Connecting to a DB Instance Through a Private Network
Overview
Connecting to a DB Instance from a Linux ECS
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Overview
Binding an EIP
Connecting to a DB Instance from a Linux ECS
Configuring Security Group Rules
Example: Buy and Connect to an RDS for PostgreSQL DB Instance
Getting Started with RDS for PostgreSQL Common Practices
Getting Started with RDS for SQL Server
Overview
Connecting to a DB Instance Through DAS (Recommended)
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance from a Windows ECS
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Connecting to a DB Instance from a Windows Server
Configuring Security Group Rules
Getting Started with RDS for SQL Server Common Practices
Kernels
RDS for MySQL Kernel
RDS for MySQL Kernel Version Description
Main Kernel Functions
Connection Thread Pool
MDL Views
Online Varchar Length Increase
Ending Idle Transactions
DDL Progress Display
RDS for PostgreSQL Kernel
RDS for PostgreSQL Kernel Version Description
Main Kernel Functions
Failover Slot for Logical Subscriptions
RDS for MariaDB Kernel
Change History
User Guide
Working with RDS for MySQL
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Buying an RDS for MySQL DB Instance
Instance Connection
Overview
Connecting to an RDS for MySQL Instance Through DAS (Recommended)
Connecting to an RDS for MySQL Instance Through the MySQL CLI Client
Using MySQL CLI to Connect to an Instance Through a Private Network
Using MySQL CLI to Connect to an Instance Through a Public Network
Installing a MySQL Client
Connecting to an RDS for MySQL Instance Through the GUI
Connecting to an RDS for MySQL Instance Through JDBC
Connection Management
Viewing and Changing a Floating IP Address
Applying for and Changing a Private Domain Name
Changing a Database Port
Binding and Unbinding an EIP
Applying for and Changing a Public Domain Name
Configuring a Certificate
Configuring a Security Group Rule
Database Usage
Suggestions on Using RDS for MySQL
Instance Usage Suggestions
Database Usage Suggestions
Database Management
Creating a Database
Modifying Database Remarks
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
Modifying Host IP Addresses
Deleting a Database Account
Database Migration
Migration Solution Overview
Migrating Data to RDS for MySQL Using mysqldump
Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS
Version Upgrade
Upgrading a Minor Version
Upgrading an RDS for MySQL Instance from 5.7 to 8.0
Upgrading an RDS for MySQL Instance from 5.6 to 5.7
Instance Management
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting Pay-per-Use DB Instances or Read Replicas
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing Read/Write Permissions
Changing a DB Instance Class
Changing a Storage Type
Scaling Up Storage Space
Configuring Storage Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica to Primary
Manually Switching Between Primary and Standby DB Instances
Changing the AZ of a Standby DB Instance
Updating the OS of a DB Instance
Data Backups
Introduction to Backups
Backup Types
Performing Backups
Configuring an Intra-Region Backup Policy
Configuring a Cross-Region Backup Policy
Creating a Manual Backup
Replicating a Backup
Managing Backups
Downloading a Full Backup File
Downloading a Binlog Backup File
Checking and Exporting Backup Information
Using mysqlbinlog to View Binlogs
Deleting a Manual Backup
Clearing Binlogs
Setting a Local Retention Period for RDS for MySQL Binlogs
Clearing Binlogs from DB Instances
Data Restorations
Restoration Solutions
Restoring Data to RDS for MySQL
Restoring a DB Instance from Backups
Restoring a DB Instance to a Point in Time
Restoring Databases or Tables to a Point in Time
Restoring Data Across Regions
Restoring Data to an On-Premises MySQL Database
Read Replicas
Introduction to Read Replicas
Creating an HA Read Replica
Creating a Single Read Replica
Changing a Single Read Replica to an HA Read Replica
Creating Read Replicas in Batches
Managing a Read Replica
Database Proxy (Read/Write Splitting)
Introduction to RDS for MySQL Database Proxy
Constraints on Database Proxy
Using RDS for MySQL Database Proxies for Read/Write Splitting
Database Proxy Configurations
Configuring Transaction Splitting
Configuring Connection Pools
Modifying Read/Write Splitting Parameters
Configuring the Delay Threshold and Routing Policy
Enabling or Disabling Access Control
Changing the Read/Write Splitting Address
Applying for and Changing a Private Domain Name for a Database Proxy
Changing the Read/Write Splitting Port
Changing the Number of Proxy Nodes
Changing the Instance Class of a DB Proxy Instance
Configuring Multi-Statement Processing Modes
Changing a Proxy from Pay-per-Use to Yearly/Monthly
Database Proxy Lifecycle
Restarting a Database Proxy
Disabling Read/Write Splitting
Database Proxy Kernel Versions
Kernel Versions
Upgrading the Kernel Version of Database Proxy
Best Practices for Database Proxy
Problem Diagnosis and SQL Analysis
Function Overview
Performance Monitoring
Viewing the Overall Status of a DB Instance
Viewing Performance Metrics of a DB Instance
Problem Diagnosis
Managing Real-Time Sessions
Managing Disk Capacity
Managing Locks & Transactions
Daily Reports
Managing Anomaly Snapshots
SQL Analysis
Viewing Slow Query Logs of a DB Instance
Viewing Top SQL Statements of a DB Instance
Creating a SQL Insights Task
Creating a Concurrency Control Rule
Configuring Auto Flow Control
Common Performance Problems
High CPU Usage of RDS for MySQL Instances
High Memory Usage of RDS for MySQL Instances
Full Storage of RDS for MySQL Instances
RDS for MySQL Metadata Locks
Troubleshooting Slow SQL Issues for RDS for MySQL DB Instances
Security and Encryption
Database Account Security
Resetting the Administrator Password to Restore Root Access
Changing a Security Group
Performing a Server-Side Encryption
Configuring an SSL Connection
Configuring the TDE Function
Configuring a Password Expiration Policy
Unbinding an EIP
Using the Database of the Latest Version
Using DBSS (Recommended)
Parameters
Modifying Parameters of an RDS for MySQL Instance
Managing Parameter Templates
Creating a Parameter Template
Applying a Parameter Template
Replicating a Parameter Template
Resetting a Parameter Template
Comparing Parameter Templates
Exporting a Parameter Template
Importing a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Suggestions on RDS for MySQL Parameter Tuning
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling SQL Audit
Downloading SQL Audit Logs
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Configuring Alarm Reporting
Configuring Monitoring by Seconds
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Billing Management
Renewing DB Instances
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Changing the Billing Mode from Yearly/Monthly to Pay-per-Use
Unsubscribing from a Yearly/Monthly Instance
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
RDS for MySQL Tags
RDS for MySQL Quotas
Memory Acceleration
Memory Acceleration Overview
Enabling Memory Acceleration
Managing Mapping Rules
Memory Acceleration Management
Working with RDS for MariaDB
Suggestions on Using RDS for MariaDB
Instance Usage Suggestions
Database Usage Suggestions
Instance Connection
Connecting to an RDS for MariaDB Instance
Connecting to an RDS for MariaDB Instance Through the MySQL CLI Client
Using MySQL CLI to Connect to an Instance Through a Private Network
Using MySQL CLI to Connect to an Instance Through a Public Network
Connecting to an RDS for MariaDB Instance Through JDBC
Connecting to an RDS for MariaDB Instance Through DAS
Performance Tuning
What Is the Maximum Number of IOPS Supported by RDS?
How Do I Improve the Query Speed of My RDS Database?
Identifying Why CPU Usage of RDS for MariaDB Instances Is High and Providing Solutions
RDS for MariaDB Memory Usage Too High
What Should I Do If an RDS DB Instance Is Abnormal Due to Full Storage Space?
Troubleshooting Slow SQL Issues for RDS for MariaDB Instances
Resolving Insufficient Storage Issues for RDS for MariaDB Instances
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Modifying Recycling Policy
Rebuilding a DB Instance
Instance Modifications
Upgrading a Minor Version
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Storage Autoscaling
Manually Switching Between Primary and Standby DB Instances
Changing the Maintenance Window
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Creating Read Replicas in Batches
Managing a Read Replica
Data Backups
Backup Solutions
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Checking and Exporting Backup Information
Downloading a Full Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for RDS for MariaDB Binlogs
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring a DB Instance from a Backup
Restoring a DB Instance to a Point in Time
Parameter Templates
Creating a Parameter Template
Modifying RDS for MariaDB Instance Parameters
Exporting a Parameter Template
Importing 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
Viewing 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
Modifying Host IP Addresses for a Database Account
Deleting a Database Account
Account and Network Security
Database Account Security
Resetting the Administrator Password to Restore root Access
Configuring an SSL Connection
Configuring a Password Expiration Policy
Unbinding an EIP
Using DBSS (Recommended)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Traces
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Enabling or Disabling SQL Audit
Downloading SQL Audit Logs
DBA Assistant
Function Overview
Viewing the Overall Status of a DB Instance
Managing Real-Time Sessions
Viewing Session Statistics
Setting a Slow Session Threshold
Viewing Performance Metrics
Subscribing to Intelligent O&M
Viewing Storage Usage
Viewing Table Diagnosis Results
Setting a Diagnosis Threshold
Viewing Top Databases and Tables by Physical File Size
Viewing Slow Query Logs
Concurrency Control
Auto Flow Control
Managing Diagnosis Reports
Viewing Diagnosis Reports
Subscribing to Diagnosis Reports
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Managing Quotas
Working with RDS for PostgreSQL
Suggestions on Using RDS for PostgreSQL
Instance Usage Suggestions
Database Usage Suggestions
Instance Connection
Connecting to an RDS for PostgreSQL Instance
Connecting to an RDS for PostgreSQL Instance Through DAS (Recommended)
Connecting to an RDS for PostgreSQL Instance Through the psql CLI Client
Connecting to a DB Instance from a Linux ECS
Connecting to a DB Instance from a Linux ECS
Installing a PostgreSQL Client
Connecting to an RDS for PostgreSQL Instance Through the GUI
Connecting to an RDS for PostgreSQL Instance Through JDBC
Connecting to an RDS for PostgreSQL Instance Using Python
Database Migration
Migration Solution Overview
Migrating Data to RDS for PostgreSQL Using psql
Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
Performance Tuning
Suggestions on RDS for PostgreSQL Parameter Tuning
Troubleshooting High CPU Usage
Troubleshooting High Memory Usage
Troubleshooting Database Age Increase Problem
Troubleshooting High Storage Space Usage
Troubleshooting Abnormal Connections and Active Connections
Troubleshooting Long-Running Transactions
Troubleshooting Inactive Logical Replication Slots
Troubleshooting High Oldest Replication Slot Lag or Replication Lag
Troubleshooting SQL Statements That Have Been Executed for 3s or 5s
RDS for PostgreSQL Enhanced Edition
Introduction to RDS for PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an 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
Upgrading a Minor Version
Changing a DB Instance Name
Changing a DB Instance Description
Changing the Replication Mode
Changing the Failover Priority
Changing a DB Instance Class
Changing the Storage Type
Scaling Storage Space
Storage Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Changing the AZ of a Standby DB Instance
Updating the OS of a DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Configuring Replication Delay for a Read Replica
DR Management
Creating a DR Relationship
Promoting a DR Instance to Primary
Removing a DR Relationship
Data Backups
Backup Solutions
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Checking and Exporting Backup Information
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring from Backup Files to RDS for PostgreSQL Instances
Restoring Data to an On-Premises PostgreSQL Database from a Full Backup
Restoring a DB Instance to a Point in Time
Restoring Databases or Tables to a Point in Time
Parameters
Creating a Parameter Template
Modifying Parameters of an RDS for PostgreSQL Instance
Importing a Parameter Template
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
Viewing and Changing a Floating IP Address
Changing a Private Domain Name
Configuring SSL Encryption
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Extension Management
Installing and Uninstalling an Extension on the RDS Console
Installing and Uninstalling an Extension Using SQL Commands
Supported Extensions
pg_profile_pro
pg_repack
pgl_ddl_deploy
pgvector
pgAudit
pglogical
pg_stat_statements
rds_hwdrs_ddl
rds_hwdrs_privs
HypoPG
pg_cron
dblink
rds_pg_sql_ccl
Tablespace Management
Databases
Creating a Database
Modifying Database Remarks
Deleting a Database
Accounts (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Modifying Remarks of a Database Account
Deleting a Database Account
Modifying pg_hba.conf
Viewing the pg_hba.conf Change History
Security and Encryption
Database Account Security
Resetting the Administrator Password to Restore Root Access
Changing a Security Group
Performing a Server-Side Encryption
Using DBSS (Recommended)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Enabling SQL Audit
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Billing Management
Renewing DB Instances
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Changing the Billing Mode from Yearly/Monthly to Pay-per-Use
Unsubscribing from a Yearly/Monthly Instance
Major Version Upgrade
Upgrading the Major Version of a DB Instance Using SQL Commands
Upgrading the Major Version of a DB Instance on the Console
RDS for PostgreSQL Tags
RDS for PostgreSQL Quotas
Working with RDS for SQL Server
Suggestions on Using RDS for SQL Server
Instance Connection
Connecting to an RDS for SQL Server Instance
Connecting to an RDS for SQL Server Instance Through DAS (Recommended)
Connecting to an RDS for SQL Server Instance Through the SQL Server Management Studio Client
Connecting to a DB Instance from a Windows ECS
Connecting to a DB Instance from a Windows Server
Installing SQL Server Management Studio
Database Migration
Migration Solution Overview
Migrating Data to RDS for SQL Server Using the Export and Import Functions of DAS
Performance Tuning
High CPU Usage of RDS for SQL Server Instances
Full Storage of RDS for SQL Server Instances
Instance Lifecycle
Buying a Same DB Instance as an Existing DB Instance
Stopping an Instance
Starting an 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 a DB Instance Description
Changing the Failover Priority
Cloning a DB Instance
Changing a DB Instance Class
Scaling Up Storage Space
Configuring Autoscaling
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Updating the DB Engine and OS of a DB Instance
Read Replicas
Managing a Read Replica
Data Backups
Backup Solutions
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Checking and Exporting Backup Information
Replicating a Backup
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring from Backup Files to RDS for SQL Server Instances
Restoring from Backup Files to a Self-Built SQL Server Database Using SSMS
Restoring a DB Instance to a Point in Time
Parameters
Creating a Parameter Template
Modifying RDS for SQL Server 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
Viewing and Changing a Floating IP Address
Applying for and Changing a Private Domain Name
Applying for and Changing a Public Domain Name
Binding and Unbinding an EIP
Changing a Database Port
Accounts (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Deleting a Database Account
Databases
Creating a Database
Granting Database Permissions
Deleting a Database
Copying a Database
Viewing Database Properties
Security and Encryption
Database Account Security
Resetting the Administrator Password
Changing a Security Group
Performing a Server-Side Encryption
Configuring the TDE Function
Using DBSS (Recommended)
Distributed Transactions
SQL Server Integration Services (SSIS)
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Event Monitoring
Introduction to Event Monitoring
Viewing Event Monitoring Data
Creating an Alarm Rule to Monitor an Event
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Viewing and Downloading System Logs
Viewing and Downloading Audit Logs
Viewing and Downloading Slow Query Logs
DBA Assistant
Function Overview
Sessions
Storage Analysis
Real-Time Top SQL
Slow Query Log
Deadlocks
Publications and Subscriptions
Creating a Publication
Creating a Subscription
Monitoring Jobs
Task Center
Viewing a Task
Deleting a Task Record
Authorizing a Task
Billing Management
Unsubscribing from a Yearly/Monthly Instance
Enabling or Disabling FileStream
CLR Integration
Default Language Setting for RDS for SQL Server
Usage of Stored Procedures
Creating a Database Account
Granting SSIS Permissions to a Domain Account
Deploying an SSIS Project
Changing Custom Database Names
Viewing Error Logs
Tracing Flags
Capturing Change Data
Removing a Custom Database from an Availability Group
Replicating Databases
Granting Database Permissions to Subaccounts
Deleting Custom Databases
Updating Database Statistics
Cycling SQL Server Agent Error Logs
Cycling SQL Server Error Logs
Creating Alerts
Setting Up Notifications for Alert
Creating Operators for Alerts and Jobs
Updating Alert Settings
Updating Alert Notification Methods
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
Shrinking Databases
Changing the Permission to View All Databases
Granting Permissions of Database-Level db_owner Role
RDS for SQL Server Tags
RDS for SQL Server Quotas
Best Practices
Overview
RDS for MySQL
Migrating Data from Self-Managed MySQL Databases to RDS for MySQL
Overview
Resource Planning
Operation Process
Cloud Migration
Creating an RDS for MySQL Instance
Creating a Migration Task
Confirming Migration Results
Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS
Overview
Resource Planning
Operation Process
Configuring an RDS for MySQL Instance in the Production Center
Creating a VPC and Security Group
Creating an EIP
Creating an RDS for MySQL Instance
Configuring an RDS for MySQL Instance in the DR Center
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Configuring Remote Disaster Recovery
Creating a DRS Disaster Recovery Task
Configuring the Disaster Recovery Task
Performing a Primary/Standby Switchover
Migrating MySQL Databases from Other Clouds to RDS for MySQL
Overview
Resource Planning
Operation Process
Creating a VPC and Security Group
Creating an RDS for MySQL Instance
Configuring a MySQL Instance on Another Cloud
Cloud Migration
Creating a DRS Migration Task
Checking Migration Results
Using RDS for MySQL to Set Up WordPress
Using RDS for MySQL to Set Up Discuz!
Description of innodb_flush_log_at_trx_commit and sync_binlog
How Do I Improve the Query Speed of My RDS for MySQL Instance?
Handling RDS for MySQL Long Transactions
Security Best Practices
RDS for PostgreSQL
Creating Databases
Database Naming Rules
Creating a Database Through DAS
CREATE DATABASE Options
TEMPLATE Option
LC_COLLATE and LC_CTYPE Options
FAQ
How Do I View the Created Databases and the Character Sets, LC_COLLATE, and LC_CTYPE Information of the Databases?
What Do I Do If the Character Set Does Not Match the Locale During Database Creation?
How Do I Create a Database Using a Command-Line Interface (CLI)?
What Are the Constraints on Character Sets?
Performing Basic Operations Using pgAdmin
Connecting to an RDS for PostgreSQL Instance
Creating a Database
Creating a Table
Using the Query Tool to Run SQL Statements
Monitoring Databases
Backing Up and Restoring Data
Using PoWA
Overview
Performance Metrics
Database Performance Metrics
Instance Performance Metrics
PoWA Deployment Models
Introducing Remote Deployment
Configuring Remote Deployment
Accessing PoWA
Example for Using PoWA
Other Extension Plug-Ins
Operation References
Installing Python 3.9.9
RDS for PostgreSQL Publications and Subscriptions
Best Practices for Using pg_dump
Viewing Slow Query Logs of RDS for PostgreSQL DB Instances
Using Client Drivers to Implement Failover and Read/Write Splitting
User-Defined Data Type Conversion
Creating a Cross-Region DR Relationship for an RDS for PostgreSQL Instance
Overview
Resource Planning
Operation Process
Preparing an RDS for PostgreSQL Instance in the Production Center
Preparing an RDS for PostgreSQL Instance in the DR Center
Configuring Cross-Region Network Connection
Creating a DR Relationship
Promoting a DR Instance to Primary
Removing a DR Relationship
FAQs
Best Practices for Using PgBouncer
Security Best Practices
RDS for SQL Server
Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances
Migrating Data from a Self-Managed SQL Server Database on an ECS to an RDS for SQL Server DB Instance
Modifying Parameters of RDS for SQL Server Instances
Supporting DMVs
Using the Import and Export Function to Migrate Data from a Local Database to an RDS for SQL Server DB Instance
Creating a Subaccount of rdsuser
Creating tempdb Files
Microsoft SQL Server Publication and Subscription
Installing a C# CLR Assembly in RDS for SQL Server
Creating a Linked Server for an RDS for SQL Server DB Instance
Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server
Shrinking an RDS for SQL Server Database
Using DAS to Create and Configure Agent Job and DBLink on the Master and Slave Databases for RDS for SQL Server Instances
Creating a Job for Scheduled Instance Maintenance
Using Extended Events
Performance White Paper
RDS for MySQL
Test Method
RDS for MySQL 5.6 Test Data
General-Enhanced DB Instances
General-Purpose DB Instances
Dedicated DB Instances
RDS for MySQL 5.7 Test Data
General-Enhanced DB Instances
General-Purpose DB Instances
Dedicated DB Instances
Kunpeng General-Enhanced DB Instances
RDS for MySQL 8.0 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL
Test Method
RDS for PostgreSQL 9.6 Test Data
RDS for PostgreSQL 11 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 12 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 13 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 14 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for PostgreSQL 15 Test Data
General-Purpose DB Instances
Dedicated DB Instances
RDS for SQL Server
Test Method
Test Data
API Reference
Before You Start
Overview
API Calling
Endpoints
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 (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 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
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 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
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
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
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
Instance Diagnosis
Obtaining the Number of Instances After Diagnosis
Obtaining the Result of a Specific Diagnosis Item
SQL Statement Concurrency Control (RDS for PostgreSQL)
Adding a SQL Statement Concurrency Control Rule for a Database
Deleting a SQL Statement Concurrency Control Rule
Modifying a SQL Statement Concurrency Control Rule
Querying SQL Statement Concurrency Control Rules
Enabling or Disabling a SQL Statement Concurrency Control Rule or Disabling All SQL Statement Concurrency Control 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
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
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified SQL Server DB Instance in a Specified Time Range
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)
Querying Database Error Logs
Querying Database Slow Logs (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
RDS Monitoring Metrics Description
Idempotent Requests
Change History
SDK Reference
SDK Overview
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
Will My RDS DB Instances Be Affected by Other User Instances?
Will Different RDS DB Instances Share CPU and Memory Resources?
How Long Does It Take to Create an RDS DB Instance?
What Can I Do About Slow Responses of Websites When They Use RDS?
What Is the Time Delay for Primary/Standby Replication?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Will Backups Be Encrypted After Disk Encryption Is Enabled for My RDS Instance?
What Is the Availability of RDS DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Are the Differences Between RDS for MySQL and GaussDB(for MySQL)?
Does RDS Support CloudPond?
What Encryption Functions Does RDS for MySQL Support?
Is RDS for MySQL Compatible with MariaDB?
Does RDS for MySQL Support TokuDB?
What Are the Restrictions on RDS for MySQL Instances After GTID Is Enabled?
What Is the Maximum Size Allowed for a Single Table in RDS for MySQL Instances?
How Do I Purchase RDS for SQL Server Instances on Huawei Cloud?
Resource Freezing, Release, Stopping, Deletion, and Unsubscription
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Does RDS Support Storage Scale-Down of DB Instances?
Which Items Occupy the Storage Space of My RDS DB Instances?
How Much Storage Space Is Required for DDL Operations?
What Are the Differences Between the Storage Space and Backup Space of an RDS for PostgreSQL Primary/Standby Instance?
How Do I Prevent a Sharp Increase in Data Disk Usage If I Want to Push a Large Amount of Data to My RDS for SQL Server Instance in a Short Period of Time?
Database Connection
What Should I Do If I Can't Connect to My RDS DB Instance?
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?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If My RDS Instance Fails to Be Connected Due to Database Client Problems?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
Do Applications Need to Support Reconnecting to an RDS DB Instance Automatically?
Why Can't I Ping My EIP After It Is Bound to an RDS DB Instance?
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 of My RDS Instance?
Can I Access Standby RDS DB Instances?
How Do I Check the Connections to an RDS for MySQL Instance?
Will I Be Logged Out If the Connection to RDS for SQL Server Instances Times Out?
What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
Can an External Server Access the RDS Database?
Will My Access Be Restricted by Bandwidth When I Connect to My Instance from an ECS over a Private Network?
How Can I Install SQL Server Management Studio?
Database Migration
What Types of DB Engines Does RDS Support for Importing Data?
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?
Precautions for Exporting Large Tables Through mysqldump
Commands for Exporting Data Through mysqldump
Database Permission
Why Does the Root User of My RDS Instance Not Have the Super Permissions?
What Are the Differences Between RDS ManageAccess and DAS Permissions?
How Do I View Authorized Databases After a Local Client Is Connected to an RDS DB Instance?
Can Multiple Users Log In to an RDS Instance Through DAS at the Same Time? Will the Accounts Be Locked If I Enter Wrong Passwords Several Times in a Row?
Does RDS for MySQL Support Multiple Accounts?
Why Did I Fail to Create an Object on the postgres Database as a Common User?
What Should I Do If a Role Failed to Be Deleted from an RDS for PostgreSQL Instance?
Why Did My RDS for PostgreSQL Migration Fail?
How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?
Why Is An Error Reported When I Attempt to Change a Table Owner of My RDS for PostgreSQL Instance?
How Are the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?
After a Primary Instance Account Is Deleted and Recreated on RDS for SQL Server, Will the Permissions Be Automatically Synchronized?
Database Storage
What Types of Storage Does RDS Use?
How Do I View the Storage Usage of My RDS Instance?
What Storage Engines Does RDS for MySQL Support?
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?
Where Are the Database Files Created on My RDS for SQL Server Instance Stored?
Database Usage
How Do I Use DAS to Query SQL Statements?
How Do I View Session IDs and Login and Logout Time of an RDS Database?
How Do I Create a Scheduled Task for My RDS for MySQL Instance?
What Should I Do If the root Account of My RDS for MySQL Instance Was Deleted by Mistake?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File for My RDS Instance?
Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
Does RDS for MySQL 8.0 Support Full-Text Search?
How Do I Use the mysqlbinlog Tool?
Why Is an Error Reported When I Attempt to Delete a Database from My RDS for SQL Server Primary/Standby DB Instance?
Backup and Restoration
How Do I View My Backup Storage Usage?
How Is RDS Backup Data Billed?
Why Has Automated Backup of My RDS Instance Failed?
Why Is Data Lost or Deleted from My RDS Instance?
How Long Does RDS Store Backup Data For?
How Do I Clear RDS Backup Space?
Can My RDS Instance Still Be Used in the Backup Window?
How Can I Back Up an RDS Database to an ECS?
Can I Dump RDS Backup Files to My OBS Bucket?
Does RDS for MySQL Support Table-Level Backup to a Specified OBS Bucket?
Can I Delete the RDS for MySQL Backup Policy?
Does RDS for PostgreSQL Support Table PITR?
How Are Unsynchronized Backups Generated for RDS for SQL Server DB Instances?
Read Replicas and Read/Write Splitting
Why Can't I Purchase Read Replicas on the RDS Console?
Can I Change the Replication Mode Between RDS Primary Instances and Read Replicas?
Does RDS Support Read/Write Splitting?
Does RDS for MySQL Support Sharding and Read/Write Splitting?
Can I Request Multiple Read/Write Splitting Addresses for My RDS for MySQL Instance?
Database Monitoring
Which RDS Instance 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 RDS Primary and Standby Instances?
Capacity Expansion and Specification Change
Are My RDS DB Instances Still Available During Storage Scale-up and Instance Class Change?
Why Does My RDS Instance Become Faulty After Its Database Port Is Changed?
Can I Change the VPC or Subnet that My RDS DB Instance Belongs To?
How Do I Distinguish Between General-Purpose and Dedicated RDS for MySQL Instances Using Cloud SSDs?
Database Parameter Modification
Can I Use SQL Commands to Modify Global Parameters of My RDS Instance?
How Do I Change the Time Zone of an RDS DB Instance?
How Do I Set the Encoding Format of the RDS for MySQL 8.0 Character Set?
How Do I Set Case Sensitivity for RDS for MySQL Table Names?
How Do I Enable Query Caching for My RDS for MySQL Instance?
How Do I Configure a Password Expiration Policy for My RDS for MySQL Instance?
How Do I Change the Transaction Isolation Level of an RDS for MySQL Instance?
How Do I Ensure that the Character Set of an RDS MySQL Database Is Correct?
How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?
What Inappropriate Parameter Settings Will Cause Unavailability of My RDS for PostgreSQL Instance?
How Do I Set the Upper Limit for the Storage Space Occupied by Temporary Files of My RDS for PostgreSQL Instance?
How Do I Configure the test_decoding Extension for My RDS for PostgreSQL Instance?
Where Should I Store NDF Files for RDS for SQL Server?
How Do I Modify the Collation of an RDS for SQL Server Character Set?
Log Management
How Long Is the Delay for RDS MySQL Slow Query Logs?
How Do I View Logs of All SQL Statements Executed by My RDS for MySQL Instance?
How Do I View Deadlock Logs of RDS for MySQL?
How Can I Obtain RDS for SQL Server Error Logs Using Commands?
Network Security
How Can Data Security Be Ensured During Transmission When I Access an RDS Instance Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Do I Import the SSL Certificate of an RDS Instance to a Windows or Linux Server?
How Do I Check the Validity Period of the SSL Certificate of My RDS for MySQL Instance?
What Are the Possible Causes for Data Corruption of an RDS Instance?
After My RDS DB Instance Is Deleted, Why Can't the Associated Security Group Be Deleted Immediately?
Version Upgrade
How Can I View the Version of an RDS DB Instance?
Does RDS for MySQL Support Version Upgrades?
Does RDS for MySQL Support Version Downgrades?
Does RDS for PostgreSQL Support Major Version Upgrades?
Developer-Related APIs and SDKs for RDS
Troubleshooting
RDS for MySQL
Backup and Restoration Issues
No SUPER Permissions When Restoring an RDS for MySQL Full Backup to a Local MySQL Database
Backup Failures Due to DDL Operations
Restoring an On-Premises or Huawei Cloud Backup File to an RDS DB Instance
RDS for MySQL Backup Job Failure
Manual Backups Taking More Time Than Automated Full Backups
Incorrect Login Password During Data Restoration from a Local Backup File
Automated Incremental Backup Failed Due to Full Storage
RDS Point-in-Time Restoration Task Failure
SQL Statements Such as SET @@SESSION.SQL_LOG_BIN Displayed After You Run mysqldump
Insufficient Permissions During Data Export Using mysqldump
Key Considered Invalid or Deleted During Table-Level PITR
Primary/Standby Replication Issues
How Primary/Standby Replication Works
Automatic Recovery of Extended Primary/Standby Replication Delay
Primary/Standby Replication Delay Scenarios and Solutions
Abnormal Replication Between Primary and Standby RDS DB Instances
Primary/Standby Replication Delay Increases Sharply and Then Decreases
Insufficient Permissions Reported for Canal
Canal Fails to Parse Binlogs
RDS for MySQL Binlog Issues
Parameter-related Issues
long_query_time Changes Fail to Be Applied
Incorrect GROUP_CONCAT Results
[ERROR] 1071 Reported When an Index Creation Fails for RDS for MySQL
Tables Failed to Be Found After Case-Sensitivity Setting Changes for RDS for MySQL
Timeout Parameters
Global Parameters Fail to Change
Performance Issues
High CPU Usage
Out of Memory (OOM) Errors
Insufficient Disk Bandwidth
Slow SQL Statements Due to Improper Composite Index Settings
DB Instance Becoming Read-Only Due to Insufficient Storage
High Storage Usage Due to Uncleared Old Binlogs
Slow Response Due to Deadlocks
Read Replica Uses Far More Storage Than the Primary Instance
CPU Usage Increase
Slow SQL Execution Due to Hot and Cold Data Problems
High Table Fragmentation Rate
Full Storage Caused by Complex Queries
Why Is My SQL Query So Slow?
Instance Class Change or Minor Version Upgrade Failure Caused by Long Transactions
Native Error 1461 Reported by an RDS for MySQL DB Instance
System Inaccessible After Field Addition to an RDS for MySQL Database Table
Storage Filled Up by Undo Logs Due to Long Transactions
Locating Long Transactions
Sharp Increase in the Commit Time of Some SQL Statements
Oversized ibdata1
SQL Issues
Double Quotation Marks Cannot Be Identified During SQL Statement Execution
Error 1366 Reported When Data Containing Emojis Is Updated
Failed to Change the varchar Length Due to the Index Length Limit
Invalid TIMESTAMP Default Value during Table Creation
AUTO_INCREMENT Not Displayed in the Table Structure
Slow Stored Procedure Execution Due to Inconsistent Collations
ERROR [1412] Reported for a DB Instance
Error Message "Too many keys specified" Displayed When a Secondary Index Is Created
Failed to Delete a Table with a Foreign Key
DISTINCT and GROUP BY Optimization
Character Set and Collation Settings
An Error Message Is Displayed When a User Is Created for a DB Instance
Slow SQL Queries After a Large Amount of Data Is Deleted from a Large Table
Event Scheduler Not Taking Effect Immediately After Being Enabled
Equivalent Comparison Failures with Floating-Point Numbers
A Large Number of SELECT Requests Routed to The Primary Instance After Database Proxy Is Enabled
RENAME USER Execution Failure
ERROR[1451] Reported When a Table with Foreign Keys Cannot Be Deleted
Solution to the Failure of Converting the Field Type
"Row size too large" Reported When an RDS for MySQL Table Failed to Be Created
ERROR [1412] Reported by an RDS for MySQL DB Instance
Instance Reboot Failure or ERROR 1146: Table 'xxx' doesn't exist Reported During Table Operations
Error Reported During Pagination Query
Error Reported During User Creation
Syntax Error Reported When GRANT Is Used to Grant All Privileges
Error Reported During Table Creation for an RDS for MySQL 5.6 DB Instance
Inconsistent Data Obtained on the Primary and Standby Nodes When a Query Is Performed Using an Auto-Increment Primary Key Value
"Data too long for column" Displayed When Data Is Inserted into an RDS for MySQL Instance
Connection Issues
"Access denied" Displayed During Database Connection
Failed to Connect to a Database Using mariadb-connector in SSL Mode
Error Message "connection established slowly"
Login Failed After ssl_type of root Is Changed to ANY
Error Reported During Login to a DB Instance Through DAS
"Your password does not satisfy the current policy requirements" Displayed When Permissions Are Granted or Revoked on DAS
SSL Connection Failed Due to Inconsistent TLS Versions
Failed to Connect to a Database as root
RDS for MySQL Client Automatically Disconnected from a DB Instance
RDS for MySQL DB Instance Inaccessible
Login Failed After the authentication_string Field Is Changed to Display the Password for RDS for MySQL
MySQL-server Connection Failure After a Version Upgrade of RDS for MySQL
Connection Exit Due to Improper Timeout Parameter Settings
Database Connection Through Code (php/java/python) Failed After SSL Is Enabled
There Is a Disconnection Every 45 Days Due to the istio-citadel Certificate System
Error 1251 Reported During Login to a DB Instance on the Navicat Client After the Database Version Is Upgraded
Other Issues
No Scanned Rows Recorded in Slow Query Logs
Rows Recorded in the SQL Diagnosis Result Far Less Than the Scanned Rows Recorded in Slow Query Logs
Millisecond-Level SQL Statements Recorded in Slow Query Logs
Viewing Storage of RDS DB Instances
"The table is full" Displayed in Error Logs
Audit Log Upload Policy Description
Auto-increment Field Values
Starting Value and Increment of AUTO_INCREMENT
AUTO_INCREMENT Value Exceeding the Maximum Value of This Field plus 1
Auto-Increment Field Value Jump
Changing the AUTO_INCREMENT Value of a Table
Failed to Insert Data Because Values for the Auto-increment Primary Key Field Reach the Upper Limit
The Impact of Creating an Empty Username
Connection to a Primary/Standby DB Instance Suspended Using pt-osc
Error Reported During Payment for a DB Instance
Failed to Change a Database Name
Error Reported When a DB Instance Is Purchased
RDS for PostgreSQL
A Large Number of Schemas Whose Owner Is rdsadmin
Index Name Containing a Schema Name During Index Creation
Authentication Not Supported When a DB Instance Is Accessed Through an Application
Error Reported When a Request Is Executed Through an Existing Connection
Slow Instance Reboot Due to Too Many Inodes
RDS for SQL Server
Account Creation Failure for a Microsoft SQL Server Database Migrated from Alibaba Cloud to Huawei Cloud
Error Reported When a New Account Is Used to Log In to an RDS for SQL Server Instance
Failed to Change the Instance Class of an RDS for SQL Server Instance or Perform a Primary/Standby Switchover
How Do I Remove and Re-establish a Replication of My RDS for SQL Server Instance?
Change History
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 Microsoft 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?
How Do I Create an AD Domain?
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 from Backup Files to a Self-Built MySQL Database
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
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
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
Viewing Tracing EventsViewing Tracing EventsViewing Log Records
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
Restoring from Backup Files to a Self-Built SQL Server Database
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
Viewing Tracing EventsViewing Tracing EventsViewing Log Records
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 Microsoft 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