[TiDBer Chat Session 44] What is the smoothest component & feature you find in TiDB? Do you have any tips to share?

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

Original topic: 【TiDBer 唠嗑茶话会 44】你觉得 TiDB 用的最顺滑的组件 & 功能是什么?有什么可以分享的使用小技巧吗~

| username: TiDB社区小助手

In this chat session, the editor has prepared a small stool and is eager to hear TiDBers praise TiDB’s components & features :face_with_peeking_eye: (just kidding), and share which components & features you find the smoothest to use. Experts are also welcome to share tips on how to make using TiDB components & features even smoother. The notebook for taking notes in the front row :open_book: is ready.

This topic:

Which components & features of TiDB do you find the smoothest to use? Do you have any tips to share with everyone?

Event rewards:

Participation Award:

Participation reward of 50 points

Event duration:

2022.10.28-2022.11.04

| username: Kongdom | Original post link

The best feature is tiup. Almost any operation can be done with a single command. Pressing enter fills the screen with rolling code, giving a Matrix-like feeling!!!

| username: xfworld | Original post link

I think the smoothest tool is tiup. Before tiup, it was ansible, and before ansible, it was manual command line. It has evolved so many times, and it feels great to use.

Deployment can save worry, effort, and brainpower, and it can check the configuration information of all nodes.

One thing is still missing, the ability to automatically back up. It would be best if it could set the backup method, such as mounting NFS, CEPH, S3, etc., and load and restore environment information, which would be even more convenient.

| username: 啦啦啦啦啦 | Original post link

The breakpoint resume feature of Lightning is very useful.

| username: WalterWj | Original post link

Shouldn’t it be the recover function? A lifesaver for accidentally deleted tables, haha.

| username: Kongdom | Original post link

As long as the database and DBA can run, it’s fine. :wink:

| username: db_user | Original post link

I think the best part is that it eliminates the hassle of sharding and partitioning.

| username: gary | Original post link

TiUP is quite easy to use, with various features :rofl:

| username: TiDBer_pFFcXLgY | Original post link

Tiup

| username: buddyyuan | Original post link

The smoothest tool, the dashboard. At least it’s convenient for viewing execution plans and downloading logs.
Having experienced days without the dashboard, it was incredibly painful.

| username: 张雨齐0720 | Original post link

My first thought is also tiup, most operations can be done with a single command.

| username: 我是咖啡哥 | Original post link

The first thing that came to my mind was also TiUP. It’s very user-friendly for operations personnel. Installation, upgrades, scaling in and out, it’s so convenient! :100:

| username: 半瓶醋仙 | Original post link

TiSpark, OLAP cluster report query business, those who use it know.

| username: TiDBer_CQ | Original post link

Of course, the first thing that comes to mind is still TiUP. If possible, I would really like to learn about TiUP’s source code interpretation through PingCAP. Currently, big data deployment and operations are still in the Ansible stage, and I want to catch up with TiUP…

| username: forever | Original post link

Definitely tiup :smile:, smooth and silky

| username: TiDBer_m6V1BalM | Original post link

TiUP is absolutely awesome, extremely easy to use!

| username: Myth | Original post link

Indeed, TiUp is extremely convenient.