. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 ii 3.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 3.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 3.8.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 3.9 Shadow . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 3.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 ii 3.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 3.8.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 3.9 Shadow . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 8.7.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 8.8 Data Masking . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 8.7.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 8.8 Data Masking . . . . . . . . .

ar(TODO) ShardingSphere‐Sidecar (TODO) defines itself as a cloud‐native database agent of the Kubernetes envi‐ ronment, in charge of all database access in the form of a sidecar. It provides a mesh layer databases. What’s more, it also brings the same problem as data sharding, complicating developer and operator’s maintenance and operation. The following diagram has shown the complex topological rela‐ tions of a ShardingSphere‐Proxy in‐ stance in a Kubernetes cluster. 5.2. ShardingSphere-Proxy 156 Apache ShardingSphere document, v5.1.1 Requirements Kubernetes 1.18+ kubectl Helm 3.2.0+ If you need persistent

ar(TODO) ShardingSphere‐Sidecar (TODO) defines itself as a cloud‐native database agent of the Kubernetes envi‐ ronment, in charge of all database access in the form of a sidecar. It provides a mesh layer databases. What’s more, it also brings the same problem as data sharding, complicating developer and operator’s maintenance and operation. The following diagram has shown the complex topological rela‐ tions Use Helm Use Helm to provide guidance for the installation of ShardingSphere‐Proxy instance in Kubernetes clus‐ ter. Quick Start helm repo add shardingsphere https://shardingsphere.apache.org/charts

ar(TODO) ShardingSphere‐Sidecar (TODO) defines itself as a cloud native database agent of the Kubernetes en‐ vironment, in charge of all the access to the database in the form of sidecar. It provides provided by different database dialect, it is categorized into keyword, expression, literal value and operator. SQL is then converted into abstract syntax tree by syntactic parser. For example, the following single‐sharding route (equal mark as the operator of sharding key), multiple‐sharding route (IN as the operator of sharding key) and range sharding route (BETWEEN as the operator of sharding key). SQL without sharding

ample 使用 Helm 背景信息 使用 Helm 在 Kubernetes 集群中引导 ShardingSphere‐Proxy 实例进行安装。 4.2. ShardingSphere-Proxy 171 Apache ShardingSphere document, v5.2.0 前提条件 • kubernetes 1.18+ • kubectl • helm 3.3.0+ Number of ZooKeeper nodes ## replicaCount: 1 ## ZooKeeper Persistence parameters ## ref: https://kubernetes.io/docs/user-guide/persistent-volumes/ ## @param governance.zookeeper.persistence.enabled Enable accessModes: - ReadWriteOnce size: 8Gi ## ZooKeeper's resource requests and limits ## ref: https://kubernetes.io/docs/user-guide/compute-resources/ ## @param governance.zookeeper.resources.limits The resources

package 使用 Helm 背景信息 使用 Helm 在 Kubernetes 集群中引导 ShardingSphere‐Proxy 实例进行安装。关于 ShardingSphere Helm Charts 的更多内容可以参考：ShardingSphere‐on‐Cloud 子项目。 前提条件 • kubernetes 1.18+ • kubectl • helm 3.3.0+ Number of ZooKeeper nodes ## replicaCount: 1 ## ZooKeeper Persistence parameters ## ref: https://kubernetes.io/docs/user-guide/persistent-volumes/ ## @param governance.zookeeper.persistence.enabled Enable accessModes: - ReadWriteOnce size: 8Gi ## ZooKeeper's resource requests and limits ## ref: https://kubernetes.io/docs/user-guide/compute-resources/ ## @param governance.zookeeper.resources.limits The resources

package 使用 Helm 背景信息 使用 Helm 在 Kubernetes 集群中引导 ShardingSphere‐Proxy 实例进行安装。关于 ShardingSphere Helm Charts 的更多内容可以参考：ShardingSphere‐on‐Cloud 子项目。 前提条件 • kubernetes 1.18+ • kubectl • helm 3.3.0+ Number of ZooKeeper nodes ## replicaCount: 1 ## ZooKeeper Persistence parameters ## ref: https://kubernetes.io/docs/user-guide/persistent-volumes/ ## @param governance.zookeeper.persistence.enabled Enable accessModes: - ReadWriteOnce size: 8Gi ## ZooKeeper's resource requests and limits ## ref: https://kubernetes.io/docs/user-guide/compute-resources/ ## @param governance.zookeeper.resources.limits The resources