[Resource Download & Event Review] TiDB Regional Exchange Shenzhen Station: Hear Why New Economy, Retail, and Internet+ Enterprises Choose TiDB and Practical Experiences with TiDB v7.5 New Features

Translated
1

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

Original topic: 【资料下载&活动回顾】TiDB 地区交流深圳站，来听听新经济，零售，互联网+企业们选择 TiDB 的原因和 TiDB v7.5 新特性实践感受

| username: YY-ha

First, a group photo! Our first stop in 2024 is Shenzhen. Thanks to the community members who attended in person and watched the live stream online. It’s great to meet everyone in South China again!

DSC04911
DSC049111024×576 179 KB

Download Area

From Multiple MySQL Instances to One TiDB - Junbo Network Integrated Operation Management Platform Application Practice.pdf (6.9 MB)
NewSQL Distributed Database Selection and Practice - Quwan’s Practice Based on TiDB - Su Chenghui.pdf (491.5 KB)
SHOPLINE TiDB 4.0 to 6.5 Upgrade Path - Che Jiawei.pdf (1.3 MB)
TiDB 7.5 LTS High-Performance Batch Processing Solution - Tang Bowen.pdf (1019.4 KB)
NetEase Games Scalable TiDB SaaS Service Construction - Tian Weifan.pdf (1022.0 KB)
TiDB Resource Control Feature Interpretation and Application Exploration - Li Wenjie.pdf (1.7 MB)
Taobo ToC System Database Migration TiDB Practice - Cui Wentao.pdf (1009.3 KB)

Audience Limited-Time Interaction

Thank you for taking the time to participate in the community event!
Feel free to leave a comment in the [comment section] about “your favorite topic in this event and your thoughts and gains.”

We will randomly select 5 lucky viewers from the comment section on March 15 to receive the latest 2024 TiDB community backpack!

Backpack

Topic Review

Topic: From Multiple MySQL Instances to One TiDB | Junbo Network Integrated Operation Management Platform Application Practice
Speaker: Tang Fan, System Architect at Guangzhou Junbo Network Technology Co., Ltd.

WeChat Image_20240309141844
WeChat Image_202403091418441380×776 116 KB

Mr. Tang Fan shared the challenges and benefits encountered by Junbo Network in fully migrating its long-running system to TiDB. This includes the process of choosing TiDB, the migration process, issues encountered during migration, and the benefits brought by the migration.

User Benefits:
Understand the entire process of migrating to TiDB from scratch; what needs to be done to migrate to TiDB; what users should care about when fully migrating to TiDB; and the benefits brought by migrating to TiDB.

Topic: Database Selection for Retail ToC Systems
Speaker: Cui Wentao, Architect at Yunsheng Haihong

DSC04724
DSC047241024×576 83.8 KB

Mr. Cui shared Yunsheng Haihong’s thoughts on database selection, including:

  1. Issues encountered with the business system using Mycat+Mysql
  2. Issues and verification methods when migrating the system database from Mycat+Mysql to TiDB
  3. Effects after the migration

User Benefits:

  1. Issues and verification methods to pay attention to during database migration
  2. Performance improvements from migrating the business system database from Mycat+Mysql to TiDB

Topic: NewSQL Distributed Database Selection and Practice
Speaker: Su Chenghui, Head of Database/Middleware at Quwan Technology

DSC04838
DSC048381024×576 87.6 KB

Mr. Su shared Quwan’s product selection and some practices of TiDB when introducing NewSQL, including:

  1. Four standards considered for distributed database selection
  2. Advantages of TiDB
  3. Issues encountered and solutions when using TiDB

User Benefits:

  1. Issues to pay attention to during multi-AZ transformation
  2. Issues and solutions encountered during major version upgrades

Topic: Shopline TiDB 4.x to 6.x Upgrade Path, Cluster Cost Reduced by 50%
Speaker: Che Jiawei, Head of Database/TiDB at Shopline

DSC05086
DSC050861024×576 69.9 KB

Content includes:

  1. Current status of the business TiDB cluster
  2. Pain points of the business TiDB cluster
  3. TiKV OOM + TiCDC/CDC failures
  4. TiDB upgrade process
  5. Benefits of TiDB upgrade

Topic: Scalable TiDB SaaS Service & High-Concurrency Request TiDB Operation Practice in NetEase Games
Speaker: Tian Weifan, Head of Relational Database Operation Team at NetEase Games SaaS Service

DSC05154
DSC051541024×576 120 KB

Content includes:

  1. Introduction to NetEase Games DB SaaS Service
  2. TiDB SaaS Platform Service
  • TiDB package customization and backup
  • Data migration service and monitoring
  1. High-concurrency request business practice
  • Scenario introduction and selection
  • Optimization practice

Topic: TiDB 7.5 Resource Control Feature Interpretation and Application Exploration
Speaker: Li Wenjie, TiDB Community Moderator, TiDB South China Organizer

DSC05205
DSC052051024×577 72.8 KB

Mr. Wenjie shared the multi-tenant related features of the newly released TiDB v7.5 LTS version and explored its application value. This includes:

  1. Multi-tenant architecture based on TiDB
  2. Resource control and new feature exploration
  3. Summary and outlook

User Benefits:

  1. Understand how to achieve a multi-tenant architecture by sharing a single TiDB cluster across business systems.
  2. Learn about the new features of the latest TiDB v7.5 LTS version and how to use these features to improve cluster stability and availability.
  3. How to use new version features to support enterprise business development.

Topic: TiDB 7.5 LTS High-Performance Batch Processing Solution
Speaker: Tang Bowen, Pre-sales Consultant at PingCAP

DSC05246
DSC052461024×576 71.6 KB

Mr. Bowen shared some common batch processing scenarios encountered while serving customers and some optimization solutions, discussing more solutions based on actual tests.

User Benefits:

  1. Understand how BATCH DML can benefit single-table batch processing scenarios.
  2. Learn about the high-performance import solution IMPORT INTO.
  3. Understand the various implementation methods for data export scenarios.

Community members also listened to the teachers’ sharing and asked questions on-site, leading to a small surprise where they discussed unexpected situations that might occur when a product manager operates TiDB!

image
image1380×636 75.1 KB

Event Highlights

DSC04337
DSC043371024×576 107 KB

image
image1380×776 211 KB

DSC04659
DSC046591024×576 146 KB

DSC04375
DSC043751024×576 124 KB

DSC04298
DSC042981024×576 128 KB

DSC03954
DSC039541024×576 106 KB

DSC03945 (1)
DSC03945 (1)1024×576 134 KB

image
image636×850 152 KB
image
image636×850 116 KB

image
image636×850 161 KB
image
image636×850 91.2 KB

image
image636×850 125 KB
image
image636×850 134 KB

image
image636×850 134 KB
image
image636×850 166 KB

Event photo collection: https://www.xxpie.com/m/album?id=65eb3616579bcc57fac4f65d&nowatermark=NjVlYjM2MTY1NzliY2M1N2ZhYzRmNjVkJDA=&mini=0

Lottery Announcement

Congratulations to the following community members for winning the latest 2024 TiDB community backpack! Please contact TiDB Robot WeChat (tidbai) via private message within 7 days to leave your contact information, and we will ship it within 15 working days!

Winners’ IDs:

@TiDBer_CkS2lbTx
@DBAER
@TiDBer_hUYQYjoV
@霸王龙的日常
@TiDBer_fu2wCBtk

Lottery Announcement
Lottery Announcement1004×1000 106 KB

2
| username: awakening | Original post link

Study hard and make progress every day, continuously improve.

3
| username: ShawnYan | Original post link

Mark:
Bilibili live stream:

4
| username: herowk | Original post link

Study hard and make progress every day, continuously improve.

5
| username: Kongdom | Original post link

:+1: :+1: :+1:

6
| username: dabao | Original post link

Great share, awesome!

7
| username: TiDBer_fu2wCBtk | Original post link

Well said.

8
| username: TiDBer_CQ | Original post link

I first browsed all the materials for this issue’s regional exchange, and I can only say that I liked all of them. Listening to others’ sharing broadens my own knowledge!

9
| username: Ming | Original post link

Well said.

10
| username: chris-zhang | Original post link

Study hard and make progress every day.

11
| username: TiDBer_DPTNLtsY | Original post link

Study hard

12
| username: Hacker_hpipqaTz | Original post link

Study hard and make progress every day :100:

13
| username: Hacker_FrIg00OR | Original post link

Got it.

14
| username: JvYouQing | Original post link

All the teachers have spoken very well, and I have benefited greatly, gaining a lot of inspiration.

15
| username: TiDBer_Kirngs | Original post link

Great, I’ve gained new insights again.

16
| username: 纯白镇的小智 | Original post link

It was a very interesting knowledge exchange and sharing session, and the atmosphere on-site was quite good. As a very dynamic new database, TiDB gave me a completely new impression compared to traditional databases. Today, I was able to fully understand the issues encountered during TiDB migration and how it solved some common pain points of MySQL. I wish TiDB continued success.

17
| username: TiDBer_LM | Original post link

Favorite topic: “Database Selection for ToC Systems in the Retail Industry” shared by Mr. Cui Wentao from Yunsheng Haihong.
Especially,
Issues and verification methods to consider when migrating the system database from Mycat+MySQL to TiDB.
Sharing the effects after migration.

This has provided significant insights for our future migration to domestic databases. The issues to be noted and the verification methods during the migration process have given us feasible reference solutions.

18
| username: TiDBer_znMJ0RIQ | Original post link

I am very pleased to learn about the advantages of migrating MySQL with sharding to TiDB.