Help Center
Relational Database Service (MySQL)
Updates &Notices
【Change】 Discontinuation of Object Storage Backup Type of MySQL on eSurfing Cloud HK2 from June 13, 2025
Introduction
What is a Relational Database？
Product Features
Product Advantages
Overview of Product Features
Instance Description
Typical Applications
Security
Constraints and Restrictions
Relationship with Other Services
Explanation of Terminology
Billing Instructions
Product Fees
MySQL Single Instance
MySQL Primary/Standby Instances
MySQL Read-Only Instances
Storage
Backup
Billing Mode
Annual/Monthly Package
Billing as Per Use
Backup Billing Rules
Change of Billing Mode
Product Renewing and Unsubscribing
Expiration and Arrears
Quick Start
Operation Guide
Introduction of Instance Connection Mode
Connecting MySQL Instance Through the Intranet
Step 1: Create an instance
Step 2: Set the security group rules
Step 3: Connect the MySQL instance through the Intranet
Connecting MySQL Instance Through the Internet
Step 1: Create an instance
Step II: Configuring Security Group Rules
Step III: Binding the EIP
Step IV: Connecting to a MySQL Instance
Example: Purchasing and Connecting to a MySQL Instance
User Guide
Overview of Usage Rules
Instance Usage Rules
Database Usage Rules
Instance Management
Modifying the Instance Name
Modifying the Instance Password
Restarting an Instance
Parameter Settings
Renewal
Unsubscription
Modifying the Data Replication Mode
Specification Scaling
Upgrading the Database Minor Kernel Version
Master-Slave Switching
Creating Read-only
Storage Space Scaling
Backup space Scaling
Automatic Storage Space Scaling
Automatic Performance Scaling
Enabling/Disabling Instance Release Protection
Setting the Maintainable Time Period
Series Upgrading
Instance Recycle Bin
Read-only Instance
Brief Introduction to Read-only Instances
Creating Read-only Instances
Backup and Recovery
Introduction to Backup Restoration Function
Editing a Backup Policy
Creating a Manual Backup
High-Frequency Physical Backup
Deleting a Manual Backup
Restoring Schemes
Restoring an Instance from Full Backup Files
Restoring Instance Data to a Specified Time Point
Instance Overwriting Restoration
Using a Single Table in a Single Database for Restoration
Restoring from Physical Backup Files to a Self-Built Database
Local Binary Log Settings
Parameter Management
Introduction to Parameter Groups
Creating a Parameter Group
Copying a Parameter Group
Modifying Parameter Group
Deleting a Parameter Group
Comparing Parameter Groups
Restoring a Parameter Group
Applying a Parameter Group
Viewing Parameter Group Application Records
Event Management
Connecting to an Instance
Connecting to an Instance Through a General MySQL Command Line Client
Connecting to a MySQL Instance Through JDBC
Connecting to a MySQL Instance Through a Graphic User Interface
Account Management
Creating a Database User
Resetting the Account Password
Modifying Account Permissions
Deleting an Account
Custom Password Policy
Log Management
Viewing Error Logs
Viewing Slow Logs
Enabling SQL Audit Logs
Intercepting SQL
Tag Management
Creating Tags
Editing Tag
Deleting Tags
Task Center
Viewing a Task
Deleting a Task
Monitoring and Alarms
Supported Monitoring Indicators
Configuring Custom Alarm Rules
Setting Indicator Inspection
Setting Monitoring Frequency
Viewing Monitoring Indicators
Account and Security
Resetting Account Password and Root Permissions
Configuring SSL Data Encryption
Access Management
Binding and Unbinding the EIP
Modifying the Database Port
Downloading an SSL CA Certificate
Configuring an SSL CA Certificate for Accessing a MySQL Instance
Configuring Security Group Rules
Configuring the IP Trustlist
Database Management
Creating a Database
Deleting a Database
Bidirectional Synchronization
Bidirectional Synchronization between MySQL Instances
Read-Only Instance
Introduction to Read-Only Instances
Creating a Read-Only Instance
Data Migration
Database Clone
Migrating Data to MySQL Using mysqldump
Migrating MySQL Data from Other Cloud Databases
Migrating MySQL Data across eSurfing Cloud Accounts
Importing and Exporting Data with CSV Files, TXT Files, or SQL Scripts
Best Practices
Overview
MySQL Usage Specification Recommendations
Naming Criterion
Design Rules for Databases or Tables
Database Index Design Rules
Development and Use Specifications
MySQL Index Optimization Recommendations
Recommendations
Precautions
Using MySQL to Build a Cross-AZ Disaster Recovery Instance
Prerequisites
Realization Principle
Creating a Cross-AZ Disaster Recovery Instance
Setting utf8mb4 Character Set to Support Comprehensive Character Display
Configuring the Character Set of MySQL Instance
Configuring the Character Set of MySQL Instance
Unlocking Database Potential: Improving Data Service Capabilities by Matching MySQL and DRDS
Realization Principle
Prerequisites
Creating a MySQL Instance
Read/Write Separation
Performance Tuning
Locating the Causes for High CPU Usage of RDS for MySQL and Providing Solutions
Maximum IOPS Supported by RDS for MySQL
Solutions for High Memory Usage of RDS for MySQL
Improving Query Speed of RDS for MySQL
Parameter Tuning Recommendations for RDS for MySQL
Determining the Issues of RDS for MySQL Slow SQL
Insufficient Disk Space for RDS for MySQL
Resolving Database Operation Failures Caused by Metadata Locks on RDS for MySQL
Resolving High I/O for RDS for MySQL
Parameter Optimization Recommendations
Important Parameters
Recommendation of Typical Parameter Combinations
FAQ
Management Class
Instance Host Resource Management
Database Indicator Monitoring
MySQL Instance Scaling and Specification Changing
MySQL Instance Log Management
Products
Product Consultation
Instance Stopping, Unsubscription, Freezing, Releasing, and Deletion
MySQL Read-Only Instance and Read/Write Separation
Database Accounts and Permissions
Database Engines and Storage Media
Operation Issues
Database Instance Connection
Database Backup and Restoration
RDS for MySQL Parameter Modification Description
MySQL Instance Version Upgrade
Other Class
Network Security Management
Database Migration
Client Installation and Use
Database Use
Security White Paper
Security White Paper
Performance White Paper
Overview of Performance Testing
Performance Overview
Indicator Description
Testing Method
Prerequisites
Test Environment
Test Tools
Test Procedure
Test Model
Test Results
MySQL 5.7 Test Results
Test Limits
Test Results
MySQL 8.0 Test Results
Test Limits
Test Results
API Reference
API Overview
Calling the API
Terminal Node
Constructing a Request
Related Agreements
eSurfing Cloud Relational Database Service Agreement
Troubleshooting
Connection Class
What should I do if the SSL connection failes due to inconsistent client TLS version and MySQL version?
What should I do if a database cannot be connected to using the root account?
What should I do if an error message "connect established slowly" is reported on the client due to a slow connection on MySQL?
What should I do if the login fails after the authentication_string field is changed to display the password for the MySQL database?
Backup Restoration
What should I do if the backup fails due to DDL operations during the backup?
What are the precautions for exporting large tables through mysqldump?
How do I use mysqldump?
Primary/Standby Replication
What should I do if an error is reported when Canal parses Binlogs?
How primary/standby replication of MySQL work?
MySQL Primary/Standby Replication Delay Scenarios and Solutions
Automatic Recovery after Extended Primary/Standby Replication Delay
Performance Resource Class
High CPU Caused by Full Table Scanning
SQL Execution Lagging after Field Addition to a MySQL Table
Error 1461 Reported by a MySQL Database
Slow SQL Execution due to Data Migration
Other Usage Issues
Changing the AUTO_INCREMENT Value
How do I add tables to MySQL and assign values to table fields?
What should I do if the value of AUTO_INCREMENT exceeds the maximum value for this field in the table?
How does MySQL monitor the storage space?
How do I understand the value and increment of AUTO_INCREMENT in a MySQL table?
How do I view SQL audit log storage in MySQL?
Help Center
Relational Database Service (MySQL)
10035325