ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 9 3 Concepts The functions of Apache ShardingSphere OpenTelemetry - Logging - Prometheus plugins: Prometheus: host: "localhost" port: 9090 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" port: 5775 props: SERVICE_NAME: "shardingsphere-agent" "shardingsphere-agent" JAEGER_SAMPLER_TYPE: "const" JAEGER_SAMPLER_PARAM: "1" Zipkin: host: "localhost" port: 9411 props: SERVICE_NAME: "shardingsphere-agent" URL_VERSION: "/api/v2/spans" SAMPLER_TYPE:

ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.3 ShardingSphere-Scaling (Experimental) 2.3.1 Rule Configuration Edit %SHAR OpenTelemetry - Logging - Prometheus plugins: Prometheus: host: "localhost" port: 9090 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" port: 5775 props: SERVICE_NAME: "shardingsphere-agent" "shardingsphere-agent" JAEGER_SAMPLER_TYPE: "const" JAEGER_SAMPLER_PARAM: "1" Zipkin: host: "localhost" port: 9411 props: SERVICE_NAME: "shardingsphere-agent" URL_VERSION: "/api/v2/spans" SAMPLER_TYPE:

ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 6 Apache ShardingSphere document, v5.0.0-beta 2.3 S Logging plugins: Prometheus: host: “localhost”#prometheus host port: 9090 #prometheus port props: JVM_INFORMATION_COLLECTOR_ENABLED : “true”Jaeger: host: “localhost” #jaeger host port: 5775 #jaeger prot props: ARAM:“1”JAEGER_REPORTER_LOG_SPANS: “true”JAEGER_REPORTER_FLUSH_INTERVAL: “1”Zipkin: host: “localhost”#zipkin host port: 9411 #zipkin prot props: SERVICE_NAME: “shardingsphere‐agent”URL_VERSION: “/api/v2/spans”

的客户端命令直接操作 ShardingSphere‐Proxy 即可。以 MySQL 举例： mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.3 ShardingSphere-Scaling(Alpha) 2.3.1 1. 规则配置 编辑%SHARDINGSPHERE_SCALING_HOME%/conf/server plugins: Prometheus: host: “localhost”#prometheus 暴露的 host port: 9090 #prometheus 暴 露的端口 props: JVM_INFORMATION_COLLECTOR_ENABLED : “true”Jaeger: host: “localhost” #jaeger 服务的 host port: 5775 #jaeger 服务的端口 AM:“1”JAEGER_REPORTER_LOG_SPANS: “true”JAEGER_REPORTER_FLUSH_INTERVAL: “1”Zipkin: host: “localhost”#zipkin 服务的 host port: 9411 #zipkin 服务的 prot props: SERVICE_NAME: “shardingsphere‐agent”URL_VERSION:

的客户端命令直接操作 ShardingSphere‐Proxy 即可。以 MySQL 举例： mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.3 ShardingSphere-Scaling (Experimental) 2.3.1 1. 规则配置 编辑%SHARDINGSPHERE_PRO plugins: Prometheus: host: "localhost" #prometheus 暴露的 host port: 9090 #prometheus 暴露的端口 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" #jaeger 服务的 host port: 5775 #jaeger "1" JAEGER_REPORTER_LOG_SPANS: "true" JAEGER_REPORTER_FLUSH_INTERVAL: "1" Zipkin: host: "localhost" #zipkin 服务的 host port: 9411 #zipkin 服务的 prot props: SERVICE_NAME: "shardingsphere-agent" URL_VERSION:

ShardingSphere‐Proxy: mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} ShardingSphere‐Proxy: 2.2. ShardingSphere-Proxy 14 Apache ShardingSphere document, v5.2.0 gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 2.2. ShardingSphere-Proxy 15 3 Features with MySQL client: mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username}

的客户端命令直接操作 ShardingSphere‐Proxy 即可。以 MySQL 举例： mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 9 3 概念 Apache ShardingSphere 功能十分复杂，有数百模块之多，但众多模块间的概念却简单明了。大部分模块 OpenTelemetry - Logging - Prometheus plugins: Prometheus: host: "localhost" port: 9090 props: JVM_INFORMATION_COLLECTOR_ENABLED : "true" Jaeger: host: "localhost" port: 5775 props: SERVICE_NAME: "shardingsphere-agent" "shardingsphere-agent" JAEGER_SAMPLER_TYPE: "const" JAEGER_SAMPLER_PARAM: "1" Zipkin: host: "localhost" port: 9411 props: SERVICE_NAME: "shardingsphere-agent" URL_VERSION: "/api/v2/spans" SAMPLER_TYPE:

document mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} ${proxy_username} Use the openGauss client to connect to the ShardingSphere‐Proxy: gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 7.2. ShardingSphere-Proxy 18 8 Features OpenTelemetry. plugins: # logging: # File: # props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry:

v5.2.1 mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} ${proxy_username} Use the openGauss client to connect to the ShardingSphere‐Proxy: gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 2.2. ShardingSphere-Proxy 14 3 Features with MySQL client: mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username}

document mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} ${proxy_username} Use the openGauss client to connect to the ShardingSphere‐Proxy: gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 7.2. ShardingSphere-Proxy 18 8 Features OpenTelemetry. plugins: # logging: # File: # props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" # port: 9090 # props: # jvm-information-collector-enabled: "true" # tracing: # OpenTelemetry: