Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【最佳勤奋奖&人气奖公布】TiDB 社区专栏第二届征文大赛完美落幕啦！
|
username: Billmay表妹
With the perfect conclusion of the second TiDB Community Column Essay Contest, the judges are currently busy reviewing the submissions. The judging panel for this contest consists of moderators, the Evangelist Committee, and the PingCAP Global Education Leader, including @caiyfc, @xfworld, @代晓磊_Mars, @xuexiaogang, @数据小黑, @jiawei, @包老师呀, and @CuteRay.
A total of 58 articles were submitted by 29 participants!
Since the cloud database submission activity is a trial activity for cloud data, and the practice of cloud databases is not within the theme scope of this TiDB essay contest, articles related to cloud databases were excluded from this contest.
Contributors who submitted more than two articles include @清风明月, @pepezzzz, @tidb狂热爱好者, @weixiaobing, @buddyyuan, @gary, @gykj-sunzl, @humengyu2012, @Jellybean, and @沈阳盛京征信有限公司. Thank you!
Collection of Column Essay Contest Articles
Article submissions were accepted until June 1, 2023 (some articles from May 31 were reviewed on June 1). Likes, favorites, and traffic data were collected until 18:00 on June 1, 2023. Considering the limited number of submissions, all submitted articles will enter the review stage.
| Community Nickname | Title | Link | Likes | Visits | Favorites |
|---|---|---|---|---|---|
| @Jellybean | Real-time Cumulative Indicator Algorithm Based on TiDB+Flink Sliding Window | 专栏 - 基于TiDB+Flink实现的滑动窗口实时累计指标算法 | TiDB 社区 | 9 | 586 | 12 |
| @大数据模型 | TiDB vs MySQL: A Developer’s Perspective | 专栏 - 一名开发者眼中的TiDB与MySQL选择 | TiDB 社区 | 6 | 506 | 3 |
| @hey-hoho | TiDB SQL Tuning Case: Avoiding TiFlash Missteps | 专栏 - TiDB SQL调优案例之避免TiFlash帮倒忙 | TiDB 社区 | 10 | 370 | 7 |
| @pepezzzz | RAID Card Online Configuration for TiKV Installation on Physical Machines | 专栏 - 物理机安装 TiKV 时 RAID 卡在线配置方式 | TiDB 社区 | 0 | 322 | 0 |
| @BraveChen | Quick Forced Rollback Solution for TiDB Upgrade Failures | 专栏 - TIDB升级发生故障时，快速强行回退方案 | TiDB 社区 | 9 | 320 | 6 |
| @GangShen | Step-by-Step Guide to Modifying sysbench Code | 专栏 - 手把手教你改 sysbench 代码 | TiDB 社区 | 4 | 319 | 4 |
| @Jellybean | [v6 Certification] My Experience Preparing for PCTA/PCTP/PCSD | 专栏 - 【v6 认证】PCTA/PCTP/PCSD 我的备考经验 | TiDB 社区 | 6 | 272 | 4 |
| @caiyfc | Step-by-Step Guide to Becoming a TiDB Contributor | https://tidb.net/blog/039d338e | 11 | 261 | 11 |
| @tidb狂热爱好者 | Elegant TiDB Region Design Like Cells | 专栏 - 和细胞一样优雅的 TiDB Region 设计 | TiDB 社区 | 3 | 249 | 1 |
| @h5n1 | Summary of Troubleshooting “Region is unavailable” | 专栏 - Region is unavailable的排查总结 | TiDB 社区 | 2 | 240 | 7 |
| @清风明月 | Building a More Stable TiDB High Availability Architecture with Chaos-Mesh (Part 1) | 专栏 - 通过Chaos-Mesh打造更稳定TiDB数据库高可用架构(一) | TiDB 社区 | 2 | 203 | 3 |
| @tidb狂热爱好者 | What is ByteBase and How It Integrates with TiDB to Improve Work Efficiency | 专栏 - ByteBase是什么，他怎么和tidb结合提高工作效率的 | TiDB 社区 | 0 | 201 | 0 |
| @tidb狂热爱好者 | ByteBase: The Open Source Review Tool That Makes You Love TiDB | 专栏 - bytebase让你爱上tidb的开源审核神器。 | TiDB 社区 | 1 | 201 | 2 |
| @清风明月 | Synchronizing Data to Oracle with TiCDC+Confluent | 专栏 - TiCDC+Confluent同步数据到Oracle | TiDB 社区 | 4 | 190 | 3 |
| @buddyyuan | A Little Research on TiDB Monitoring Methods | 专栏 - 对TiDB监控方式的一点点研究 | TiDB 社区 | 2 | 190 | 2 |
| @meathill | Replacing MySQL with TiDB Cloud in WordPress | 专栏 - WordPress 使用 TiDB Cloud 替换 MySQL | TiDB 社区 | 2 | 175 | 1 |
| @tidb狂热爱好者 | How to Maintain TiDB’s Three Magic Pills: Index, SQL, and IO | 专栏 - 如何维护好TiDB的三颗仙丹——索引、SQL和IO | TiDB 社区 | 3 | 163 | 5 |
| @weixiaobing | Cluster with 3 Replicas Losing 2 Replicas - unsafe-recover | 专栏 - 集群3副本丢失2副本-unsafe-recover | TiDB 社区 | 2 | 161 | 2 |
| @清风明月 | Building a More Stable TiDB High Availability Architecture with Chaos-Mesh (Part 2) | 专栏 - 通过Chaos-Mesh打造更稳定TiDB数据库高可用架构(二) | TiDB 社区 | 3 | 145 | 5 |
| @裤衩儿飞上天 | TiDB General Log Capture and Analysis Tool | 专栏 - TIDB General Log抓取分析神器 | TiDB 社区 | 2 | 144 | 3 |
| @gary | Handling Multi-Replica Damage in TiDB | 专栏 - TiDB损坏多副本之有损恢复处理方法 | TiDB 社区 | 3 | 143 | 3 |
| @pepezzzz | Load Balancing IP Address Passthrough for Software and Hardware | 专栏 - 软硬件负载均衡 IP 地址透传 | TiDB 社区 | 0 | 141 | 1 |
| @pepezzzz | Backup Guide for TiDB Using Domestic Public Cloud and Private Deployment S3 Storage | 专栏 - TiDB 使用国内公有云和私有部署的 S3 存储备份指南 | TiDB 社区 | 0 | 140 | 1 |
| @沈阳盛京征信有限公司 | Deploying and Upgrading TiDB 6.1/6.5 in Rocky Linux 8 and Initial Experience with PITR | 专栏 - TiDB 6.1/6.5 在 Rocky Linux 8 中的部署升级与 PITR 初体验 | TiDB 社区 | 1 | 135 | 2 |
| @清风明月 | Restoring Backup Files on Persistent Volumes with TiDB Operator | 专栏 - TiDB Operator恢复持久卷上的备份文件 | TiDB 社区 | 3 | 135 | 3 |
| @buddyyuan | A Little Research on TiDB Lightning Import Mechanism | 专栏 - 对tidb-lightning导入机制的一点点研究 | TiDB 社区 | 5 | 133 | 4 |
| @pepezzzz | Simulating Network Environment of Two Data Centers and Three Centers with Chaosd | 专栏 - Chaosd 模拟两地三中心集群的网络环境 | TiDB 社区 | 1 | 127 | 1 |
| @gary | TiDB Major Version Upgrade - Cross-Machine Upgrade Based on TiCDC | https://tidb.net/blog/4433d6ac | 2 | 124 | 1 |
| @沈阳盛京征信有限公司 | Clarifying Common Character Sets and Collations in TiDB and MySQL | 专栏 - 一文理清 TiDB 与 MySQL 中的常用字符集及排序规则 | TiDB 社区 | 1 | 123 | 0 |
| @pepezzzz | Deploying TiDB in IPv6 K8S and Physical Machine Environments | 专栏 - TiDB 在 IPv6 的 K8S 和物理机环境的部署 | TiDB 社区 | 2 | 121 | 2 |
| @pepezzzz | TiDB Transaction and Consistency Verification Tool BANK | 专栏 - TiDB 的事务和一致性校验工具 BANK | TiDB 社区 | 0 | 120 | 1 |
| @humengyu2012 | TiDB x Flink Data Integration Practice | 专栏 - TiDB x Flink 数据集成实践 | TiDB 社区 | 0 | 119 | 0 |
| @Raymond | Detailed Explanation of tiup cluster display Execution Process Code | 专栏 - tiup cluster display 执行流程代码详解 | TiDB 社区 | 1 | 116 | 2 |
| @db_user | Does mysql-online-ddl Need to Rebuild? | 专栏 - mysql-online-ddl是否需要rebuild | TiDB 社区 | 0 | 113 | 0 |
| @pepezzzz | Planned and Unplanned Switchover Verification Steps for TiDB Replication Cluster Based on TiCDC | 专栏 - 基于 TiCDC 的 TiDB 复制集群的计划内和计划外切换验证步骤 | TiDB 社区 | 1 | 106 | 2 |
| @xingzhenxiang | TiDB Migration, Upgrade, and Case Sharing (TiDB v4.0.11 → v6.5.1) | 专栏 - TiDB迁移、升级与案例分享（TiDB v4.0.11 → v6.5.1） | TiDB 社区 | 0 | 104 | 0 |
| @jiashiwen | Secure Connection to TiDB/MySQL with Rust | 专栏 - 文盘Rust -- 安全连接 TiDB/Mysql | TiDB 社区 | 0 | 102 | 0 |
| @tidb狂热爱好者 | Using Data Analysis Methods to Maintain TiDB Database | 专栏 - 用数据分析的方法去做dba，维护好tidb数据库。 | TiDB 社区 | 0 | 101 | 1 |
| @Liuhaoao | Primary-Secondary Cluster Deployment and Data Synchronization Manual Based on TiDB Binlog Architecture | 专栏 - 基于TiDB Binlog架构的主备集群部署及数据同步操作手册 | TiDB 社区 | 0 | 97 | 2 |
| @gykj-sunzl | Offline Deployment of TiDB v6.5 | 专栏 - TiDBv6.5离线部署 | TiDB 社区 | 0 | 93 | 0 |
| @pepezzzz | Planned and Unplanned Switchover Verification Steps for Dr-autosync TiDB Cluster | 专栏 - Dr-autosync TiDB 集群的计划内和计划外切换验证步骤 | TiDB 社区 | 2 | 89 | 2 |
| @清风明月 | Mixing TiDB Service Components in Physical Machine Clusters and K8S Environments | 专栏 - 将TiDB各服务组件混布到物理机集群和K8S环境 | TiDB 社区 | 2 | 89 | 3 |
| @pepezzzz | Soft Load Balancing Configuration Practice for tidb-loadbalance Client | 专栏 - tidb-loadbalance 客户端方式软负载均衡配置实践 | TiDB 社区 | 0 | 87 | 2 |
| @Soysauce520 | Handling Monitoring Alerts for tidb_server_critical_error_total | 专栏 - 监控告警处理之tidb_server_critical_error_total | TiDB 社区 | 4 | 85 | 1 |
| @sdojjy | TiCDC Source Code Interpretation (6) - Introduction to TiCDC Puller Module | 专栏 - TiCDC 源码解读（6）- TiCDC Puller 模块介绍 | TiDB 社区 | 0 | 84 | 2 |
| @shiyuhang0 | TiSpark v3.0.3 & v3.1.3 Release | 专栏 - TiSpark v3.0.3 & v3.1.3 发布 | TiDB 社区 | 2 | 81 | 0 |
| @清风明月 | Common Issues and Solutions for TiDB Operator (Part 2) | 专栏 - TiDB Operator常见问题和解决步骤（二） | TiDB 社区 | 2 | 81 | 2 |
| @清风明月 | TiDB Operator: The Management Tool for Containerized TiDB | 专栏 - TiDB容器化的管理利器--TiDB Operator | TiDB 社区 | 2 | 81 | 2 |
| @清风明月 | Backing Up TiDB Cluster to NFS Persistent Volume with TiDB Operator | 专栏 - TiDB Operator备份TiDB集群到NFS持久卷 | TiDB 社区 | 2 | 75 | 2 |
| @清风明月 | Deploying Heterogeneous Clusters for Existing TiDB Clusters with TiDB Operator | 专栏 - 通过TiDB Operator为已有TiDB集群部署异构集群 | TiDB 社区 | 2 | 73 | 2 |
| @weixiaobing | Migration Pit for PD - All cdc Tasks Stopped | https://tidb.net/blog/489b279e | 0 | 71 | 0 |
| @清风明月 | Common Issues and Solutions for TiDB Operator (Part 1) | https://tidb.net/blog/8b92c1ce | 2 | 68 | 2 |
| @jiaxin | TiDB Deployment Practice on SAS Machines | https://tidb.net/blog/3e3570d7 | 1 | 67 | 3 |
| @humengyu2012 | TiDB x Flink x Iceberg Real-time ODS Practice | https://tidb.net/blog/5f85c9be | 0 | 60 | 0 |
| @weixiaobing | Migrating Prometheus Data | https://tidb.net/blog/1ea36c1f | 0 | 57 | 0 |
| @asddongmen | TiCDC Source Code Interpretation (5) - TiCDC DDL Event Handling Logic and Filter Implementation | https://tidb.net/blog/fd6142e9 | 0 | 57 | 1 |
| @cchouqiang | TiDB Cluster Database Disaster Recovery Manual | https://tidb.net/blog/aa7aa7b8 | 8 | 48 | 9 |
| @gykj-sunzl | TiDB Data Migration Practice with DM Tool | https://tidb.net/blog/75936cd7 | 0 | 7 | 0 |
Scoring Criteria
The expert judging panel consists of moderators, the Evangelist Committee, and the PingCAP Global Education Leader: @caiyfc, @xfworld, @代晓磊_Mars, @xuexiaogang, @数据小黑, @jiawei, @包老师呀, and @CuteRay. The scoring process is as follows:
- Calculate the total score after removing the lowest and highest scores, and determine the Top 10 articles based on the total score.
- The Top 10 articles will be re-scored (again removing the lowest and highest scores) to determine the final first, second, and third prizes.
Multiple articles by the same author will only be awarded the highest prize (one person can only receive one prize).
Scoring Dimensions:
Judges will score based on four dimensions, with a maximum score of 10 and a minimum score of 1.
- Structural Completeness: Complete content structure, rich in text and images.
- Thematic Typicality: Depth of content, quality, and value for other TiDBers.
- Content: No technical errors, smooth language, clear logic, and fluent writing.
- Bonus Points: Referability, practicality, and innovation.
Best Popularity Award
The Best Popularity Award is based on the number of likes. The top 3 articles with the most likes will receive the Best Popularity Award, which can be awarded in conjunction with the first to third prizes.
| Community Nickname | Title | Link | Likes |
|---|---|---|---|
| @caiyfc | Step-by-Step Guide to Becoming a TiDB Contributor | 专栏 - 手把手教你成为 TiDB 的 Contributor | TiDB 社区 | 11 |
| @hey-hoho | TiDB SQL Tuning Case: Avoiding TiFlash Missteps | 专栏 - TiDB SQL调优案例之避免TiFlash帮倒忙 | TiDB 社区 | 10 |
| @Jellybean | Real-time Cumulative Indicator Algorithm Based on TiDB+Flink Sliding Window | 专栏 - 基于TiDB+Flink实现的滑动窗口实时累计指标算法 | TiDB 社区 | 9 |
| @BraveChen | Quick Forced Rollback Solution for TiDB Upgrade Failures | 专栏 - TIDB升级发生故障时，快速强行回退方案 | TiDB 社区 | 9 |
Since two teachers have the same number of likes for the Best Popularity Award, we will reward 4 teachers equally:
TiDB Crossbody Bag + TiDB New Keycap + Power Bank
“Diligence is the Path to Success” Diligence Award
Exclusive TiDB community suitcase (random color)
Awarded to the participant with the most submissions during the event period, provided each submission meets the requirements. In case of a tie, the winner will be determined by the highest popularity score = favorites * 20 + likes * 10.
“Diligence is the Path to Success” Diligence Award
| Community Nickname | Number of Articles Published |
|---|---|
| @清风明月 | 10 |
| @pepezzzz | 9 |
| @tidb狂热爱好者 | 5 |
| @weixiaobing | 3 |
| @buddyyuan | 2 |
| @gary | 2 |
| @gykj-sunzl | 2 |
| @humengyu2012 | 2 |
| @Jellybean | 2 |
| @沈阳盛京征信有限公司 | 2 |
| @大数据模型 | 1 |
| @asddongmen | 1 |
| @BraveChen | 1 |
| @caiyfc | 1 |
| @cchouqiang | 1 |
| @db_user | 1 |
| @GangShen | 1 |
| @h5n1 | 1 |
| @Raymond | 1 |
| @hey-hoho | 1 |
| @jiashiwen | 1 |
| @jiaxin | 1 |
| @Liuhaoao | 1 |
| @meathill | 1 |
| @sdojjy | 1 |
| @shiyuhang0 | 1 |
| @Soysauce520 | 1 |
| @xingzhenxiang | 1 |
| @裤衩儿飞上天 | 1 |
The “Diligence is the Path to Success” Diligence Award goes to @清风明月!!!
Exclusive TiDB community suitcase (random color)
Awarded to the participant with the most submissions during the event period, provided each submission meets the requirements. In case of a tie, the winner will be determined by the highest popularity score = favorites * 20 + likes * 10.
Awards
Trophy
First Prize (1 Winner)
First Prize Trophy + Certificate of Honor + [TiDB Community Limited Edition Bose In-Ear Headphones + Full Set of New Peripherals] Eight-Piece Set
The ultimate eight-piece set, get all the new peripherals at once! TiDB Community Edition Bose In-Ear Headphones + 67W Fast Charging Plug, TiDB New Stickers, Ultra-Thin Phone Stand, White Travel Mug, Custom Timer, All in TiDB Keycap, TiDB Smart Leather Mouse Pad
Second Prize (3 Winners)
Second Prize Trophy + [Back Relaxation Set]: Back Massager Pillow + Crossbody Bag + 2023 Limited Edition Metal Phone Stand + TiDB Stickers + TiDB New Keycap
|
username: 
|
username: