. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

by SQL redaction (Low) Conclusions Introduction “Vitess is a database clustering system for horizontal scaling of MySQL” From https://vitess.io/ This report documents the results of a security assessment