Getting Started with Common Practices

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

**Table 1** Common practices
Practice		Description
Read/Write splitting	Enabling Read/Write Splitting	This practice describes how to enable read/write splitting, so that read and write requests can be automatically routed through a read/write splitting address.
	Configuring Transaction Splitting	This practice describes how to configure transaction splitting for a database proxy instance. With this function enabled, GaussDB(for MySQL) can route the read requests prior to write operations in a transaction to read replicas, reducing the pressure on the primary node.
	Assigning Read Weights	This practice describes how to configure read weights of the primary node and read replicas after read/write splitting is enabled.
	Upgrading the Kernel Version of a Database Proxy Instance	This practice describes how to manually upgrade a database proxy instance to the latest kernel version to improve performance, add new functions, and fix problems.
Data backups	Configuring an Automated Backup Policy	This practice describes how GaussDB(for MySQL) automatically creates backups for a DB instance during a backup window and saves the backups based on the configured retention period.
	Creating a 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.
	Configuring a Cross-Region Backup Policy	This practice describes how to store backups in a different region from the DB instance for disaster recovery. If a DB instance in one region fails, backups from another region can be used to restore the data to a new DB instance.
Data restorations	Restoring Data to a DB Instance	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 Instance Data to a Specific Point in Time	This practice describes how to use an automated backup to restore instance data to a specified point in time.
	Restoring Table Data to a Specific Point in Time	This practice describes how to use an automated backup to restore table data to a specified point in time.
Data migration	From MySQL to GaussDB(for MySQL)	This practice describes how to use Data Replication Service (DRS) to migrate table, database, or instance data of the source to the destination GaussDB(for MySQL).
	Migrating Data to GaussDB(for MySQL) Using mysqldump	This practice describes how to use mysqldump to copy data of the source to the destination GaussDB(for MySQL).
	From ECS-hosted MySQL to GaussDB(for MySQL)	This practice describes how to use DRS to migrate data from ECS-hosted MySQL databases to GaussDB(for MySQL).
	From MySQL on Other Clouds to GaussDB(for MySQL)	This practice describes how to use DRS to migrate data from MySQL databases on other clouds to GaussDB(for MySQL).
Data synchronization	From GaussDB(for MySQL) to GaussDB(for MySQL)	This practice describes how to use DRS to synchronize data from GaussDB(for MySQL) to GaussDB(for MySQL).
	From MySQL to GaussDB(for MySQL)	This practice describes how to use DRS to synchronize data from self-managed MySQL databases or MySQL databases on other clouds to Huawei Cloud GaussDB(for MySQL).
	From Oracle to GaussDB(for MySQL)	This practice describes how to use DRS to synchronize data from self-managed Oracle databases to GaussDB(for MySQL).