TIDB THE LARGE SCALE RELATIONAL DATABASE SOLUTION PRODUCT REVIEW 2022 Piloting tomorrow’s creativity https://www.iconic.inc Iconic Data Japan (IDJ) is a multi-national data services company that ICONIC DATA, DATATECH ICONIC DATA © ALL RIGHTS RESERVED. 1 AS A SOLUTION TIDB 2 TiDB is a new database solution that is targeted primarily to clients that need to handle very large databases, with very very large frequency of queries. If those two problems describe your business then this database solution is very attractive, as it also features a number of other features that make it stand out from

Service Mesh的延伸 之论道Database Mesh 分享人：张亮 日期：2018年07月25日Service Mesh风头正劲Service Mesh产品多样化Service Mesh的优势 云原生 零入侵 可观察性 面向运维服务化之后，数据库怎么办？ 服务 • 无状态 • 根据规则路由 • 业务方处理事务 数据库 • 有状态 • 根据SQL路由 • 数据库自动处理事务数据库的进化趋势 • SQL • ACID+BASE • 分布式 NewSQLNewSQL的分类 New Architecture Transparent Sharding Middleware Database-as-a-Service What's Really New with NewSQL?数据库中间层的优势 系统 •事务 运维 • DBA 开发 • SQL数据库中间层应具备的能力 Sidecar 数据库 任意 单一 单一 连接数 高 低 高 异构语言 仅Java 任意 任意 性能 损耗低 损耗略高 损耗低 无中心化 是 否 是 静态入口 无 有 无 Sidecar的优势Database Mesh架构图Sharding-Sphere 核心功能 数据分片 分布式事务 数据库治理 弹性伸缩 管控界面 实现方案 Sharding-JDBC Sharding-Proxy Sharding-Sidecar

Requirements ○ Cloud Native ○ Easy operation and maintenance ○ High performance ● CEPH ○ Complex and Large amount of codes ○ system maintenance are difficult in corner cases ○ Performance requirements scenario & requires ● Database scenario ● Elastic block Storage for KVM / Kubernetes / iSCSI Design objectives ● Thin provisioning storage pools ● High performance ● Easy maintenance ● Cloud NativeAgenda take awayPerformance in database scenario Solution architecture ● CURVE provides underlying distributed shared storage services ● Polardb for PostgreSQL provides database services Solution features

guest to start the installer. The installer will add several device drivers to the Windows driver database and then invoke the hardware detection wizard. Depending on your configuration, it might display designed to cooperate. For example, one virtual machine may contain a web server and a second one a database, and since they are intended to talk to each other, the appliance can instruct VirtualBox to set the web server to the outside world to serve data to, but the outside world cannot connect to the database. To change a virtual machine’s virtual network interface to “host only” mode: 103 6 Virtual networking

guest to start the installer. The installer will add several device drivers to the Windows driver database and then invoke the hardware detection wizard. Depending on your configuration, it might display designed to cooperate. For example, one virtual machine may contain a web server and a second one a database, and since they are intended to talk to each other, the appliance can instruct VirtualBox to set the web server to the outside world to serve data to, but the outside world cannot connect to the database. To change a virtual machine’s virtual network interface to “host only” mode: • either go to the

guest to start the installer. The installer will add several device drivers to the Windows driver database and then invoke the hardware detection wizard. Depending on your configuration, it might display designed to cooperate. For example, one virtual machine may contain a web server and a second one a database, and since they are intended to talk to each other, the appliance can instruct VirtualBox to set the web server to the outside world to serve data to, but the outside world cannot connect to the database. To change a virtual machine’s virtual network interface to “host only” mode: • either go to the

guest to start the installer. The installer will add several device drivers to the Windows driver database and then invoke the hardware detection wizard. Depending on your configuration, it might display designed to cooperate. For example, one virtual machine may contain a web server and a second one a database, and since they are intended to talk to each other, the appliance can instruct VirtualBox to set the web server to the outside world to serve data to, but the outside world cannot connect to the database. To change a virtual machine’s virtual network interface to “host only” mode: 103 6 Virtual networking

Gradual improvement • Make code self documenting • Instill confidence in changes • Develop for maintenance Goals of this talk *for some definition of "structure"The Cost of TestingWhether or not you write Many Tools Exist• Not everyone will use them • Not all code will work with them • They require maintenance too • Can be intrusive or leave artifacts in code • Not available on all platforms • Understand { SatPayloadT type; union { ActivationPayload activation; GenericBinaryPayload binary; DBAck database_ack; LocateRespPld locate_response; MailCheckPayload mail_check; PresetMessage preset; ReferencePointPayload

guest to start the installer. The installer will add several device drivers to the Windows driver database and then invoke the hardware detection wizard. Depending on your configuration, it might display designed to cooperate. For example, one virtual machine may contain a web server and a second one a database, and since they are intended to talk to each other, the appliance can instruct VirtualBox to set the web server to the outside world to serve data to, but the outside world cannot connect to the database. To change a virtual machine’s virtual network interface to “host only” mode: • either go to the

About me ● Wei Wan ⻙韦万 ● R&D @ PingCAP ● Used to be a game / android / big-data dev, now a database core dev. ● Focused on storage engine & performance optimization About this talk ● The TP & AP an OLTP specialized database or NoSQL ○ For historical data, use Hadoop / analytical database ● Offload data via the ETL process into your Hadoop cluster or analytical database ○ Per hour or even per with TiDB What Is TiFlash? What Is TiFlash? TiFlash + = Distributed database with MySQL protocol AP extension Real HTAP database! Spark Cluster TiD BTiD B Region 1 TiKV Node 1 Store 1 Region 2 Region