Help Center/ TaurusDB/ Getting Started/ Getting Started with Common Practices
Updated on 2024-12-30 GMT+08:00

Getting Started with Common Practices

After purchasing and connecting to a TaurusDB instance, you can view common practices to better use TaurusDB.

Table 1 Common practices

Practice

Description

Read/Write splitting

How to Use a Proxy Instance to Enable Read/Write Splitting

This practice describes how to enable read/write splitting, so that read and write requests can be automatically routed through a proxy address.

Enabling Transaction Splitting for a Proxy Instance

This practice describes how to configure transaction splitting for a database proxy instance. With this function enabled, TaurusDB can route the read requests prior to write operations in a transaction to read replicas, reducing the pressure on the primary node.

Changing Read Weights of Nodes

This practice describes how to configure read weights of the primary node and read replicas after read/write splitting is enabled.

Data backups

Configuring a Same-Region Backup Policy

This practice describes how TaurusDB 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 a DB Instance from Backups

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 Tables to a 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 TaurusDB

This practice describes how to use Data Replication Service (DRS) to migrate table, database, or instance data of the source to the destination TaurusDB.

Migrating Data to TaurusDB Using mysqldump

This practice describes how to use mysqldump to copy data of the source to the destination TaurusDB.

From ECS-hosted MySQL to TaurusDB

This practice describes how to use DRS to migrate data from ECS-hosted MySQL databases to TaurusDB.

From Other Cloud MySQL to TaurusDB

This practice describes how to use DRS to migrate data from MySQL databases on other clouds to TaurusDB.