Call for essays丨TiDB Community Column The first essay competition, come and gather all the surroundings at once!

The first essay contest of TiDB community column is coming! As long as you are interested in TiDB products and have researched TiDBer, you can come to participate. There are a lot of topics for you to choose from here, and you can tell your story with TiDB.

What is the TiDB Community Column
TiDB community column http://tidb.io/blog is a collection of community technical articles and a blog platform for TiDB users/fans to [exchange ideas] and [analyze problems].

Part 1. Participation Benefits
Generous competition prizes
100-600 points & experience points per article
Build personal influence: Make the headlines of PingCAP public account to deepen personal influence
TiDB Community's Guidance for Technical Article Writing
Have more platforms and opportunities to communicate with evangelists
Excellent content contributors have more opportunities to come to the TiDB community to participate in the on-site sharing of Meetup
High-quality content can be promoted through omni-channel media matrix of "TiDB Community"

Part 2. Competition Requirements
Event time: 2022.3.14 - 2022.05.31

1. Article requirements
·Content: First published, original, more than 800 words of text, with depth and quality of content (what problems do you encounter, how to solve them? How does it help readers?) ·Structure: Complete content structure, clear logic, and smooth writing Typesetting: both pictures and texts · Bonus items: reference, practicality, innovation

Personal memos, records and notes do not meet the entry requirements.

2. Essay theme
· Failure cases

Troubleshooting & Troubleshooting

· Database migration practice

TiDB upstream and downstream synchronization and full incremental migration of massive data

Best Practices for Migrating Other Databases to TiDB

· Performance tuning

Tune before installation (hardware or system level)

iDB parameter tuning SQL optimization

Research and verification of TiKV cold and hot data storage scheme

TiDB execution plan analysis and sql optimization case

Other performance tuning

· Disaster recovery and abnormal recovery

TiCDC Backup and Recovery Best Practices

Region majority replica failure recovery

BR backup restore

Other disaster recovery and abnormal recovery

· New version practice

TiDB 5.4 application practice

Other current latest version practices

· Source code interpretation

Interpretation of TiDB source code

Interpretation of TiKV source code

DM source code interpretation

Interpretation of PD source code

Other source code interpretation

use practice

TiCDC usage practice TiFlash usage practice Other tools usage practice

Database selection

Database selection experience sharing

My story with TiDB

It can be a story with TiDB products or a story with the TiDB community
Other TiDB related articles

Part 3. Activity Process
How to Participate in Activities
1. Register a TiDB community account

2. Publish technical articles in the column (click the end of the article to read the original text for immediate access)

Announcement of activity evaluation results
Results will be announced within 7-10 working days after the event ends.

Part 4. Selection Rules
1st Prize to 3rd Prize
first round selection

During the period of the essay contest, the top 50 articles with the most popular column technical articles can be shortlisted for the second round of selection! Popularity = Favorites 20 + 10

Second round of selection

The judges score (the scoring items will be divided into 4 scoring dimensions, each dimension is 1-10 points, the highest is 10 points, and the lowest is 1 point) The moderator, the evangelist organizing committee, TiDB technical experts, etc. will jointly score, and it will be calculated according to the scores of the judges The total score, according to the total score, will get the first prize to the third prize.

Multiple articles have won multiple awards, and only the highest award will be awarded (one person can only get one award, multiple articles can get more)
Scoring dimension

1. Structural Integrity: The content structure is complete, with pictures and texts; 2. Thematic typicality: The content has depth, content quality, and its reference and value to other TiDBers; 3. Content: No technical errors, smooth language, clear logic, and fluent writing 4. Bonus items: there is reference, practicality and innovation.

Best Popularity Award
Best Popularity Award = The number of likes of the article, the 3 articles with the most likes will win the Best Popularity Award, which can be won together with the first to third prizes.

Tips for extra points: After publishing the article, you can share the article on other platforms and indicate the reprint link, which can increase the exposure of the TiDB community column article and increase the possibility of being liked and favorited.

Part5 Participation Rewards
prize settings
1st Prize (1 person)

TiDB Community Prestige 10-piece Set + "TiDB Community Column First Prize in the First Essay Contest" trophy + Certificate of Honor + "Wonderful Handwriting" community badge

TiDB Community Customized Premium 10-Piece Set includes: Limited luggage + customized keyboard + 2022 new geek backpack + monitor hanging lamp + keycap + wireless charger + astronaut canvas bag + unzip U-shaped pillow + three All-in-one data cable + automatic rain or shine umbrella
Second Prize (3 winners)

TiDB Community Customized Honor 6-piece set + "TiDB Community Column Second Prize of the First Essay Contest" trophy + "Wonderful Articles" community badge

TiDB Community Honor 6-piece set includes: 2022 new geek backpack + keycap + automatic rain and rain umbrella + astronaut canvas bag + decompressed U-shaped pillow + three-in-one data cable
Third Prize (6 winners)

TiDB community customized 4-piece set + "TiDB Community Column 1st Essay Competition Third Prize" trophy + "Wonderful Articles" community badge

TiDB community 4-piece set: 2022 new geek backpack + keycaps + astronaut canvas bag + automatic rain or shine umbrella
Popularity Award (3 winners)

TiDB Community Foundation 4-Piece Set + Best Popularity Award Trophy

TiDB Community Foundation 4-Piece Set: 2022 New Geek Backpack + Keycap + Astronaut Canvas Bag + 3-in-1 Data Cable Best Popularity Award
The number of likes of the article, the 3 articles with the highest number of likes will win the Best Popularity Award, which can be won together with the first to third prizes.
Participation Award

If you write an article during the essay contest and meet the article requirements of the essay contest, you can get: · TiDB community "First Essay Contest" - "Community Honor Writer" badge · Each article can get 100-600 points & experience value.

Prize display