Operations Guide SOP (Operations Manual)

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 运维指南 SOP（运维手册）

| username: Billmay表妹

【SOP 42】Common Tiup Commands

【SOP Series 41】TiDB Cluster Installation TiDB Dashboard

【SOP Series 40】Monitoring and Alerting for TiDB Cluster Deployment with TiDB Operator

【SOP Series 39】Deploying TiDB with TiOperator

【SOP Series 38】Methods to Lock Users

【SOP Series 37】Analysis and Solutions for Insert Statement Execution Errors

【SOP Series 36】Database Backup and Restore (TiDB)

【SOP Series 35】Check Cluster Creation Time

【SOP Series 34】Bigint Maximum Value Test

【SOP Series 33】Various TiDB Cluster Monitoring Solutions

【SOP Series 32】DM Setup MySQL 8.0 Synchronization Link Error Troubleshooting

【SOP Series 31】TiDB 4.0 Cluster Migration Practice

【SOP Series 30】TiCDC Migration - TiDB to MySQL Test

【SOP Series 27】TiDB v5.3.0->v5.4.2->v6.1.0 Offline Upgrade and Scaling Guide

【SOP Series 26】Migrating AWS S3 Data to TiDB Cloud Cluster

【SOP Series 25】GC Common Issue Troubleshooting

【SOP Series 24】Slow TiKV/TiFlash Decommissioning

【SOP Series 23】Created SPM, but SQL Execution Does Not Follow Forced Index

【SOP Series 22】TiDB Cluster Diagnostic Information Collection Clinic User Guide & Data Collection

【SOP Series 21】AskTUG SQL Execution Plan Upload Specifications

【SOP Series 20】DM Incremental Synchronization Performance Diagnosis

【SOP Series 18】TiUP Environment Recovery TiKV Replica

【SOP Series 17】TiUP Environment PD-Recover Usage Recovery Case

【SOP Series 16】4.0 Online Cluster Upgrade to 5.0

【SOP Series 15】How to Deploy TiDB-Operator on Kubernetes (Part 1)

【SOP Series 15】How to Deploy TiDB-Operator on Kubernetes (Part 2)

【SOP Series 14】How to Share a Grafana Instance Among Multiple TiDB Clusters

【SOP Series 13】TiUP Adjust Single-Instance Cluster to Multi-Instance Cluster

【SOP Series 12】TiUP Modify Cluster IP, Port, and Directory

【SOP Series 11】3.0 Online Cluster Upgrade to 4.0

【SOP Series 10】How to Modify TiDB, TiKV, PD Ports in Production

【SOP Series 09】How to Modify TiDB, TiKV, PD IP Addresses in Production

【SOP Series 08】Online Cluster Scaling Operations and Key Points

【SOP Series 07】How to Enable/Disable TiDB Binlog Online

【SOP Series 06】Temporary Shutdown Maintenance for a Production Host

【SOP Series 04】How to Adjust TiKV from Single-Instance Deployment to Multi-Instance Deployment in Existing Cluster

【SOP Series 03】Online Table Structure Change (Online DDL)

【SOP Series 02】Prometheus and Other Monitoring Components Migration

2
| username: Kongdom | Original post link

:+1: :+1: :+1: Full of valuable content

3
| username: 我是咖啡哥 | Original post link

Wow, I must save this and try them one by one. :+1::+1::+1:

4
| username: ffeenn | Original post link

First, bookmark this. It will definitely come in handy. :+1:

5
| username: 考试没答案 | Original post link

Awesome. Full of valuable content.

6
| username: Billmay表妹 | Original post link

Some manuals might be a bit outdated, so I was thinking if we could take this essay contest as an opportunity to do an iteration.

7
| username: tony5413 | Original post link

Thank you, and sorry for the trouble, cousin.

8
| username: wzf0072 | Original post link

Thank you, cousin. This is awesome. Definitely saving it.

9
| username: ffeenn | Original post link

:+1: :+1:

10
| username: tidb菜鸟一只 | Original post link

Save it.

11
| username: Running | Original post link

Full of valuable information.

12
| username: TiDBer_P1iN1kcw | Original post link

Awesome. Full of valuable content.