Help Center/ TaurusDB/ Best Practices/ Summary of TaurusDB Best Practices
Updated on 2026-08-24 GMT+08:00

Summary of TaurusDB Best Practices

This document describes some detailed common practices to help you easily use TaurusDB.

Table 1 TaurusDB best practices

Category

Reference

Description

Data migration

From ECS-hosted MySQL to TaurusDB

Describes how to migrate data from self-managed MySQL databases to TaurusDB.

From Other Cloud MySQL to TaurusDB

Describes how to migrate data from MySQL databases on other clouds to TaurusDB.

Read/Write splitting

User Authentication

Describes how to grant remote login permissions to an account.

Connection Pool Configuration

Describes how to configure a connection health check mechanism.

Routing Read Requests to the Primary Node

Describes how read requests are routed to the primary instance.

Backup and restoration

Restoring Data of a Deleted Instance

Describes how to restore deleted instance data on the console.

Restoring Data of Deleted Databases

Describes how to restore deleted database data on the console.

Restoring Data of Deleted Tables

Describes how to restore deleted table data on the console.

Cold and hot data separation

Partition-Level Cold and Hot Data Separation

Describes how to implement cold and hot data separation for partitioned tables.

Database-Level Cold and Hot Data Separation

Describes how to implement database-level cold and hot data separation.

Security

Security Best Practices

Provides guidance on TaurusDB security configurations.

Monitoring alarms

Suggestions on TaurusDB Metric Alarm Configuration

Describes how to configure TaurusDB metric alarm rules.

Performance tuning

Best Practices for TaurusDB Resource Overload

Provides configuration suggestions and typical cases for common resource overload scenarios.

Best Practices for TaurusDB Large Table Optimization

Details how to efficiently manage and optimize large tables without the need for data sharding.

Kernel principles

TaurusDB Primary/Standby Replication Principles

Describes the implementation principles and main process of primary/standby replication in TaurusDB.

InnoDB Index Page Parsing

Describes the InnoDB physical file management mechanism.

InnoDB Redo Log Persistence Analysis

Describes the redo log persistence process, including the optimization points of redo logs and the interaction logic of related threads.