. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: 14 • It enables tablets to coordinate among dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ~/my-vitess -example > ./101_initial_cluster.sh add /vitess/global add /vitess/zone1 add zone1 CellInfo etcd start done... Starting vtctld... Starting MySQL for tablet zone1 -0000000100... Starting vttablet verify that the processes have started with pgrep: ~/my-vitess -example > pgrep -fl vtdataroot 3920 etcd 4030 vtctld 4173 mysqld_safe 4779 mysqld 4817 vttablet 4901 mysqld_safe 5426 mysqld 5461 vttablet

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . assumed to provide a distributed, consistent key-value store. The default topology service plugin is etcd2. The topology service exists for several reasons: • It enables tablets to coordinate among themselves dependencies required to build and run Vitess: sudo yum install -y make unzip g++ etcd curl git wget Notes: • We will be using etcd as the topology service. The command make tools can also install Zookeeper

ShardingSphere document, v5.0.0 3.2.4 集群模式 适用于分布式场景，它提供了多个计算节点之间的元数据共享和状态协调。需要提供用于分布式协调的 注册中心组件，如：ZooKeeper、Etcd 等。 3.3 DistSQL 3.3.1 背景 DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言，提供了标准 SQL 0 另一方面，不同节点节点之间的统一协调，策略与规则的同步，也需要我们能够设计一套在分布式情况 下，进行全局事件通知机制，以及独占性操作的分布式协调锁机制。这方面，我们使用 Zookeeper/Etcd 等实现配置的同步，状态变更的通知，以及分布式锁来控制排他性操作。 同时，由于治理功能本身可以采用合适的第三方组件作为基础服务，需要我们抽象统一的接口，统一各 种不同的组件的标准调用 API，对接到治理功能模块。 最后对于可管理性和可观测性的要求，我们需要完善通过 UI 查询、操作和控制系统的功能，进一步完善 对于 tracing 和 APM 的支持。 4.5.3 目标 对于治理功能，目标如下： • 支持 Zookeeper/etcd，管理数据源、规则和策略的配置，管理各个 Proxy 实例的状态。 对于可观测性，目标如下： • 支持 OpenTracing/Skywalking 集成，实现调用链的跟踪； 4.5.4 治理

/var/lib/fdb/data 2. - Etcd: /var/lib/etcd/data 3. - minIO: /var/lib/minio/data 4. - Postgres: /var/lib/postgresql/data 在每个节点都要执行如下命令： 1. mkdir - p /var/lib/fdb/data /var/lib/etcd/data /var/lib/minio/data master 节点检查 PV： 1. kubectl get pv 如果存在 pv-fdb, pv-etcd, pv-minio, pv-postgres，请务必在运行脚本前删除它们： 1. kubectl delete pv pv-fdb pv-minio pv-postgres pv-etcd 2.13 PDB 部署和启动 在 master 节点，用 root 用户进入 PieCloudDB-2 export image_registry=10.24.31.157 3. export etcd_registry=10.24.31.157 4. export image_env=release 5. export pieclouddb_env=release 6. export etcd_env=library 7. export minio_env=library 8. export