introducing tidb
play

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

Mar 30, 2023 •617 likes •861 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

  1. Introducing TiDB For those coming from MySQL...

  2. Agenda ● History and Community ● Technical Walkthrough Use Case with Mobike ● MySQL Compatibility ●

  3. A little about me Senior Product / Community Manager ● ● ~15 years MySQL Experience ○ MySQL AB, Sun, Percona, Oracle Previously Product Manager for MySQL Server ●

  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 ➡ ○

  5. Recent News PingCAP.com

  6. 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 ○ PingCAP.com

  7. TiDB is a NewSQL Database RDBMS NoSQL NewSQL 1970s 2010 2015 Present MySQL Redis Google HBase Spanner PostgreSQL Cassandra Google F1 Oracle MongoDB TiDB DB2... PingCAP.com

  8. Common Use Cases 1. MySQL Scalability 2. Hybrid OLTP/OLAP Architecture 3. Unifying Data Storage/Management

  9. Architecture (Simplified) PD PD PD TSO / Data Location PD Cluster Metadata TiDB TiKV TiKV DistSQL MySQL Protocol Application via API TiDB TiKV TiKV KV API TiDB TiKV TiKV ... ... PingCAP.com

  10. Community Stars ● TiDB: 15,000+ TiKV: 3700+ ● Contributors ● TiDB: 200+ TiKV: 100+ ● PingCAP.com

  11. Sneak Peek! Early Sign-up: https://www.pingcap.com/tidb-academy/ PingCAP.com

  12. TiDB Platform Architecture

  13. Platform Architecture PD Data Location PD PD TSO / Data Location PD Cluster Spark Driver Metadata Worker TiDB TiKV TiKV DistSQL MySQL Protocol Application via DistSQL Worker API API Spark SQL TiDB TiKV TiKV KV API Worker ... TiDB TiKV TiKV ... ... Spark Cluster PingCAP.com

  14. TiKV: The Storage Foundation Client PD Cluster gRPC gRPC gRPC Coprocessor Coprocessor Coprocessor Txn KV API Txn KV API Txn KV API API API API Transaction Transaction Transaction Raft Raft Raft Raft Group RocksDB RocksDB RocksDB TiKV Instance TiKV Instance TiKV Instance PingCAP.com

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

  16. Who’s Using TiDB?

  17. Who’s using TiDB? 300+ Companies PingCAP.com

  18. Common Use Cases 1. MySQL Scalability 2. Hybrid OLTP/OLAP Architecture 3. Unifying Data Storage/Management

  19. Mobike + TiDB ● 200 million users ● 200 cities 9 million smart bikes ● ~30 TB / day ● PingCAP.com

  20. MySQL Compatibility

  21. Summary ● Compatibility with MySQL 5.7 ○ Joins, subqueries, DML, DDL etc. On the roadmap: ● Views, CTEs, Window Functions, GIS ○ ● Missing: ○ Stored Procedures, Triggers, Events, pingcap.com Fulltext /docs/sql/mysql-compatibility/ PingCAP.com

  22. Nuanced ● Some features work differently ○ Auto Increment Optimistic Locking ○ TiDB works better with smaller ● transactions ○ Recommended to batch updates, pingcap.com deletes, inserts to 5000 rows /docs/sql/mysql-compatibility/ PingCAP.com

  23. Thank You ! Sign-up: www.pingcap.com/tidb-academy/ PingCAP.com

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

Replicating MySQL Data to TiDB For Near Real-Time Analytics Who Are We Jervin Real, Architect

Replicating MySQL Data to TiDB For Near Real-Time Analytics Who Are We Jervin Real, Architect

Replicating MySQL Data to TiDB For Near Real-Time Analytics Who Are We Jervin Real, Architect Francisco Bordenave, Architect 2 / 27 TiDB at a Glance 3 / 27 TiDB at a Glance TiDB cluster server process SQL and interacts with clients MySQL

381 views • 27 slides
TiDB: Overview, New Features, Multi-Cloud Shen Li, Kevin Xu PingCAP What is Ti(tanium) DB?

TiDB: Overview, New Features, Multi-Cloud Shen Li, Kevin Xu PingCAP What is Ti(tanium) DB?

TiDB: Overview, New Features, Multi-Cloud Shen Li, Kevin Xu PingCAP What is Ti(tanium) DB? NewSQL (RDBMS at Scale) MySQL Compatible (5.7) Hybrid OLTP + OLAP Workloads Multi-Cloud 2 Product: the TiDB Platform TiDB

1.04k views • 34 slides
Make HTAP Real with TiFlash A TiDB native Columnar Extension About me Liu Cong,

Make HTAP Real with TiFlash A TiDB native Columnar Extension About me Liu Cong,

Make HTAP Real with TiFlash A TiDB native Columnar Extension About me Liu Cong, Technical Director, Analytical Product@PingCAP Previously Principal Enginer@QiniuCloud Technical Director@Kingsoft Focus on

325 views • 31 slides
Introducing .. .. Introducing HIT- -4G 4G HIT 03/09/2018 03/09/2018

Introducing .. .. Introducing HIT- -4G 4G HIT 03/09/2018 03/09/2018

Hoffer Flow Controls, Inc. Introducing .. .. Introducing HIT- -4G 4G HIT 03/09/2018 03/09/2018 Fully-Compensating Gas Flow Rate Indicator/Dual Totalizer with Modbus and Data Logging HIT- -4G Key Features 4G Key Features HIT 12

463 views • 32 slides
Introducing more people Introducing more people Introducing more people Introducing more people

Introducing more people Introducing more people Introducing more people Introducing more people

Introducing more people Introducing more people Introducing more people Introducing more people Cricket Wales Board to the power of cricket to the power of cricket to the power of cricket to the power of cricket December 2018 1. Marketing

351 views • 22 slides
Introducing EXPLORER 710 Slide 2 - the bar is raised Cobham plc 2 Introducing the EXPLORER 710

Introducing EXPLORER 710 Slide 2 - the bar is raised Cobham plc 2 Introducing the EXPLORER 710

Introducing EXPLORER 710 Slide 2 - the bar is raised Cobham plc 2 Introducing the EXPLORER 710 A state of the art BGAN setting new standards in terms of speed, size and features. Radical improvement in video quality - the first and

110 views • 8 slides
INTRODUCING INTRODUCING Self-propelled aerial work platforms PM Oil&Ste e l Asia Pte L td

INTRODUCING INTRODUCING Self-propelled aerial work platforms PM Oil&Ste e l Asia Pte L td

INTRODUCING INTRODUCING Self-propelled aerial work platforms PM Oil&Ste e l Asia Pte L td - 24 Raffle s Plac e # 07-02 - Cliffo rd Ce ntre - Singapo re 048621 Mo b: +65 9021 2476 - E fax: +39 059 5970371 - Re gistratio n Numbe r:

489 views • 21 slides
Introducing Asp.Net Ing. Gabriele Zannoni gabriele.zannoni@unibo.it Introducing Asp.Net 1

Introducing Asp.Net Ing. Gabriele Zannoni gabriele.zannoni@unibo.it Introducing Asp.Net 1

Introducing Asp.Net Ing. Gabriele Zannoni gabriele.zannoni@unibo.it Introducing Asp.Net 1 Cos? La risposta Microsoft alle esigenze del server side (leggi JSP) Levoluzione (rivoluzione) di ASP La tecnologia per la scrittura

856 views • 42 slides
2014 PRODUCTION TOOLS 5. INTRODUCING SURVEY TOOLS FUNDAMENTAL OF LANDSCAPE ARCHITECTURE ARL200

2014 PRODUCTION TOOLS 5. INTRODUCING SURVEY TOOLS FUNDAMENTAL OF LANDSCAPE ARCHITECTURE ARL200

16/09/2015 PRACTICAL 6 1. INTRODUCING DRAWING MEDIA INTRODUCTION OF PRODUCTION 2. INTRODUCING DRAWING TOOLS MEDIA IN LANDSCAPE 3. INTRODUCING GRAPHIC ARCHITECTURE WORK COMPUTER TOOLS 4. INTRODUCING MAQUETTE ( MOCKUP ) 2014 PRODUCTION TOOLS

971 views • 18 slides
The Basics of Syntax Introducing Noun Phrases Some Further Details Introducing Verb Phrases

The Basics of Syntax Introducing Noun Phrases Some Further Details Introducing Verb Phrases

The Basics of Syntax Course Readings Introduction Lexical Categories Phrase Structure Rules The Basics of Syntax Introducing Noun Phrases Some Further Details Introducing Verb Phrases Introducing Prepositional Phrases Summary . .

1.41k views • 105 slides
Introducing .. .. Introducing HIT- -4U 4U HIT Revised 03/07/2018 Revised 03/07/2018

Introducing .. .. Introducing HIT- -4U 4U HIT Revised 03/07/2018 Revised 03/07/2018

Hoffer Flow Controls, Inc. Introducing .. .. Introducing HIT- -4U 4U HIT Revised 03/07/2018 Revised 03/07/2018 Rate Indicator/Dual Totalizer with Modbus and Data Logging HIT- -4U Key Features 4U Key Features HIT 11 Key Features

616 views • 30 slides
Introducing PRICAT PD 608 Introducing PRICAT PD 608 series Johnson Matthey have an mature legacy

Introducing PRICAT PD 608 Introducing PRICAT PD 608 series Johnson Matthey have an mature legacy

Introducing PRICAT PD 608 Introducing PRICAT PD 608 series Johnson Matthey have an mature legacy in base and precious metal catalysis Over the past few years we have leveraged our expertise to develop a full range of selective

328 views • 7 slides
Introducing Introducing Features & Benefits Features & Benefits Cleaning

Introducing Introducing Features & Benefits Features & Benefits Cleaning

Introducing Introducing Features & Benefits Features & Benefits Cleaning Onboard Rocker Blaster Bumper Blaster Multiple Chemical Wands Intelligence Onboard XPert monitors the entire system. Complete

871 views • 46 slides
Introducing the COLON Graham Stott Tip: Introducing the COLON Graham Stott Independent SAS

Introducing the COLON Graham Stott Tip: Introducing the COLON Graham Stott Independent SAS

Introducing the COLON Graham Stott Tip: Introducing the COLON Graham Stott Independent SAS Consultant 0432786140 | Graham@gstott.com Tip: Introducing the COLON SAS uses the colon : in many places Key ones are: When reading input files

324 views • 6 slides
Investor Presentation March 2007 Introducing Implats Introducing Implats Contribution to sales

Investor Presentation March 2007 Introducing Implats Introducing Implats Contribution to sales

Investor Presentation March 2007 Introducing Implats Introducing Implats Contribution to sales revenue by metal Implats is in the business of 6% 12% mining, refining and marketing platinum group metals and 51% H1 FY2007 24% associated

523 views • 20 slides
Introducing a robust multitasking operating system for real-time demands 06.05.2013 Introducing

Introducing a robust multitasking operating system for real-time demands 06.05.2013 Introducing

Introducing a robust multitasking operating system for real-time demands 06.05.2013 Introducing a robust multitasking OS Michael Fritscher 1 Agenda Introduction Architecture Function tests Benchmarks Conclusion

426 views • 23 slides
Building a Transactional Key-Value Store That Scales to 100+ Nodes Siddon Tang at PingCAP

Building a Transactional Key-Value Store That Scales to 100+ Nodes Siddon Tang at PingCAP

Building a Transactional Key-Value Store That Scales to 100+ Nodes Siddon Tang at PingCAP (Twitter: @siddontang; @pingcap) 1 About Me Chief Engineer at PingCAP Leader of TiKV project My other open-source projects: go-mysql

742 views • 58 slides
International Conference in QUALITY IN HIGHER EDUCATION: GLOBAL PERSPECTIVES AND BEST PRACTICES Ho

International Conference in QUALITY IN HIGHER EDUCATION: GLOBAL PERSPECTIVES AND BEST PRACTICES Ho

International Conference in QUALITY IN HIGHER EDUCATION: GLOBAL PERSPECTIVES AND BEST PRACTICES Ho Chi Minh City, July 30-31, 2015 Using Student Response Systems for Peer Instruction and Active Learning in the Classroom Mike Ma c Ca llum, PhD

573 views • 28 slides
Tomasz ciso Software Engineer Samsung R&D Center Poland The Earth Guard development

Tomasz ciso Software Engineer Samsung R&D Center Poland The Earth Guard development

Highly portable HTML5 games on Tizen Developer Conference May 2013 San Francisco USA Tomasz ciso Software Engineer Samsung R&D Center Poland The Earth Guard development story Code once - for Tizen and deploy your application on

350 views • 15 slides
waste and food packaging: Summary of research findings (March 2013) In partnership with:

waste and food packaging: Summary of research findings (March 2013) In partnership with:

Consumer attitudes to food waste and food packaging: Summary of research findings (March 2013) In partnership with: Presentation outline Background Summary of key findings Summary of opportunities Examples of action

979 views • 57 slides
EIC Software Consortium William & Mary, Physics Department May 17-18, 2018 Cool Facts

EIC Software Consortium William & Mary, Physics Department May 17-18, 2018 Cool Facts

EIC Software Consortium William & Mary, Physics Department May 17-18, 2018 Cool Facts Second oldest college in the U.S. (1693). First college to become university (1779). Three Presidents of the United States were educated at

100 views • 8 slides
Using Rust to Build a Distributed Transactional Key-Value Database LiuTang | tl@pingcap.com

Using Rust to Build a Distributed Transactional Key-Value Database LiuTang | tl@pingcap.com

Using Rust to Build a Distributed Transactional Key-Value Database LiuTang | tl@pingcap.com About me Chief Architect at PingCAP TiDB and TiKV Open source projects LedisDB go-mysql go-mysql-elasticsearch

756 views • 42 slides
Observations ConTeXt & XML 5th ConTeXt Meeting, Bassenge, Belgium Jano Kula 21. 9. 2011

Observations ConTeXt & XML 5th ConTeXt Meeting, Bassenge, Belgium Jano Kula 21. 9. 2011

Observations ConTeXt & XML 5th ConTeXt Meeting, Bassenge, Belgium Jano Kula 21. 9. 2011 Files Topics Indexes Exceptions Solution XML Conclusion Reaching the Limits LaTeX Files

548 views • 16 slides
Science, Mathematics and Money The people and ideas depicted on currency reflect national and

Science, Mathematics and Money The people and ideas depicted on currency reflect national and

Science, Mathematics and Money The people and ideas depicted on currency reflect national and cultural priorities. Many foreign countries feature scientists, mathematicians, engineers, and philosophers on their bills, including formulas

266 views • 23 slides

More recommend