Best Practices

This chapter describes best practices for working with RDS for MySQL and provides operational guidelines that you can follow when using this service.

**Table 1** RDS for MySQL best practices
Reference	Description
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 DRS to Vertically Split Databases	Describes how to vertically split RDS for MySQL data using the DRS dual-write or splitting solution.
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.
How Do I Improve the Query Speed of My RDS for MySQL Instance?	Describes how to improve the query speed of an RDS for MySQL instance.
Handling RDS for MySQL Long Transactions	Describes how to locate and kill long-running transactions.
Configuring a Scheduled Event for an RDS for MySQL Instance	Describes how to use Data Admin Service (DAS) to configure a scheduled event for an RDS for MySQL instance.
Suggestions on RDS for MySQL Metric Alarm Configurations	Describes how to configure RDS for MySQL metric alarm rules.
Security Best Practices	Provides guidance on RDS for MySQL security configurations.