Getting Started with Common Practices

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).