About Me • Shen Li (申砾) • Tech Lead of TiDB, VP of Engineering • Netease / 360 / PingCAP • Infrastructure software engineer What is TiDB A Distributed, Consistent, Scalable, SQL Database that supports libraries && Tools • Good performance • Quick improvement Go in TiDB • More than 100k lines of Go code and 94 contributors. Goroutine • Starting a goroutine is easy and cheap. • Goroutines come with

物理机 ● 业务侵入性和性能损耗 ● 实时，秒级别有效性 行业现状 ● 起点：《Dapper, a Large-Scale Distributed Systems Tracing Infrastructure》 - Google 2010 ● OpenTracing ○ Zipkin ○ Uber Jaeger ● OpenCensus ● OpenTracing + OpenCensus function name, source file/line, etc. By looking at the data, you can also examine which parts of the code invoked these spots. You can also filter by invokers to have more granular understanding of certain

About PingCAP • Since 2015 • Beijing, Shanghai, Guangzhou, Silicon Valley, Home • Open-Source infrastructure software: Codis, RebornDB • TiDB, TiKV, TiSpark Agenda • Design Goals • Architecture Evolution has the highest priority Tools matters • Automate Everything • Chaos tools • Debug tools • Infrastructure tools • Jira/Confluence How to tuning the system? 玄学调优 Metrics System Matters • 400+ metrics Releasing your product as an open source project will significantly improve it, especially for infrastructure software • Talent Acquire Linus‘s Law: “Given enough eyeballs, all bugs are shallow” ---

me © The Pythian Group Inc., 2019 �3 TiDB Created by PingCAP (Founded in April 2015 by 3 Infrastructure Engineers) © The Pythian Group Inc., 2019 ●SQL-based (MySQL[0] protocol). ●Distributed (ACID)

latency of report reduced from 30m to 2m • Reduced the cost of database servers. • Bigdata infrastructure adaption The challenges to storage module on HTAP scenario Isolation between OLTP and OLAP

product option of TiDB, where users or organizations can deploy and manage TiDB on their own infrastructure with complete flexibility. With TiDB Self- Managed, you can enjoy the power of open source, distributed migrate applications to TiDB, you do not need to change a single line of code in many cases, or only need to modify a small amount of code. In addition, TiDB provides a series of data migration tools to help 4.0 introduces �→ the number of keys processed by the Coprocessor (<code>PROCESSED_KEYS �→ code>) and request units (<code>RUcode>) as identifying �→ conditions, and puts identified queries into the

product option of TiDB, where users or organizations can deploy and manage TiDB on their own infrastructure with complete flexibility. With TiDB Self- Managed, you can enjoy the power of open source, distributed migrate applications to TiDB, you do not need to change a single line of code in many cases, or only need to modify a small amount of code. In addition, TiDB provides a series of data migration tools to help 4.0 introduces �→ the number of keys processed by the Coprocessor (<code>PROCESSED_KEYS �→ code>) and request units (<code>RUcode>) as identifying �→ conditions, and puts identified queries into the

your applications to TiDB, you do not need to change a single line of code in many cases or only need to modify a small amount of code. In addition, TiDB provides a series of data migration tools to help readability and execution efficiency of SQL statements. • Support changing column types online to improve code development flexibility. • Introduce a new statistics type to improve query stability, which is enabled promoting the robust development of TiDB. We sincerely appreciate all contributors who have submitted code, written and translated documents for TiDB. 2.8.1 TiDB developers TiDB developers contribute to

your applications to TiDB, you do not need to change a single line of code in many cases or only need to modify a small amount of code. In addition, TiDB provides a series of data migration tools to help directory for plugins is changed from "" to /data/deploy/plugin. • The DM code is migrated to the folder “dm” in TiCDC code repository. Now DM follows TiDB in version numbers. Next to v2.0.x, the new promoting the robust development of TiDB. We sincerely appreciate all contributors who have submitted code, written and translated documents for TiDB. 2.8.1 TiDB developers TiDB developers contribute to

your applications to TiDB, you do not need to change a single line of code in many cases or only need to modify a small amount of code. In addition, TiDB provides a series of data migration tools to help Shuffled Hash Aggregation calculation in the MPP mode when a new collation is enabled – Optimize basic code to improve MPP performance – Support casting the STRING type to the DOUBLE type – Optimize the non-joined promoting the robust development of TiDB. We sincerely appreciate all contributors who have submitted code, written and translated documents for TiDB. 2.8.1 TiDB developers TiDB developers contribute to