Ti Knowledge Update: High Availability Assurance of TiDB and MySQL - Disaster Recovery

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

Original topic: Ti 涨知识 上新:TiDB 与 MySQL 的高可用保障 - 灾难恢复

| username: Billmay表妹

Do you often get asked about the comparison between TiDB and MySQL in terms of high availability?

@董菲 has recently recorded a series of videos on #TiDBHighAvailability, comparing distributed databases and traditional databases in terms of high availability architecture. High availability architecture often includes three core components: Disaster Recovery, Auto Failover, and Load Balancing. TiDB, as a distributed database, differs significantly from traditional single-node databases in these aspects. The first topic focuses on #DisasterRecovery, introducing #MasterSlaveAsynchronousReplication, #SemiSynchronousReplication, #GroupReplication, and #MultiReplicaMechanismBasedOnDistributedProtocol.

Video link:

Video image sharing:



Some articles on high availability & disaster recovery

From @Gin

From @h5n1

From @代晓磊_Mars

From @cchouqiang

From @anxin

From @Liuhaoao

Documents & SOP

Q&A

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

Learn a bit.

| username: TiDBer_ok0VXN1s | Original post link

Well summarized.

| username: TiDBer_Wp | Original post link

Study and learn.

| username: 像风一样的男子 | Original post link

Study and save.

| username: 昵称想不起来了 | Original post link

Awesome, learning.

| username: tony5413 | Original post link

Bookmark for learning

| username: zhaokede | Original post link

Study and learn.

| username: Fly-bird | Original post link

Learn about it.

| username: cassblanca | Original post link

Dong Fei is the most handsome.

| username: 普罗米修斯 | Original post link

Study and save

| username: TiDBer_vfJBUcxl | Original post link

Learn a bit.

| username: waeng | Original post link

Understood. Please provide the Chinese text you need translated.