Relational Database Service
Relational Database Service
Relational Database Service
RDS for MariaDB
RDS for SQL Server
RDS for PostgreSQL
RDS for MySQL
All results for "
" in this service
Relational Database Service
RDS for MariaDB
RDS for SQL Server
RDS for PostgreSQL
RDS for MySQL
All results for "
" in this service
Service Overview
Billing
Getting Started
Kernels
User Guide
Best Practices
Performance White Paper
API Reference
Before You Start
Overview
API Calling
Constraints
Concepts
API Types
API Overview
Calling APIs
Making an API Request
Authentication
Response
API v3.1 (Recommended)
Applying a Parameter Template
Modifying Parameters of a Specified Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (RDS for MySQL)
Querying Database Error Logs (RDS for MySQL)
Querying Database Slow Logs (RDS for MySQL)
Deleting a Database (RDS for SQL Server)
Querying Slow Query Log Statistics
Shrinking Database Logs (RDS for SQL Server)
API v3 (Recommended)
Querying Version Information About APIs
Querying API Versions
Querying a Specified API Version
Querying Version Information About a DB Engine
Querying Minor Versions Available for Instance Upgrade (RDS for PostgreSQL)
Querying the Features Supported by a Version (RDS for SQL Server)
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 (RDS for PostgreSQL)
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 IPv4 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
Querying the Auto Scaling Policy of 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
Replacing a Read Replica with a Standby Node (RDS for SQL Server)
Rebooting a DB Instance
Deleting a DB Instance
Choosing Whether to Retain Automated Backups When Deleting an Instance (RDS for SQL Server)
Batch Deleting DB Instances
Querying DB Instances
Binding and Unbinding an EIP
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Replication Mode of Primary/Standby DB Instances
Changing Read/Write Permissions
Migrating a Standby DB Instance
Configuring the Maintenance Window
Upgrading the Minor Version of a DB Instance
Configuring an Automatic Minor Version Upgrade Policy for a DB Instance (RDS for PostgreSQL)
Querying the Automatic Minor Version Upgrade Policy of a DB Instance (RDS for PostgreSQL)
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 (RDS for PostgreSQL)
Resetting the SQL Statistics View (RDS for PostgreSQL)
Querying SQL Statement Statistics (RDS for PostgreSQL)
Querying Top SQL Statements (RDS for SQL Server)
Rebuilding a Standby Instance
Querying the Status of a Rebuilt Standby Instance
DR Instances (RDS for PostgreSQL)
Querying DR relationships
Configuring the DR Capability for a Primary DB Instance
Configuring the DR Capability for a DR Instance
Promoting a DR Instance to Be the Primary DB Instance
Querying the DR Replication Status
Querying DR Instances in Batches
Removing the DR Relationship from a DB Instance
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Floating IP Address
Checking Whether a Password Is Weak
Backup and Restoration
Setting an Automated Backup Policy
Setting a Cross-Region Backup Policy
Obtaining an Automated Backup Policy
Querying Information About a Cross-Region Backup Policy
Creating a Manual Backup
Obtaining Backups
Querying Cross-Region Backups
Querying DB Instances for Which Cross-Region Backups Are Created
Obtaining the Link for Downloading a Backup
Deleting a Manual Backup
Deleting Manual Backups in Batches (RDS for SQL Server)
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
Checking Whether Fast Restoration Can Be Used for Restoring Databases or Tables (RDS for MySQL)
Querying Tables That Can Be Restored to a Specified Point in Time (RDS for PostgreSQL)
Querying Databases That Can Be Restored to a Specified Point in Time
Restoring Tables to a Specified Point in Time (RDS for PostgreSQL)
Restoring Databases to a Specified Point in Time
Querying Databases Contained in a Database-Level Backup (RDS for PostgreSQL)
Configuring an Automatic Transfer Policy (RDS for MySQL)
Transferring Backups to an OBS Bucket (RDS for MySQL)
Querying Automatic Transfer Policies (RDS for MySQL)
Querying Transfer Tasks (RDS for MySQL)
Querying Merged Binlog Files for Download
Upgrading a Major Version (RDS for PostgreSQL)
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)
Upgrading a Major Version (RDS for MySQL)
Performing a Pre-upgrade Check
Obtaining the Pre-Check Results of an Upgrade from MySQL 5.7 to MySQL 8.0
Upgrading the Major Version of an RDS for MySQL Instance
Sessions (RDS for MySQL)
Killing Sessions
Querying the Killing History
Querying Real-Time Statistics of Killing Sessions (RDS for MySQL)
Log Information Queries
Querying Slow Query Logs Through LTS
Querying Error Logs Through LTS
(Recommended) Querying Database Error Logs
(Recommended) Querying Slow Query Logs
Showing Original Logs
Querying Slow Query Log Files (SQL Server)
Querying Extended Logs (RDS for SQL Server)
Obtaining Links for Downloading Extended Logs (RDS for SQL Server)
Obtaining Links for Downloading Slow Query Logs
Obtaining Links for Downloading Error Logs (RDS for PostgreSQL)
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining Audit Logs
Obtaining the Links for Downloading Audit Logs
Setting the Local Retention Period of Binlogs
Obtaining the Local Retention Period of Binlogs
Querying LTS Configurations
Enabling Log Ingestion to LTS for Instances in Batches
Disabling Log Ingestion to LTS for Instances in Batches (RDS for MySQL)
Querying the Configurations for Ingesting Instance Logs to LTS (RDS for MySQL)
Monitoring and Alarms
Configuring a Monitoring by Seconds Policy
Querying a Monitoring by Seconds Policy
Querying the Automatic Alarm Configuration of the Current User
Instance Diagnosis
Obtaining the Number of Instances After Diagnosis
Obtaining the Result of a Specific Diagnosis Item
SQL Throttling (RDS for PostgreSQL)
Adding a SQL Throttling Rule for a Database
Deleting a SQL Throttling Rule
Modifying a SQL Throttling Rule
Querying SQL Throttling Rules
Enabling or Disabling a SQL Throttling Rule or Disabling All SQL Throttling Rules
Database Proxy (RDS for MySQL)
Enabling Database Proxy
Querying Database Proxies
Querying Database Proxy Specifications
Configuring the Routing Policy for a Database Proxy
Disabling Database Proxy
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying 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
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
Querying Tables Without Indexes
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
Updating Database Statistics
Publications and Subscriptions (RDS for SQL Server)
Querying Subscriber Instances
Creating Subscriptions
Querying Publications of a DB Instance
Deleting Publications
Querying Distributors
Modifying a Publication
Querying Distributor Instances
Deleting Subscriptions
Deleting Distributors of a DB Instance
Querying Monitoring Information of a Publication
Querying Monitoring Information of a Subscription
Testing Connectivity
Querying Subscriptions of a DB Instance
Querying Publication and Subscription Profiles of a DB Instance
Batch Modifying Subscriptions
Querying Available Publications for a DB Instance
Querying Agent Jobs
Querying the Execution History of an Agent Job
Regenerating a Publication Snapshot
Regenerating a Subscription
Synchronizing Publication and Subscription Metadata
Querying the Historical Execution Steps of an Agent Job
Modifying an Agent Job
Restarting an Agent Job
Disabling an Agent Job
Querying Remote Databases
Creating a Distributor
Creating a Publication
Batch Modifying Publications
Querying Subscription Errors
Parameter Management
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Querying Application Records of a Parameter Template
Querying Instances That a Parameter Template Is Applied to
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
Comparing Parameter Templates
Resetting a Custom Parameter Template
Extension Management (RDS for PostgreSQL)
Creating an Extension
Querying Extensions
Updating an Extension
Deleting an Extension
Modifying the Value of a Specified Parameter for an Instance
Obtaining the Value of a Specified Parameter for an Instance
Configuring Replication Delay for a Read Replica (RDS for PostgreSQL)
Obtaining the Delayed Replay Status of WAL Logs
Querying the Recovery Time Window of WAL Logs
Pausing or Resuming WAL Log Replay
Querying the Databases That Can Be Restored to the Primary DB Instance from a Read Replica
Restoring a Database from a Read Replica to the Primary DB Instance
Events
Querying Events
Operating Events Reported by EG
Recycling a DB Instance
Modifying Recycling Policy
Querying the Recycling Policy
Querying Instances in the Recycle Bin
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Querying Tags of a DB Instance
Quota Management
Querying Resource Quotas
Obtaining Task Information
Querying Scheduled Tasks
Querying Instant Tasks
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified DB Instance in a Specified Time Range (RDS for SQL Server)
Deleting an Instant Task Record
Obtaining Task Information
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)
Obtaining Slow Query Log Statistics (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
Actions Supported by Policy-based Authorization
Actions Supported by Identity Policy-based Authorization
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode
Monitoring Metrics
RDS for MySQL Metrics
RDS for PostgreSQL Metrics
RDS for SQL Server Metrics
Idempotent Requests
SDK Reference
SDK Overview
FAQs
Troubleshooting
Videos
Glossary
More Documents
User Guide (ME-Abu Dhabi Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Getting Started with RDS for SQL Server
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to RDS for MySQL
Restoring a DB Instance to a Point in Time
Restoring a Table to a Specified Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Permissions to a User
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password
Changing Permissions
Deleting an Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring from Backup Files to RDS for PostgreSQL
Downloading a Backup File
Downloading an Incremental Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
Managing Tags
Working with RDS for SQL Server
Instance Management
Creating a Same DB Instance
Rebooting a DB Instance
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introduction to Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Intra-Region Backup Policy
Creating a Manual Backup
Restoring from Backup Files to RDS for SQL Server
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing and Downloading System Logs
Viewing and Downloading Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating an Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
Managing Tags
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify Data Corruption?
API Reference (ME-Abu Dhabi Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
Querying the Storage Type of a Database
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Querying the Available SQL Server Character Set
Deleting a DB Instance
Querying Details About DB Instances
Binding and Unbinding an EIP
Resetting a Database Password
Changing the Failover Priority
Manually Switching Primary/Standby DB Instances
Changing the Data Synchronize Model of Primary/Standby DB Instances
Migrating a Standby DB Instance
Configuring the Maintenance Window
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Private IP Address
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing DB Instance
Restoring Tables to a Specified Point in Time (MySQL)
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Database and Account Management (MySQL)
Precautions
Creating a Database
Querying Details About Databases
Querying Authorized Databases of a Specified User
Deleting a Database
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Configuring a Password for a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Database and Account Management (Microsoft SQL Server)
Querying Details About Databases
Creating a Database Account
Querying Details About Database Users
Querying Authorized Users of a Specified Database
Deleting a Database Account
Authorizing a Database Account
Revoking Permissions of a Database Account
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Paris Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Related Services
Getting Started with RDS for MySQL
Connecting to a DB Instance
Connecting to a MySQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through a Private Network
Connecting to a MySQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Overview
Step 1: Create a DB Instance
Step 2: Configure Security Group Rules
Step 3: Connect to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Overview
Step 1: Create a DB Instance
Step 2: Bind an EIP
Step 3: Configure Security Group Rules
Step 4: Connect to a DB Instance Through psql
Working with RDS for MySQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Restoring a DB Instance from a Backup
Restoring a DB Instance to a Point in Time
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Suggestions on Tuning MySQL Parameters
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Configuring a Security Group Rule
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Error Logs
Viewing Slow Query Logs
Viewing Failover/Switchover Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Instance Management
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling Up Storage Space
Rebooting a DB Instance
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Selecting Displayed Items
Exporting DB Instance Information
Creating a Same DB Instance
Deleting a DB Instance or Read Replica
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Restoring a DB Instance to a Point in Time
Restoring a DB Instance from a Backup
Downloading a Backup File
Replicating a Backup
Deleting a Manual Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing the Database Port
Connecting to a DB Instance Through pgAdmin
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Log Management
Viewing Slow Query Logs
Task Center
Viewing a Task
Deleting a Task Record
Plugin Management
Creating and Deleting a Plugin
Plugins Supported By RDS for PostgreSQL
FAQs
Product Consulting
What Precautions Should Be Taken When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other Users' DB Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Can I Do About Websites Responding Slower After Using RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
Can I Access an RDS DB Instance Over an Intranet Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
Does MySQL Support SSL Connections?
Why Does the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump and pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permission?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
Backup and Restoration
How Long Does RDS Store Backup Data?
Can My Database Be Used in the Backup Window?
How Can I Back Up RDS Databases to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Most Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Log Management
How Long Is the Delay of RDS MySQL Slow Query Logs?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to the Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
API Reference (Paris Region)
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
Selecting an API Type
API Overview
Calling APIs
Making an API Request
Authentication
Response
Obtaining an API Version
Querying API Versions
Querying a Specified API Version
API v3 (Recommended)
Querying Version Information About a DB Engine
Querying Database Specifications
DB Instance Management
Creating a DB Instance
Changing DB Instance Specifications
Scaling Up Storage Space of a DB Instance
Changing a Single DB Instance to Primary/Standby DB Instances
Rebooting a DB Instance
Deleting a DB Instance
Querying Details About DB Instances
Parameter Configuration
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Applying a Parameter Template
Modifying Parameters of a Specified DB Instance
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
Backup and Restoration
Setting an Automated Backup Policy
Obtaining an Automated Backup Policy
Creating a Manual Backup
Obtaining Details About Backups
Obtaining the Link for Downloading a Backup File
Deleting a Manual Backup
Querying the Restoration Time Range
Restoring Data to a New DB Instance
Restoring Data to an Existing or Original DB Instance
Log Information Queries
Querying Database Error Logs
Querying Database Slow Logs
Tag Management
Adding Tags in Batches
Deleting Tags in Batches
Querying Project Tags
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode Table
RDS Monitoring Metrics Description
User Guide (Kuala Lumpur Region)
Introduction
What Is RDS?
Basic Concepts
Advantages
Easy Management
High Security
High Reliability
Comparison Between RDS and Self-Built Databases
Product Series
DB Instance Introduction
Function Comparison
DB Instance Description
DB Instance Types
DB Instance Classes
DB Engines and Versions
DB Instance Statuses
Typical Applications
Read/Write Splitting
Constraints
MySQL Constraints
PostgreSQL Constraints
Microsoft SQL Server Constraints
Related Services
Getting Started with RDS for MySQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Getting Started with RDS for PostgreSQL
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a PostgreSQL DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Connecting to a PostgreSQL DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through psql
Getting Started with RDS for SQL Server
Operation Guide
Step 1: Create a DB Instance
Step 2: Connect to a DB Instance
Connecting to a DB Instance
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Private Network
Configuring Security Group Rules
Connecting to a DB Instance Through a Private Network
Connecting to a DB Instance Through a Public Network
Connecting to a DB Instance Through a Public Network
Binding an EIP
Configuring Security Group Rules
Connecting to a DB Instance Through a Public Network
Working with RDS for MySQL
Data Migration
Migrating Data to RDS for MySQL Using mysqldump
Parameter Tuning
Suggestions on MySQL Parameter Tuning
MySQL Kernel Functions
Kernel Version Description
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Upgrading a Major Version
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing the Maintenance Window
Changing a DB Instance Type from Single to Primary/Standby
Promoting a Read Replica Into a Single DB Instance
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Setting a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Backup File
Downloading a Binlog Backup File
Setting a Local Retention Period for MySQL Binlogs
Restoring from Backup Files to DB Instances
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Downloading a Certificate
Configuring a Security Group Rule
Database Management
Creating a Database
Granting Database Permissions
Deleting a Database
Enabling or Disabling Event Scheduler
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for a Database Account
Deleting a Database Account
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
Metrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Viewing Failover/Switchover Logs
Enabling the SQL Audit Function
Downloading SQL Audit Logs
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for PostgreSQL
Data Migration
Migrating Data to RDS for PostgreSQL Using psql
Parameter Tuning
Suggestions on PostgreSQL Parameter Tuning
PostgreSQL Enhanced Edition
Introduction to PostgreSQL Enhanced Edition
Functions
System Views
Data Types
Implicit Type Conversion
Predefined Parameters
Macro Variables
Operators
Syntax
Enhanced Functions
Security Hardening
Other Functions
PostgreSQL Kernel Functions
RDS for PostgreSQL Kernel Release History
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Migrating a Standby DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Set a Cross-Region Backup Policy
Creating a Manual Backup
Downloading a Full Backup File
Downloading an Incremental Backup File
Restoring from Backup Files to RDS for PostgreSQL
Restoring a DB Instance to a Point in Time
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Instance Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Connecting to a DB Instance Through pgAdmin
Plugin Management
Creating or Deleting a Plugin
Supported Plugins
Database Account Security
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
Working with RDS for SQL Server
Instance Lifecycle
Creating a Same DB Instance as an Existing DB Instance
Rebooting DB Instances or Read Replicas
Selecting Displayed Items
Exporting DB Instance Information
Deleting a Pay-per-Use DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Changing a DB Instance Class
Scaling up Storage Space
Changing a DB Instance Type from Single to Primary/Standby
Manually Switching Between Primary and Standby DB Instances
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Backups and Restorations
Working with Backups
Configuring an Automated Backup Policy
Creating a Manual Backup
Downloading a Backup File
Restoring from Backup Files to RDS for SQL Server
Replicating a Backup
Parameter Template Management
Creating a Parameter Template
Modifying Parameters
Exporting a Parameter Template
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Connection Management
Configuring and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Data Security
Resetting the Administrator Password
Changing a Security Group
and AlarmsMetrics and Alarms
Configuring Displayed Metrics
Setting Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
Usage of Stored Procedures
Creating a Database Account
Updating Information About Operators for Alerts and Jobs
Removing Alerts
Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Removing Operators
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
What Is the Availability of RDS DB Instances?
Can I Use a Template to Create DB Instances?
What Are the Differences Between RDS and Other Database Solutions?
Will My RDS DB Instances Be Affected by Other User Instances?
Does RDS Support Cross-AZ High Availability?
Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
How Do I Create an AD Domain?
What Can I Do About Slow Respond of Websites When They Use RDS?
How Does a Cloud Database Perform a Primary/Standby Switchover?
Can Multiple ECSs Connect to the Same RDS DB Instance?
Why Is an Error Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
Resource and Disk Management
Which Types of Logs and Files Occupy RDS Storage Space?
Which Items Occupy the Storage Space of My RDS DB Instances?
What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
How Much Storage Space Is Required for DDL Operations?
How Many DB Instances Can Run on RDS?
How Many Databases Can Run on an RDS DB Instance?
Database Connection
Can an External Server Access the RDS Database?
What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to an RDS DB Instance?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If an RDS Database Problem Causes a Connection Failure?
How Do My Applications Access an RDS DB Instance in a VPC?
Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
How Can I Connect to a PostgreSQL Database Through JDBC?
What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
Does MySQL Support SSL Connections?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
Database Migration
Why Do I Need to Use the mysqldump or pg_dump Tools for Migration?
What Types of DB Engines Does RDS Support for Importing Data?
Database Permission
Why Does the Root User Not Have the Super Permissions?
Database Storage
What Storage Engines Does the RDS for MySQL Support?
What Is the RDS DB Instance Storage Configuration?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
What Should I Do If My Data Exceeds the Available Storage of an RDS DB Instance?
Client Installation
How Can I Install the MySQL Client?
How Can I Install the PostgreSQL Client?
How Can I Install SQL Server Management Studio?
Backup and Restoration
How Long Does RDS Store Backup Data For?
Can My Database Be Used in the Backup Window?
How Can I Back Up an RDS Database to an ECS?
Why Has My Automated Backup Failed?
What Happens to Database Backups After an RDS DB Instance Is Deleted?
Will My Backups Be Deleted If I Delete My Cloud Account?
Why Is a Table or Data Missing from My Database?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
Capacity Expansion and Specification Change
Are My RDS DB Instances Available When Scaling?
Why Does the DB Instance Become Faulty After the Original Database Port Is Changed?
Database Parameter Modification
What Inappropriate Parameter Settings Cause Unavailability of the PostgreSQL Database?
Where Should I Store the NDF Files for Microsoft SQL Server?
How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
Log Management
How Long Is the Delay for RDS MySQL Slow Query Logs?
What's the Slow Query Threshold for Microsoft SQL Server?
How Can I Obtain Microsoft SQL Server Error Logs Using Commands?
Can I Export Statistics on RDS Slow Query Logs?
Network Security
What Security Protection Policies Does RDS Have?
How Can I Ensure the Security of RDS DB Instances in a VPC?
How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
How Can I Import the Root Certificate to a Windows or Linux OS?
How Can I Identify the Validity Period of an SSL Root Certificate?
How Can I Identify Data Corruption?
Troubleshooting
RDS for MySQL
Backup and Restoration Issues
Backup Failures Due to DDL Operations
RDS for MySQL Backup Job Failure
Manual Backups Taking More Time Than Automated Full Backups
Automated Incremental Backup Failed Due to Full Storage
Precautions for Exporting Large Tables Through mysqldump
Commands for Exporting Data Through mysqldump
SQL Statements Such as SET @@SESSION.SQL_LOG_BIN Displayed After You Run mysqldump
Insufficient Permissions During Data Export Using mysqldump
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
Parameter-related Issues
long_query_time Changes Fail to Take Effect
Incorrect GROUP_CONCAT Results
[ERROR] 1071 Reported When an Index Fails to Be Created for RDS for MySQL
Tables Failed to Be Found After Case-Sensitivity Setting Changes for RDS for MySQL
Timeout Parameters
Performance Issues
DB Instance Becoming Read-Only Due to Full Storage
High Storage Usage Due to Uncleared Old Binlogs
Read Replica Occupies Far More Storage Than the Primary Instance
Slow SQL Execution Due to Hot and Cold Data Problems
Tablespace Bloat
Full Storage Caused by Complex Queries
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 Space Occupied by Undo Logs Due to Long Transactions
SQL Issues
Error 1366 Reported When Data Containing Emojis Is Updated
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
Server Error Message 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
Equivalent Comparison Failures with Floating-Point Numbers
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
Connection Issues
"Access denied" Displayed During Database Connection
Error Message "connection established slowly"
SSL Connection Failed Due to Inconsistent TLS Versions
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
Other Issues
Auto-increment Field Values
Starting Value and Increment of AUTO_INCREMENT
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
Impact of Creating an Empty Username
Connection to a Primary/Standby DB Instance Suspended Using pt-osc
RDS for SQL Server
Failed to Bind a New User to an RDS for SQL Server DB Instance That Was Recovered from Backups
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
User Guide (Ally Region)
Service Overview
What Is RDS?
Advantages
Easy Management
High Performance
High Security
High Reliability
Comparison Between RDS and On-Premises Databases
Typical Use Cases
Product Series
RDS for MySQL 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
Function Differences Among Standard 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 PostgreSQL Instance Classes
RDS for SQL Server Instance Classes
Permissions
Constraints
RDS for MySQL Constraints
RDS for PostgreSQL Constraints
RDS for SQL Server Constraints
Related Services
Basic Concepts
Getting Started with RDS for MySQL
Buying an RDS for MySQL Instance and Connecting to It Through DAS
Buying an RDS for MySQL Instance and Connecting to It Using a MySQL Client
Buying an RDS for MySQL Instance and Connecting to It Using MySQL-Front
Getting Started with RDS for PostgreSQL
Buying an RDS for PostgreSQL Instance and Connecting to It Using a PostgreSQL Client
Getting Started with RDS for SQL Server
Buying a Microsoft SQL Server Instance and Connecting to It Using the SSMS Client
Working with RDS for MySQL
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Buying an RDS for MySQL Instance
Instance Connection
Overview
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
Connecting to an RDS for MySQL Instance Through MySQL-Front
Connecting to an RDS for MySQL Instance Through JDBC
Connection Management
Changing a Floating IP Address
Changing a Database Port
Binding and Unbinding an EIP
Configuring a Certificate
Configuring Security Group Rules
Database Usage
Guidelines
Instance Usage Guidelines
Database Usage Suggestions
Database Management
Creating a Database
Modifying Database Remarks
Granting Database Permissions
Deleting a Database
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
Version Upgrade
Upgrading a Minor Version
Upgrading an RDS for MySQL Instance from 5.7 to 8.0
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 a DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Replication Mode
Changing the Failover Priority
Enabling or Disabling Event Scheduler
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
Changing the AZ of a Standby DB Instance
Data Backups
Introduction to Backups
Backup Types
Performing Backups
Configuring a Same-Region Backup Policy
Configuring a Cross-Region Backup Policy
Creating a Manual Backup
Replicating a Backup
Managing Backups
Downloading a Full Backup
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
Cleaning Up Binlogs
Data Restorations
Restoration Solutions
Restoring Data to RDS for MySQL
Restoring a DB Instance from Backups
PITR: Restoring a DB Instance to a Point in Time
PITR: Restoring Databases or Tables to a Point in Time
Restoring Data to a Self-Managed MySQL Database
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Database Proxy (Read/Write Splitting)
Introduction to RDS for MySQL Database Proxies
Constraints on Database Proxy
Enabling Database Proxy for Read/Write Splitting
Database Proxy Configurations
Rules for Distributing Weights
Configuring the Delay Threshold and Routing Policy
Changing the Number of Proxy Nodes
Changing the Instance Class of a Proxy Instance
Database Proxy Lifecycle
Disabling Read/Write Splitting
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
Troubleshooting Slow SQL Issues for RDS for MySQL DB Instances
Security and Encryption
Database Account Security
Resetting the Administrator Password
Changing a Security Group
Performing a Server-Side Encryption
Configuring an SSL Connection
Unbinding an EIP
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
Modifying a Parameter Template Description
Deleting a Parameter Template
Viewing Parameter Change History
Suggestions on RDS for MySQL Parameter Tuning
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query LogsViewing 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
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing Task Details
Deleting a Task Record
RDS for MySQL Tags
Working with RDS for PostgreSQL
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Buying an RDS for PostgreSQL Instance
Instance Connection
Connecting to an RDS for PostgreSQL Instance
Connecting to an RDS for PostgreSQL Instance Through the psql CLI Client
Connecting to a DB Instance from a Linux ECS over a Private Network
Connecting to a DB Instance from a Linux ECS over a Public Network
Connecting to an RDS for PostgreSQL Instance Using pgAdmin
Connecting to an RDS for PostgreSQL Instance Through JDBC
Connection Management
Viewing and Changing a Floating IP Address
Configuring SSL Encryption
Binding and Unbinding an EIP
Changing a Database Port
Adding Instance Routes
Configuring Security Group Rules
Database Usage
Guidelines
Instance Usage Guidelines
Database Usage Suggestions
Accounts (Non-Administrator)
Creating an Account
Resetting a Password for a Database Account
Modifying Remarks of a Database Account
Deleting an Account
Modifying pg_hba.conf
Viewing the pg_hba Change History
Tablespace Management
Database Migration
Migration Solution Overview
Migrating Data to RDS for PostgreSQL Using psql
Version Upgrade
Upgrading a Minor Version
Upgrading the Major Version of a DB Instance Using SQL Commands
Upgrading the Major Version of a DB Instance on the Console
Instance Management
Instance Lifecycle
Creating 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 DB Instance or Read Replica
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Replication Mode
Changing the Failover Priority
Changing a DB Instance Class
Scaling Storage Space
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
Data Backups
Introduction to Backups
Backup Types
Instance-Level Backups
Configuring a Same-Region Backup Policy
Creating a Manual Backup
Replicating a Backup
Managing Backups
Downloading an Instance-Level Backup
Downloading an Incremental Backup File
Checking and Exporting Backup Information
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring Data to RDS for PostgreSQL
Restoring a DB Instance from Backups
PITR: Restoring a DB Instance to a Point in Time
Restoring Databases or Tables to a Point in Time
Restoring Data to an On-Premises PostgreSQL Database from a Full Backup
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
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
pgAudit
rds_pg_sql_ccl
Common Performance Problems
High CPU Usage of RDS for PostgreSQL Instances
Account and Network Security
Database Account Security
Resetting the Administrator Password
Changing a Security Group
Performing a Server-Side Encryption
Parameters
Modifying Parameters of an RDS for PostgreSQL Instance
Parameter Templates
Creating a Parameter Template
Applying a Parameter Template
Resetting a Parameter Template
Replicating a Parameter Template
Comparing Parameter Templates
Exporting a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Viewing Parameter Change History
Viewing Application Records of a Parameter Template
Suggestions on RDS for PostgreSQL Parameter Tuning
Log Management
Log Reporting
Viewing and Downloading Error Logs
Viewing and Downloading Slow Query Logs
Enabling SQL Audit
Downloading SQL Audit Logs
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing Task Details
Deleting a Task Record
RDS for PostgreSQL Kernel Functions
RDS for PostgreSQL Kernel Version Description
Failover Slot for Logical Subscriptions
RDS for PostgreSQL Tags
Working with RDS for SQL Server
Permissions Management
Creating a User and Granting Permissions
RDS Custom Policies
Buying an RDS for SQL Server Instance
Instance Connection
Connecting to an RDS for SQL Server Instance
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
Connection Management
Viewing and Changing a Floating IP Address
Binding and Unbinding an EIP
Changing a Database Port
Configuring Security Group Rules
Database Usage
Guidelines
Database Migration
Migrating Data to RDS for SQL Server Using SQL Server Management Studio
Instance Lifecycle
Creating 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 DB Instance
Recycling a DB Instance
Instance Modifications
Changing a DB Instance Name
Changing the Failover Priority
Cloning a DB Instance
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
Changing a Character Set
Data Backups
Introduction to Backups
Backup Types
Performing Backups
Configuring a Same-Region Backup Policy
Creating a Manual Backup
Replicating a Backup
Managing Backups
Downloading a Backup File
Checking and Exporting Backup Information
Deleting a Manual Backup
Data Restorations
Restoration Solutions
Restoring Data to RDS for SQL Server Instances from Backups
Restoring from Backup Files to a Self-Managed SQL Server Database Using SSMS
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Common Performance Problems
High CPU Usage of RDS for SQL Server Instances
Account and Network Security
Database Account Security
Resetting the Administrator Password
Changing a Security Group
Performing a Server-Side Encryption
Parameters
Modifying RDS for SQL Server Instance Parameters
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
Modifying a Parameter Template Description
Deleting a Parameter Template
Viewing Parameter Change History
Viewing Application Records of a Parameter Template
CLR Integration
Default Language Setting for RDS for SQL Server
Log Management
Viewing and Downloading System LogsViewing System Logs
Viewing and Downloading Audit Logs
Viewing and Downloading Slow Query Logs
Publications and Subscriptions
Creating a Publication
Creating a Subscription
Monitoring Jobs
Metrics and Alarms
Configuring Displayed Metrics
Viewing Monitoring Metrics
Setting Alarm Rules
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing Task Details
Deleting a Task Record
RDS for SQL Server Tags
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
FAQs
Product Consulting
What Should I Pay Attention to When Using RDS?
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?
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 Instances Be Changed to Single-Node Instances?
Can I Encrypt the Disk After Purchasing an RDS DB Instance?
What Encryption Functions Does RDS for MySQL Support?
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 Many Databases Can Run on an RDS DB Instance?
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 RDS Instances I Have Created?
How Much Storage Space Is Required for DDL Operations?
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 My RDS for SQL Server Instance Failed to Be Connected?
Can an External Server Access the RDS Database?
How Can I Obtain the IP Address of an Application?
How Can I Create and Connect to an ECS?
Will My Access Be Restricted by Bandwidth When I Connect to My Instance from an ECS over a Private Network?
How Do I View All IP Addresses Connected to a Database?
Database Migration
What Types of DB Engines Does RDS Support for Importing Data?
Why Do I Need to Use the mysqldump for Migration?
Why Do I Need to Use the pg_dump 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?
How Do I View Authorized Databases After a Local Client Is Connected to an RDS DB Instance?
Does RDS for MySQL Support Multiple Accounts?
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?
Can I Change the Storage Type of an RDS DB Instance from Common I/O to Ultra-high I/O?
Database Usage
How Do I View Session IDs and Login and Logout Time of an RDS Database?
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?
How Do I Create an AD Domain for RDS for SQL Server?
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 Clean Up 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?
Will Backups Be Retained After My RDS Instance Is Deleted?
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?
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 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 Configure the test_decoding Extension for My RDS for PostgreSQL Instance?
Where Should I Store NDF Files for RDS for SQL Server?
Log Management
How Long Is the Delay of RDS for MySQL Slow Query Logs?
How Do I View Logs of All SQL Statements Executed by My RDS for MySQL Instance?
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?
What Security Protection Policies Does RDS Have?
How Do I Configure a Security Group to Enable Access to RDS DB Instances?
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 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
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
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 Unpurged 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
SQL Issues
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
Connection Issues
"Access denied" Displayed During Database Connection
Error Message "connection established slowly"
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
Other Issues
No Scanned Rows Recorded in Slow Query Logs
Viewing Storage of RDS DB Instances
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
RDS for SQL Server
Failed to Bind a New User to an RDS for SQL Server DB Instance That Was Recovered from Backups
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?
API Reference (Ally Region)
Before You Start
Overview
API Calling
Constraints
Concepts
API Types
API Overview
Calling APIs
Making an API Request
Authentication
Response
API v3.1 (Recommended)
Applying a Parameter Template
Modifying Parameters of a Specified Instance
Restoring Data to an Existing DB Instance
Deleting a Database (RDS for SQL Server)
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
DB Instance Management
Creating a DB Instance
Stopping an Instance
Starting an Instance
Changing a DB Instance Name
Querying the Auto Scaling Policy of 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 DB Instances
Migrating a Standby DB Instance
Database Security
Configuring SSL
Changing a Database Port
Changing a Security Group
Changing a Floating IP Address
Backup and Restoration
Setting an Automated Backup Policy
Setting a Cross-Region Backup Policy
Obtaining an Automated Backup Policy
Querying Information About a Cross-Region Backup Policy
Creating a Manual Backup
Obtaining Backups
Querying Cross-Region Backups
Querying DB Instances for Which Cross-Region Backups Are Created
Obtaining the Link for Downloading a Backup
Deleting a Manual Backup
Querying the Restoration Time Range
Querying the Restoration Time Range of a Cross-Region Backup
Restoring Data to a New DB Instance
Restoring Tables to a Specified Point in Time (RDS for MySQL)
Log Information Queries
Setting the Local Retention Period of Binlogs
Obtaining the Local Retention Period of Binlogs
Database and Account Management (MySQL)
Creating a Database
Querying Databases
Modifying the Database Remarks of a Specified DB Instance
Deleting a Database
Creating a Database Account
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 Account
Creating a Database Schema
Resetting a Password for a Database Account
Querying Databases
Querying Database Users
Querying Database Schemas
Modifying the Database Remarks of a Specified DB Instance
Modifying Remarks of a Database Account
Deleting a Database Account
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
Querying Databases
Creating 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
Parameter Management
Obtaining a Parameter Template List
Creating a Parameter Template
Modifying a Parameter Template
Obtaining the Parameter Template of a Specified DB Instance
Obtaining Parameters in a Specified Parameter Template
Deleting a Parameter Template
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
Quota Management
Querying Resource Quotas
Obtaining Task Information
Obtaining Information About a Task with a Specified ID
Obtaining Task Information of a Specified DB Instance in a Specified Time Range (RDS for SQL Server)
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Replication Mode
RDS Monitoring Metrics Description
General Reference
Glossary
Shared Responsibilities
Service Level Agreement
White Papers
Endpoints
Permissions