Consultant @ Pythian. ●Pager-carrying, buck stops at my team. ●OSDB Practice (MySQL/MariaDB, MongoDB, Cassandra, …). ●19 years of MySQL experience. �2 About me © The Pythian Group Inc., 2019 �3 TiDB Created

brief introduction of NewSQL 1970s 2010 2015 Present MySQL PostgreSQL Oracle DB2 ... Redis HBase Cassandra MongoDB ... Google Spanner Google F1 TiDB RDBMS NoSQL NewSQL TiDB and TiKV TiDB 执行流程: TiDB

领域正确的商业模式 ○ Cloudera / Hortonworks / OpenStack / Docker / RedHat ... ● 开源正在蚕食数据库市场 ○ MongoDB / Cassandra / MySQL / PostgreSQL / Spark … ● 开源 != 免费 ○ 社区版 ○ 企业版（监控管理插件、优化插件、数据安全插件、企 业服务及培训） 代表 Datastax CoreOS

copies of key 7. If there were separate copies, did TiDB merge them to- gether? Some databases, like Cassandra, might pick one copy (say, [1 2 3 7]) and discard the other, on the basis of e.g. a last-modified

57 2.5.3 TiDB TPC-H 100GB Performance Test Report – TiDB v5.1 MPP mode vs. Greenplum 6.15.0 and Apache Spark 3.1.1 · · · · · · · · · · · · · · · · 59 2.6 MySQL Compatibility· · · · · · · · · · · · · Greenplum 6.15.0 and Apache Spark 3.1.1 2.5.3.1 Test overview This test aims at comparing the TPC-H 100GB performance of TiDB v5.1 in the MPP mode with that of Greenplum and Apache Spark, two mainstream in this report are as follows: • TiDB v5.1 columnar storage in the MPP mode • Greenplum 6.15.0 • Apache Spark 3.1.1 + Parquet 2.5.3.2 Test environment 2.5.3.2.1 Hardware prerequisite • Node count: 3

66 2.5.3 TiDB TPC-H 100GB Performance Test Report – TiDB v5.3 MPP mode vs. Greenplum 6.15.0 and Apache Spark 3.1.1 · · · · · · · · · · · · · · · · 70 2.6 MySQL Compatibility· · · · · · · · · · · · · Greenplum 6.15.0 and Apache Spark 3.1.1 2.5.3.1 Test overview This test aims at comparing the TPC-H 100GB performance of TiDB v5.3 in the MPP mode with that of Greenplum and Apache Spark, two mainstream in this report are as follows: • TiDB v5.3 columnar storage in the MPP mode • Greenplum 6.15.0 • Apache Spark 3.1.1 + Parquet 2.5.3.2 Test environment 2.5.3.2.1 Hardware prerequisite • Node count: 3

56 2.5.3 TiDB TPC-H 100GB Performance Test Report – TiDB v5.2 MPP mode vs. Greenplum 6.15.0 and Apache Spark 3.1.1 · · · · · · · · · · · · · · · · 58 2.6 MySQL Compatibility· · · · · · · · · · · · · Greenplum 6.15.0 and Apache Spark 3.1.1 2.5.3.1 Test overview This test aims at comparing the TPC-H 100GB performance of TiDB v5.2 in the MPP mode with that of Greenplum and Apache Spark, two mainstream in this report are as follows: • TiDB v5.2 columnar storage in the MPP mode • Greenplum 6.15.0 • Apache Spark 3.1.1 + Parquet 2.5.3.2 Test environment 2.5.3.2.1 Hardware prerequisite • Node count: 3

→ ��� Hadoop ������ ● ����� TiDB ����� TiSpark ● TiSpark ���� TiDB ����� Apache Spark ��� ● �� Apache Spark �� ○ Apache Zeppelin��� Hive ��������R �� ● � TiDB ��������� ○ ����� Join ������� ● �

· · · 70 2.5.3 TiDB TPC-H Performance Test Report – TiDB v5.4 MPP mode vs. Greenplum 6.15.0 and Apache Spark 3.1.1 · · · · · · · · · · · · · · · · · · · · · · 74 2.6 MySQL Compatibility· · · · · · · Greenplum 6.15.0 and Apache Spark 3.1.1 2.5.3.1 Test overview This test aims at comparing the TPC-H 100 GB performance of TiDB v5.4 in the MPP mode with that of Greenplum and Apache Spark, two mainstream in this report are as follows: • TiDB v5.4 columnar storage in the MPP mode • Greenplum 6.15.0 • Apache Spark 3.1.1 + Parquet 2.5.3.2 Test environment 2.5.3.2.1 Hardware prerequisite 74 Instance type

Cloud and Snowflake · · · · · · · · · · · · · · · · · · · · · 726 7.1.2 Integrate with Apache Kafka and Apache Flink · · · · · · · · · · · · · · · · · · · · 726 7.2 Integration Scenarios · · · · · · Confluent Cloud and Snowflake · · · · · · · · · · · · · · · · 726 7.2.2 Integrate Data with Apache Kafka and Apache Flink · · · · · · · · · · · · · · · 741 8 Maintain 746 8.1 Upgrade· · · · · · · · · · · This tutorial uses JDK 17 from OpenJDK. 4.3.2.3 Step 3: Install Maven This sample application uses Apache Maven to manage the application’s dependencies. Spring supports Maven 3.3 and later versions. As