Getting Started with Common Practices

Usage Rules

Design Rules

This section describes the GaussDB(for MySQL) rules for database naming, basic database design, database field design, database index design, and database permissions.

Development Rules

This section describes SQL development rules of GaussDB(for MySQL).

Read/Write Splitting

Enabling Read/Write Splitting

This section 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 section 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 section 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 section 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 section 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 section 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 section 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 section 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 section 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 section 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)

Use 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 section 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 section 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 section 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 section describes how to use DRS to synchronize data from GaussDB(for MySQL) to GaussDB(for MySQL).

From MySQL to GaussDB(for MySQL)

This section 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 section describes how to use DRS to synchronize data from self-managed Oracle databases to GaussDB(for MySQL).