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

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
Introducing: Intents Introducing: Intents Jerome Leclanche LXQt, XDG FOSDEM 2014 What is

Introducing: Intents Introducing: Intents Jerome Leclanche LXQt, XDG FOSDEM 2014 What is

Introducing: Intents Introducing: Intents Jerome Leclanche LXQt, XDG FOSDEM 2014 What is XDG? What is XDG? Three specs Three specs desktop-entry: Describe applications shared-mime-info: Describe file types mime-actions:

380 views • 18 slides
INTRODUCING GRADES 6, 7, 8 O V O T A S E D A R G E L D D I M E H T G N I Y

INTRODUCING GRADES 6, 7, 8 O V O T A S E D A R G E L D D I M E H T G N I Y

INTRODUCING GRADES 6, 7, 8 O V O T A S E D A R G E L D D I M E H T G N I Y F I T S Y M E D Studies Show the K-8 Environment is Better! Students at K-8 schools have higher levels of achievement in both math and

734 views • 49 slides
Macros Macros Introducing Macros Defining Macros Invoking Macros Macro

Macros Macros Introducing Macros Defining Macros Invoking Macros Macro

Macros Macros Introducing Macros Defining Macros Invoking Macros Macro Examples Nested Macros Example Program: Wrappers 1 Irvine, Kip R. Assembly Language for Intel-Based Computers, 2003. Introducing Macros

983 views • 51 slides
Simple C# Tutorial C# Tutorial Introducing the .NET framework Comparing C# to C++ and

Simple C# Tutorial C# Tutorial Introducing the .NET framework Comparing C# to C++ and

Simple C# Tutorial C# Tutorial Introducing the .NET framework Comparing C# to C++ and Java Getting Started Variable Types Arrays Operators Flow Control Flow Control Introducing Classes, Structs and

804 views • 52 slides
Introducing W3C W3C http://www.w3.org/ the home of (X)HTML, XML, CSS, RDF, the Web and Semantic

Introducing W3C W3C http://www.w3.org/ the home of (X)HTML, XML, CSS, RDF, the Web and Semantic

An Open Platform for Planning, Developing, Publicly Discussing, Finding Consensus, Publishing, Disseminating, and Maintaining Open IT-Standards: WWW Potsdam, Germany 2007-07-04 Klaus Birkenbihl, W3C Introducing W3C W3C

377 views • 8 slides
Introducing: Madeline Davila Director, Payroll and Tax Compliance Position Funding Process:

Introducing: Madeline Davila Director, Payroll and Tax Compliance Position Funding Process:

Introducing: Madeline Davila Director, Payroll and Tax Compliance Position Funding Process: Cristine Black Asst VP, Budgeting, Financial Planning & Analysis Introducing: Wendy R. McCoy Director, Environmental Health, Safety, and Risk

429 views • 32 slides
Introducing a radically componentized GUI architecture Norman Feske <

Introducing a radically componentized GUI architecture Norman Feske <

Introducing a radically componentized GUI architecture Norman Feske < norman.feske@genode-labs.com > Outline 1. Starting point 2. Ingredients 3. Challenges and solutions 4. Next steps Introducing a radically componentized GUI

426 views • 38 slides
Nothing to fear but fear itself: introducing Why recursion in lower secondary schools recursion?

Nothing to fear but fear itself: introducing Why recursion in lower secondary schools recursion?

Introducing recursion Monga Nothing to fear but fear itself: introducing Why recursion in lower secondary schools recursion? Why recursion is challenging Our Violetta Lonati Dario Malchiodi methodology Mattia Monga Anna Morpurgo

372 views • 13 slides

More recommend