Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【TiDB 社区每周精选】新频道 TiPerformance 首发 & TiDB 在 Pinterest丨从 HBase 到 TiDB :我们如何实现零停机在线数据迁移-20220914
TiDB at Pinterest丨From HBase to TiDB: How We Achieved Zero Downtime Online Data Migration
This article delves into how to migrate data from HBase to TiDB. Pinterest achieved zero downtime migration of a 4 TB table with 14,000 read queries and 400 write queries per second for the first time. Finally, it verifies whether this new solution can achieve 99.999% data consistency and how to measure data consistency between the two tables.
Data Verification of Master-Slave Cluster Based on TiCDC Synchronization
The high availability of the database service itself is the most important cornerstone for us to achieve the continuity of external data services. On this basis, high availability alone is not enough; we need to consider the impact on business caused by disasters at the machine room level, data center level, and site level.
TiDB Monitoring Node Scaling Operations (Whether to Retain Historical Data)
The official documentation only includes steps for scaling tikv/pd/TiDB/tiflash/ticdc, but does not mention the steps for scaling Prometheus/alertmanager/grafana. So, I thought of writing an article based on my own experience for everyone’s reference.
TiDB Cross-Version Upgrade–First Attempt by a Newcomer
This upgrade uses Dumpling+Lighting+TiDB binlog to upgrade from v3.0.8 to 5.4.0.
Connecting to TiDB Cloud Using JDBC
TiDB Cloud uses TiDB’s default configuration, supporting TLSv1.1, TLSv1.2, and TLSv1.3. When using MySQL Connector/J to connect to TiDB Cloud, whether the connection is successful depends on the JDK version and the JDBC driver version.
- BR Backup and Restore TiDB Cluster to New Cluster, Account Password Not Transferred to New Cluster
- How to Modify TiDB’s Default Database Encoding Collation?
- TiDB Concurrent Query Slow
- DDL Stuck
- Migrating MySQL Data to TiDB
【Teacher’s Day Appreciation】Thank You to the 196 Teachers Who Contributed 749 Technical Articles to Build the TiDB Column, with a Small Surprise Inside
In July 2019, the first community technical article was born: Using Gravity to Achieve Data Replication from MongoDB to TiDB. Since then, the TiDB community has had its own “technical article” section. With the improvement in the quantity and quality of content, the “column” was launched in February 2022. Thanks to everyone, a small “technical article” category has been built into a standalone “column.” From February 2022 to now, in more than half a year, the community’s evangelists have increased from 137 to 196! These 59 new forces in the community are also leading the community towards a better future together~
Click to see more
【New Channel TiPerformance Debut】TiDB Performance Overview Monitoring Panel: Introduction
In this video, we invited teachers Song Yuying and Shao Xixi from the PingCAP Performance Testing team to bring you an introductory course on the TiDB Performance Overview monitoring panel. It helps you understand the database time optimization method and color optimization method introduced in TiDB, and how to use these two methodologies to identify performance bottlenecks from top to bottom and achieve performance optimization.
Click to see more
【Chat Session 38】Love and Hate for Documentation, You Can Vent It All Here~
With product iterations, the importance of documentation is becoming increasingly evident. Complete, detailed, and easy-to-understand documentation is often a powerful tool for TiDBers to handle TiDB issues. We hope that through this survey, TiDBers can provide some case-by-case documentation suggestions and work with the documentation team to polish the documentation, so that it can help more TiDBers handle and solve technical problems encountered in daily work.
Click to participate
Here you can say everything you want to say but dare not say. Sometimes venting is to relax, to release pent-up anger, grievances, and hostility, which is more beneficial to physical and mental health. Some things, if not told to others, are because they are afraid others won’t understand and can’t empathize. So let’s huddle together for warmth!
【TiDBer Chat Session 36】How Do You Balance Family, Life, and Work?
Hi, programmers, this time our chat session won’t talk about technology, let’s chat about daily life. In many people’s perception, programmers = lots of overtime, and in life, it’s inevitable to take care of family, life, and work. So let’s discuss together.
Click to see all chat sessions
2022 Community User Upgrade Guide & Column Upgrade Article Collection
The Most Comprehensive and Latest Collection of TiFlash Source Code Interpretation Materials
TiDB SQL Read Process
TiDB SQL Write Process
More