TiDB Hackathon 2019 has been open for registration for more than a month now, and all the people who were scratching their heads and couldn’t think of a topic to choose or a teammate to form a team have started to prepare for the competition. In order to stimulate the audience’s “small spark of inspiration”, we have expanded a wave of topics today, if you do not know what to do, choose a day better than the day, today anchor a decisive registration! In addition, if you have any questions about your topic, you can contact TiDB Robot (wechat id: Tidbai) for pre-competition coaching to help you clear up some knowledge gaps

Reference topics

Performance improvement

  • Improve memory overcommitment in TiDB (consider sync.pool)

  • Replace MocktikV with Unistore to achieve the ultimate performance of standalone TiDB while speeding up unit testing

Improved ease of use

  • Key visualizer for TiKV, related: cloud.google.com/blog/produc…

  • Hotspot index statistics

  • Obtain cluster information using SQL

Stability enhancement

  • Adaptive SQL engine

  • Improve the accuracy of Cost estimation

  • History-based query optimization

  • SQL Plan Management Plan History

  • Combining github.com/intel-go/nf… Github.com/google/nets… Replace connection layer between MySQL and TiDB

Capability of

  • Follower Read combined with MVCC

  • Dynamic multiple copy

  • Cloud TiKV support, underlying rockset to replace the stand-alone version of RocksDB

  • Allows TiDB to cache locked table data, which can be shared within TiDB Server

  • Supports select into file

  • TiDB coprocessor cache, related: docs.google.com/document/d/…

Ecological extension

  • Docker-based cluster simulator

  • BI/AI/Search and other integrated application layer ecological solutions

  • TiDB Play Ground (play.golang.org)

  • Graph computing engine based on TiDB

  • Replace ETCD of K8s backend with TiKV to solve scalability and performance problems

Application of machine learning in TiDB

  • Data feature learning

  • Learned Data Structure (Bloom filter, Hash…) Application in tiDB/Unistore

other

  • DBA tools such as:

Github.com/ngaut/sqlto…

  • TiDB learning tools to help beginners to understand TiDB features, principles

  • Please use your imagination

If you are interested in the above topics, but are relatively unfamiliar with the relevant knowledge field, don’t worry, we will arrange a mentor group to communicate with you before the competition. The members of this year’s Hackathon Mentor group include —

  • Tang Liu: PingCAP | chief architect

  • Yao Wei: PingCAP | Senior Technical Director

  • The ShuaiPeng: PingCAP | TiDB architecture group r&d team leader

  • Feng Liyuan: PingCAP | TiDB r&d engineers

  • Jian-jun li: PingCAP | TiKV r&d engineers

  • Chang Jun chang: PingCAP | r&d engineers

  • Zhang jian: PingCAP | TiDB optimizer and execution engine technology

At the end of the day, your entries will be graded by these (serious) judges

  • Huang Dongxu: PingCAP | co-founder and CTO

  • ShenLi: PingCAP | Engineering VP

  • N.syed: Meituan | database team leader

  • Senior managers Yu Bowei: 58 group | database

  • Debian developer: jingdong cloud | senior director

  • Zhao should steel: Meituan comments | distributed database platform development and operations, head researcher

Grading criteria (emphasis!)

  1. Practicality/ease of use/performance: application prospect and production value of the project. Is it sustainable for TiDB to increase productivity, improve efficiency, and optimize the overall module? (40%).

  2. Degree of completion: the integrity of the work, whether the core functions can be demonstrated. (30%).

  3. Innovation: Bonus points for eye-catching work. (20%).

  4. Presentation: whether the whole presentation is smooth and the module is clearly described. (10%).

TiDB Robot is waiting for you on the other side of wechat (wechat: Tidbai)

Important Information

Competition time: October 26 ~ 27, 2019

Venue: PingCAP Beijing, Shanghai, Guangzhou Office

Team rules: 1 ~ 4 people form a team and choose a place to compete

Awards:

🏅 First Prize (1 team) : ¥60,000 cash award

🥈 Second prize (2 teams) : ¥30,000 cash prize for each team

🥉 Third Prize (3 teams) : ¥10,000 cash prize for each team

In addition, there will be the best contribution award, the best creative award, the most potential award, and TiDB peripheral gift awards.

Registration time: from now to October 23

Registration audit: feedback the audit results within 5 working days

Registration address: nc9hsk15y2xczuor.mikecrm.com/PiwBPaL

Hackathon: github.com/pingcap/pre…

Volunteer recruitment

We are looking for volunteers to participate in the competition (Beijing, Shanghai, Guangzhou). If you want to get up close and personal with some of the biggest names in technology and experience the atmosphere of the competition, contact TiDB Robot to sign up. Volunteers can also receive customized souvenirs for the event.

More information: pingcap.com/community-c…