24時間365日サポート 技術トレーニングとコンサルティング コミュニティエディション Open Source Conference 2022 Online/Spring 11 TiDB の特徴 Horizontal Scalability (水平拡張) MySQL Compatible Syntax (MySQL 互換) Distributed Transactions (分散トランザクション) OLAP のサポート) High Availability (高可用性) Open Source Conference 2022 Online/Spring 12 TiDB の特徴 Horizontal Scalability (水平拡張) MySQL Compatible Syntax (MySQL 互換) Distributed Transactions (分散トランザクション) OLAP のサポート) High Availability (高可用性) Open Source Conference 2022 Online/Spring 13 TiDB の特徴 (Horizontal Scalability) TiDB はアーキテクチャ上 SQL を処理するコンポーネントと ストレージ部分が分離されています それぞれの単位(SQL、ストレージ)で水平に拡張が可能です

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . decide which set of shards to use for a given keyspace, cell, and tablet type. Partitions During horizontal resharding (splitting or merging shards), there can be shards with overlapping key ranges. For RESTARTS AGE pod/commerce -apply-schema-initial -2pbzn 0/1 Completed 0 2m44s pod/commerce -apply-vschema -initial -mfhvl 0/1 Completed 0 2m44s pod/vtctld -6f955957bb -67bq7 1/1 Running 0 2m44s pod/vtgate

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . which set of shards to use for a given keyspace, cell, and tablet type. 11 Partitions During horizontal resharding (splitting or merging shards), there can be shards with overlapping key ranges. For RESTARTS AGE pod/commerce -apply-schema-initial -vlc6k 0/1 Completed 0 2m42s pod/commerce -apply-vschema -initial -9wb2k 0/1 Completed 0 2m42s pod/vtctld -58bd955948 -pgz7k 1/1 Running 0 2m43s pod/vtgate

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Horizontal sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . decide which set of shards to use for a given keyspace, cell, and tablet type. Partitions During horizontal resharding (splitting or merging shards), there can be shards with overlapping key ranges. For

in older version of Vitess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . RESTARTS AGE pod/commerce -apply-schema-initial -vlc6k 0/1 Completed 0 2m42s pod/commerce -apply-vschema -initial -9wb2k 0/1 Completed 0 2m42s pod/vtctld -58bd955948 -pgz7k 1/1 Running 0 2m43s pod/vtgate Running 3 2m43s pod/zone1-commerce -0-init-shard-master-gshz9 0/1 Completed 0 2m42s pod/zone1-commerce -0-replica -0 2/2 Running 0 2m42s pod/zone1-commerce -0-replica -1 2/2 Running 0 2m42s pod/zone1-commerce

in older version of Vitess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 338 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . RESTARTS AGE pod/commerce -apply-schema-initial -vlc6k 0/1 Completed 0 2m42s pod/commerce -apply-vschema -initial -9wb2k 0/1 Completed 0 2m42s pod/vtctld -58bd955948 -pgz7k 1/1 Running 0 2m43s pod/vtgate Running 3 2m43s pod/zone1-commerce -0-init-shard-master-gshz9 0/1 Completed 0 2m42s pod/zone1-commerce -0-replica -0 2/2 Running 0 2m42s pod/zone1-commerce -0-replica -1 2/2 Running 0 2m42s pod/zone1-commerce

in older version of Vitess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . RESTARTS AGE pod/commerce -apply-schema-initial -vlc6k 0/1 Completed 0 2m42s pod/commerce -apply-vschema -initial -9wb2k 0/1 Completed 0 2m42s pod/vtctld -58bd955948 -pgz7k 1/1 Running 0 2m43s pod/vtgate Running 3 2m43s pod/zone1-commerce -0-init-shard-master-gshz9 0/1 Completed 0 2m42s pod/zone1-commerce -0-replica -0 2/2 Running 0 2m42s pod/zone1-commerce -0-replica -1 2/2 Running 0 2m42s pod/zone1-commerce

in older version of Vitess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . RESTARTS AGE pod/commerce -apply-schema-initial -vlc6k 0/1 Completed 0 2m42s pod/commerce -apply-vschema -initial -9wb2k 0/1 Completed 0 2m42s pod/vtctld -58bd955948 -pgz7k 1/1 Running 0 2m43s pod/vtgate Running 3 2m43s pod/zone1-commerce -0-init-shard-master-gshz9 0/1 Completed 0 2m42s pod/zone1-commerce -0-replica -0 2/2 Running 0 2m42s pod/zone1-commerce -0-replica -1 2/2 Running 0 2m42s pod/zone1-commerce

in older version of Vitess . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 420 Horizontal Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . warning >}} The port-forward will only forward to a specific pod. Currently, kubectl does not automatically terminate a port-forward as the pod disappears due to apply/upgrade operations. You will need to multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones 117 Comparisons

custom resource definition(CRD) ü custom controller Operator 是什么 • Kubernetes 中一切都可视为资源 • 默认资源类型：如 Pod、Service、Volume 等 • Kubernetes 1.7 之后增加了 CRD 自定义资源 • 二次开发扩展 Kubernetes API CRD 的基本原理 ① 观察资源的当前状态 mysql pod-5 mysql pod-6 … … mysql pod-M Node1 kubelet kube-proxy docker mysql pod-0 mysql pod-1 … … mysql pod-N NodeN Mysql Operator pod … … mysql Pod-T 0. 创建 CRD 3. 集群管理 2. 调度 pod Ceph Reflector DeltaFIFO Local Storage Callbacks OnAdd OnUpdate OnDelete WorkQueue List/Watch - CRD - Pod Write Informer Worker ReadOnly • Informer：监听事件并触发回调函数的二级缓存工具包 • WorkQueue：事件合并、过滤、延时、限速 Operator