Getting Started with RDS for MySQL Common Practices

After purchasing and connecting to a DB instance, you can view common practices to better use RDS for MySQL.

**Table 1** Common practices
Practice		Description
Suggestions on using RDS for MySQL	Instance Usage Suggestions	This practice provides suggestions on using RDS for MySQL in terms of DB instances, database connection, reliability and availability, backup and restoration, SQL audit, routine O&M, and security.
Suggestions on using RDS for MySQL	Database Usage Suggestions	This practice provides suggestions on database naming, database design, field design, index design, and SQL statement development.
Website setup	Using RDS for MySQL to Set Up WordPress	This practice 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.
Website setup	Using RDS for MySQL to Set Up Discuz!	This practice describes how to set up Discuz! in a LAMP environment using Huawei Cloud VPC, ECS, and RDS for MySQL.
Data migration	Migrating Data to RDS for MySQL Using mysqldump	This practice describes how to use mysqldump to copy data from the source to an RDS for MySQL DB instance.
	From RDS for MySQL to RDS for MySQL	This practice describes how to use Data Replication Service (DRS) to migrate table, database, or instance data of the source to an RDS for MySQL DB instance.
	Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS	This practice describes how to use Data Admin Service (DAS) to export data from the source and then import the data to an RDS for MySQL DB instance.
	From RDS for MySQL to RDS for MySQL	This practice describes how to use DRS to synchronize data from the source to an RDS for MySQL DB instance.
	Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS From RDS for MySQL to RDS for MySQL (Dual-Active DR)	This practice describes how to use DRS to synchronize data from the source to a DR RDS for MySQL instance.
	From DDM to RDS for MySQL	This practice describes how to use DRS to synchronize data from a DDM instance to an RDS for MySQL DB instance.
	From GaussDB Distributed to RDS for MySQL	This practice describes how to use DRS to synchronize data from a GaussDB distributed instance to an RDS for MySQL DB instance.
	From GaussDB Primary/Standby to RDS for MySQL	This practice describes how to use DRS to synchronize data from a GaussDB primary/standby instance to an RDS for MySQL DB instance.
	From GaussDB(for MySQL) to RDS for MySQL	This practice describes how to use DRS to synchronize data from a GaussDB(for MySQL) DB instance to an RDS for MySQL DB instance.
	Migrating Data from Self-Managed MySQL Databases to RDS for MySQL	This practice describes how to use DRS to migrate data from a self-managed MySQL database to an RDS for MySQL DB instance.
	From Self-Managed MySQL to RDS for MySQL	This practice describes how to use DRS to synchronize data from a self-managed MySQL database to an RDS for MySQL DB instance.
	From Self-Managed MySQL to RDS for MySQL (Single-Active DR) From Self-Managed MySQL to RDS for MySQL (Dual-Active DR)	This practice describes how to use DRS to synchronize data from a self-managed MySQL database to a DR RDS for MySQL instance.
	From Oracle to RDS for MySQL	This practice describes how to use DRS to synchronize data from a self-managed Oracle database to an RDS for MySQL DB instance.
	Migrating MySQL Databases from Other Clouds to RDS for MySQL	This practice describes how to use DRS to migrate MySQL databases from other clouds to RDS for MySQL.
	From MySQL on Other Clouds to RDS for MySQL	This practice describes how to use DRS to synchronize MySQL databases from other clouds to RDS for MySQL.
	From MySQL on Other Clouds to RDS for MySQL (Single-Active DR) From MySQL on Other Clouds to RDS for MySQL (Dual-Active DR)	This practice describes how to use DRS to synchronize MySQL databases from other clouds to DR RDS for MySQL instances.
Data backup	Intra-region automated backup	This practice describes how RDS for MySQL automatically creates backups for a DB instance during a backup window and saves the backups based on the configured retention period.
	Intra-region manual backup	This practice describes how to create manual backups for a DB instance. These backups can be used to restore data for improved reliability.
	Cross-region automated backup	This practice describes how to store backups of a DB instance in another region for disaster recovery. If the DB instance fails, the backups in another region can be used to restore the data to a new DB instance.
Data restoration	Restoring from Full Backups to RDS for MySQL Instances	This practice describes how to use an automated or manual backup to restore a DB instance to how it was when the backup was created. The restoration is at the instance level.
	Restoring a DB Instance to a Point in Time	This practice describes how to use an automated backup to restore instance data to a specified point in time.
	Restoring Databases or Tables to a Point in Time	This practice describes how to use an automated backup to restore databases or tables to a specified point in time.