TiDB Monthly Update for March 2021

Blog posts

Xiang Wang wrote an article tidb-lite: A go-sqlmock Alternative for Easily Unit Testing Golang Database-Related Code to introduce how to use tidb-lite to unit test database-related code. The article looked at the limitations of go-sqlmock, discussed tidb-lite's advantages, and then showed an example of tidb-lite in action.

In Announcing the TiDB Hacking Camp, we announced that we launched an 8-week TiDB Hacking Camp, an incubation program to actually land these projects in the community.

TiDB on Arm-based Kubernetes Cluster Achieves Up to 25% Better Price-Performance Ratio than x86, an article written by Ron Xing, compared the performance of TiDB, a MySQL compatible NewSQL database, running on an Arm-based Amazon Elastic Kubernetes Service (EKS) cluster and on an x86-based EKS cluster.

Jinpeng Zhang (TiKV Maintainer) and Bokang Zhang (TiKV Committer) wrote an article TiDB Hackathon: Reducing Cross-AZ Data Transfer Costs by 89% that showed you our whole journey through TiDB Hackathon 2020.

TiDB Operator Source Code Reading (I): Overview is the first article of a series that walked you through the TiDB Operator source code. In this article, Yiwen Chen (Committer of TiDB Operator), the author, introduced to you TiDB Operator's architecture, its core components, and what it's used for.

Jun Yu, our solution architect, in his article Using TiDB in Mission Critical Scenarios of the Financial Industry (Part I), introduced the critical business scenarios of the financial industry and the pain points our financial adopters had using their current technology. Then, he also showed you three TiDB solutions that tackled these problems.

Important pull requests

Planner

Optimize the performance of restore with the database

SQL-Infra

• Fix the issue that changing a column from nullable to NOT NULL is not ‘SQL_MODE’-aware
• Fix the issue that the DDL operation hangs over when it meets panic in the cancelling path

Execution

• Add telemetry for Coprocessor cache, TiFlash, clustered index, and async commit

Kubernetes

• Fix the issue of resizing PVC in multiple PVC settings
• Respect the Spec settings in Backup/Restore jobs

Migrate

• Add the configuration file for the server in TiCDC
• Restore schemas in parallel in TiDB Data Migration (DM)

TiUP

• Fix the issue that when endpoints are empty in the scaling-out process

Important issues

Planner

• To fix the unreasonable behavior of modify_count in show stats_meta
• To fix the issue that the auto-analyze processing on an unanalyzed table is not controlled by the analysis time range

SQL-Infra

• To fix the issue that the Range columns partition table does not support the binary data type

Execution

• To fix the issue that TiFlash reports BadRequest when pushing the timestamp down

Kubernetes

• To fix the issue that recoverFailover might be forgotten to unset
• To deprecate the Pod validating and mutating webhook

Migrate

• To track the compatibility issue of clustered index with BR
• To fix the issue in TiCDC that the atomicity of transactions is broken in the downstream when using async commit

TiUP

• To fix the issue that the nightly version cannot be updated

Call for participations

Planner

To fix the issue that SHOW ANALYZE STATUS misses the finish time for each task

SQL-Infra

• To fix the confusing output of ADMIN SHOW DDL JOBS with multiple jobs

Kubernetes

• To deprecate the Pod validating and mutating webhook
• To fix the MaxBackups behavior on BackupSchedule

New contributors

We'd like to welcome the following new contributors to TiDB and thank them for their work!

tidb:

• ankitdobhal
• jianzhiyao
• Ahacad
• hanlins
• knull-cn
• An-DJ
• Willendless

tikv:

• iliveforfun
• ZingLix

pd:

• mantuliu
• bufferflies

tidb-operator:

• hhy5861
• rudeigerc
• dragonly

tidb-dashboard:

• LINKIWI

dumpling:

• recall704

badger:

• hslam

pprof-rs:

• rrbutani

telemetry-log-collector:

• 634750802

raft-rs:

• storagezhang

test-store:

• PragmaTwice

tug-website:

• hustKiwi

docs:

• rkazak
• dbsid

docs-cn:

• zoujia-cm
• xyqcmss
• hey-hoho

qa:

• wanliyi