Introducing TiDB For those coming from MySQL... Agenda History - - PowerPoint PPT Presentation

▶

Mar 30, 2023 617 likes •862 views

Introducing TiDB For those coming from MySQL... Agenda History and Community Technical Walkthrough Use Case with Mobike MySQL Compatibility A little about me Senior Product / Community Manager ~15 years MySQL

SLIDE 1

Introducing TiDB

For those coming from MySQL...

SLIDE 2

Agenda

History and Community
Technical Walkthrough
Use Case with Mobike
MySQL Compatibility

SLIDE 3

A little about me

Senior Product / Community Manager
~15 years MySQL Experience

○ MySQL AB, Sun, Percona, Oracle

Previously Product Manager for MySQL Server

SLIDE 4

A little about PingCAP

Founded in April 2015 by 3 infrastructure

engineers

Offices in China and North America
Remote Friendly!

○ I work from here ➡

SLIDE 5

PingCAP.com

Recent News

SLIDE 6

PingCAP.com

Our Product is the TiDB Platform

TiDB Platform (Ti = Titanium)

○ TiDB (SQL Layer) ○ TiKV (Storage) ○ TiSpark (Apache Spark plugin to TiKV)

Open source from Day 1

○ GA 1.0: October 2017 ○ GA 2.0: April 2018

SLIDE 7

PingCAP.com

TiDB is a NewSQL Database

RDBMS NoSQL NewSQL

1970s 2010 2015 MySQL PostgreSQL Oracle DB2... Redis HBase Cassandra MongoDB Present Google Spanner Google F1 TiDB

SLIDE 8

Common Use Cases

1. MySQL Scalability 2. Hybrid OLTP/OLAP Architecture 3. Unifying Data Storage/Management

SLIDE 9

PingCAP.com

Architecture (Simplified)

TiDB TiDB TiDB

Application via MySQL Protocol

TiKV TiKV TiKV TiKV TiKV TiKV

... ...

PD Cluster DistSQL API KV API PD PD PD Metadata TSO / Data Location

SLIDE 10

PingCAP.com

Community

Stars

TiDB: 15,000+
TiKV: 3700+

Contributors

TiDB: 200+
TiKV: 100+

SLIDE 11

PingCAP.com

Sneak Peek!

Early Sign-up: https://www.pingcap.com/tidb-academy/

SLIDE 12

TiDB Platform Architecture

SLIDE 13

PingCAP.com

Platform Architecture

TiDB TiDB TiDB

Application via MySQL Protocol

TiKV TiKV TiKV TiKV TiKV TiKV Worker Worker Worker Spark Driver

... ... ...

Spark SQL

Spark Cluster PD Cluster DistSQL API KV API DistSQL API PD PD PD Metadata TSO / Data Location Data Location

SLIDE 14

PingCAP.com

TiKV: The Storage Foundation

RocksDB Raft Transaction Txn KV API

Coprocessor

API RocksDB Raft Transaction Txn KV API

Coprocessor

API RocksDB Raft Transaction Txn KV API

Coprocessor

API

Raft Group Client gRPC TiKV Instance TiKV Instance TiKV Instance gRPC gRPC PD Cluster

SLIDE 15

PingCAP.com

TiDB: The SQL Layer

Node1 Node2 Node3 Node4 MySQL Network Protocol SQL Parser Cost-based Optimizer Distributed Executor (Coprocessor) ODBC/JDBC MySQL Client Any ORM which supports MySQL TiDB TiKV

SLIDE 16

Who’s Using TiDB?

SLIDE 17

PingCAP.com

Who’s using TiDB?

300+ Companies

SLIDE 18

Common Use Cases

1. MySQL Scalability 2. Hybrid OLTP/OLAP Architecture 3. Unifying Data Storage/Management

SLIDE 19

PingCAP.com

Mobike + TiDB

200 million users
200 cities
9 million smart bikes
~30 TB / day

SLIDE 20

MySQL Compatibility

SLIDE 21

PingCAP.com

Summary

Compatibility with MySQL 5.7

○ Joins, subqueries, DML, DDL etc.

On the roadmap:

○ Views, CTEs, Window Functions, GIS

Missing:

○ Stored Procedures, Triggers, Events, Fulltext pingcap.com /docs/sql/mysql-compatibility/

SLIDE 22

PingCAP.com

Nuanced

Some features work differently

○ Auto Increment ○ Optimistic Locking

TiDB works better with smaller

transactions ○ Recommended to batch updates, deletes, inserts to 5000 rows pingcap.com /docs/sql/mysql-compatibility/

SLIDE 23

PingCAP.com

Thank You !

Sign-up: www.pingcap.com/tidb-academy/