Overview

This document provides best practices for Huawei Cloud Relational Database Service (RDS) and guides you through using RDS to best suit your business needs.

DB Engine	Reference	Description
MySQL	Migrating Data from Self-Managed MySQL Databases to RDS for MySQL	Describes how to migrate data from self-managed MySQL databases to RDS for MySQL.
	Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS	Describes how to use DRS to establish a remote single-active DR relationship for an RDS for MySQL instance.
	Migrating MySQL Databases from Other Clouds to RDS for MySQL	Describes how to migrate data from MySQL databases on other clouds to RDS for MySQL.
	Using RDS for MySQL to Set Up WordPress	Describes how to set up WordPress in a LAMP environment using Huawei Cloud Virtual Private Cloud (VPC), Elastic Cloud Server (ECS), and RDS for MySQL.
	Using RDS for MySQL to Set Up Discuz!	Describes how to set up Discuz! in a LAMP environment using Huawei Cloud Virtual Private Cloud (VPC), Elastic Cloud Server (ECS), and RDS for MySQL.
	Description of innodb_flush_log_at_trx_commit and sync_binlog	Describes the impact of the innodb_flush_log_at_trx_commit and sync_binlog parameters on performance and security.
	Resolving Database Operation Failures Caused by Metadata Locks on RDS for MySQL	Describes how to use Data Admin Service (DAS) to solve the issue that database operations cannot be performed due to metadata locks.
	How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?	Describes how to store emojis in an RDS for MySQL DB instance.
	Performance Tuning	Describes how to troubleshoot high vCPU usage, high memory usage, insufficient storage, and slow queries for RDS for MySQL instances.
PostgreSQL	Performing Basic Operations Using pgAdmin	Describes how to use pgAdmin to connect to RDS for PostgreSQL and create databases and tables.
	Using PoWA	Describes how to use PoWA to monitor the performance of RDS for PostgreSQL.
	Viewing Slow Query Logs of RDS for PostgreSQL DB Instances	Describes how to query slow query logs of RDS for PostgreSQL.
SQL Server	Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances	Describes the version restrictions on RDS for SQL Server backup and restoration.
	Migrating Data from a Self-Managed SQL Server Database on an ECS to an RDS for SQL Server DB Instance	Describes how to migrate a self-managed SQL Server database on an ECS to an RDS for SQL Server DB instance.
	Modifying Parameters of RDS for SQL Server Instances	Describes how to modify parameter templates of RDS for SQL Server DB instances.
	Supporting DMVs	Describes how to dynamically manage views through DMV on RDS for SQL Server.
	Using the Import and Export Function to Migrate Data from a Local Database to an RDS Microsoft SQL Server DB Instance	Describes how to migrate an on-premises SQL Server database to an RDS for SQL Server DB instance.
	Creating a Subaccount of rdsuser	Describes the permissions of the rdsuser account and how to create and manage IAM users under the rdsuser account.
	Creating tempdb Files	Describes how to create tempdb temporary data files on RDS for SQL Server.
	Microsoft SQL Server Publication and Subscription	Describes how RDS for SQL Server provides the subscription function.
	Installing a C# CLR Assembly in RDS for SQL Server	Describes how to add a c#CLR assembly on RDS for SQL Server.
	Creating a Linked Server for an RDS for SQL Server DB Instance	Describes how to create a linked server to access another RDS for SQL Server DB instance.
	Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server	Describes how to deploy SQL Server Reporting Services (SSRS) in RDS for SQL Server.
	Shrinking an RDS for SQL Server Database	Describes how to use a stored procedure to shrink the size of the data and log files in a specified RDS for SQL Server database.
	Using DAS to Create and Configure Agent Job and DBLink on the Master and Slave Databases for RDS for SQL Server Instances	Describes how to use DAS to create and configure agent jobs and DBLink on primary and standby RDS for SQL Server DB instances.
	Creating a Job for Scheduled Instance Maintenance	Describes how to create a scheduled SQL agent job to re-create indexes, update statistics, and shrink the database.