Overview

This document provides best practices for HUAWEI CLOUD Relational Database Service (RDS) and guides you through buying DB instances that meet your service requirements.

DB Engine

Reference

Description

MySQL

Using RDS for MySQL to Set Up WordPress

Describes how to set up WordPress in the 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 WordPress in the LAMP environment using HUAWEI CLOUD Virtual Private Cloud (VPC), Elastic Cloud Server (ECS), and RDS for MySQL.

Downloading a Backup File and Restoring Data from It

Describes how to download backup files locally and how to restore data from backup files.

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.

Identifying Why CPU Usage of RDS MySQL DB Instances Is High and Providing Solutions

Identify the reason why the CPU usage is high or even reaches 100% and how to troubleshoot this issue.

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.

PostgreSQL

Viewing Slow Query Logs of PostgreSQL DB Instances

Describes how to query and optimize PostgreSQL slow query logs.

Performing Basic Operations Using pgAdmin

Describes how to use pgAdmin to connect to RDS for PostgreSQL and create databases and tables.

Read/Write Splitting with PostgreSQL Proxy

Describes the principle and process of read/write splitting of PostgreSQL Proxy.

SQL Server

Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances

Describes the version restrictions on SQL Server backup and restoration.

Migrating Data from a Self-Built SQL Server Database on an ECS to an RDS Microsoft SQL Server DB Instance

Describes how to migrate a self-built SQL Server database on an ECS to an RDS for SQL Server DB instance.

Modifying Parameters in a Parameter Template

Describes how to modify parameter templates for Microsoft 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.

Migrating Microsoft SQL Server Data Using DRS

Describes how to migrate SQL Server data using DRS.

Create tempdb Files

Describes how to create tempdb temporary data files on RDS for SQL Server.

Microsoft SQL Server Publication and Subscription

Describes Microsoft SQL Server publication and subscription.

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 SQL Server DB Instance

Describes how to create a linked server to access another SQL Server DB instance.

How Can I Deploy the Offline SSRS Report Service on RDS for SQL Server?

Describes how to use SQL Server Reporting Services (SSRS).

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 SQL Server database.

Using DAS to Create and Configure Agent Job and DBLink on the Master and Slave Databases for SQL Server Instances

Describes how to use DAS to create and configure Agent Job and DBLink on primary and standby SQL Server DB instances.