vitess学习

发表于 分类于 Disqus：
本文字数： 671 阅读时长 ≈ 1 分钟

vitess组件说明

method-draw-image

架构说明

img

从架构图可以看出来vttablet、shard与vtgate的关系：

一

相关命令

1
show vitess_tablets;

查看相关表

1
2
3
4
5
6
7
8
mysql> show vitess_tablets;
+-------+----------+-------+------------+---------+------------------+-------------+----------------------+
| Cell  | Keyspace | Shard | TabletType | State   | Alias            | Hostname    | PrimaryTermStartTime |
+-------+----------+-------+------------+---------+------------------+-------------+----------------------+
| zone1 | sbtest   | -     | PRIMARY    | SERVING | zone1-2344898534 | 172.17.0.10 | 2022-01-25T18:04:19Z |
| zone1 | sbtest   | -     | REPLICA    | SERVING | zone1-2646235096 | 172.17.0.9  |                      |
+-------+----------+-------+------------+---------+------------------+-------------+----------------------+
2 rows in set (0.00 sec)