protocol to support heterogeneous languages. 1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data ${proxy_port} ${proxy_conf_directory} • Force start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh -f Use the -f parameter to force start the Proxy. This parameter will ignore the abnormal data source during ${proxy_port} -U ${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

protocol to support heterogeneous languages. 1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data ${proxy_port} ${proxy_conf_directory} • Force start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh -f Use the -f parameter to force start the Proxy. This parameter will ignore the abnormal data source during ${proxy_port} -U ${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

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 o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u ON i.user_id FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1; 3.1. Sharding

${proxy_port} ${proxy_conf_directory} • Force start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh -f Use the -f parameter to force start the Proxy. This parameter will ignore the abnormal data source during ${proxy_port} -U ${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 o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u ON i.user_id

o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u ON i.user_id FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1; Unsupported ER_SAMPLER_TYPE Jaeger sample rate type const, probabilistic, ratelimiting, remote const JAEGE R_SAMPLER_PARAM Jaeger sample rate pa‐ rameter const:0, 1, pr obabilistic:0.0 ‐ 1.0, ratelimiting:

o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u ON i.user_id FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1; Unsupported ER_SAMPLER_TYPE Jaeger sample rate type const、proba bilistic、ratel imiting、remote const JAEGE R_SAMPLER_PARAM Jaeger sam‐ ple rate parameter const:0、1, pr obabilistic:0.0 ‐ 1.0, ratelimiting:

o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 4.2. Sharding 35 Apache ShardingSphere document, v5.0.0 SELECT FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1; Unsupported Center Registry Center ˋ Zookeeper < h t t p s : / / z o o keeper.apac he.org/>ˋ__ Apache Curato r 3.6.x Support Support ˋEtcd ˋ__ jetcd v3 Support Support Change History 5.0

12 Apache ShardingSphere ElasticJob document C hi ld no de na me E p h e m e r a l n o d e Description el ec ti on :r aw ‐l at ex :ˋ i ns ta nc eˋ Y E S The IP address of the mas‐ ter node server interrupted in the middleThe sharding will not be triggered when the job is executed sh ar di ng :r aw ‐l at ex :ˋ p ro ce ss in gˋ Y E S The node held by the master node during sharding.If there be deleted when the mas‐ ter node sharding is over or the master node crashes f ai lo ve r: ra w‐ la te x: it em s :r aw ‐l at ex :ˋ s ha rd ˋ it em N O Once a job crashes, it will record to this

Center Registry Center ˋ Zookeeper < h t t p s : / / z o o keeper.apac he.org/>ˋ__ Apache Curato r 3.6.x Support Support ˋEtcd ˋ__ jetcd v3 Support Support Change History 5.0 cp -f prepared_conf/mysql-connector-java-5.1.47.jar apache-shardingsphere-*- shardingsphere-proxy-bin/lib cp -f prepared_conf/start.sh apache-shardingsphere-*-shardingsphere-proxy-bin/bin cp -f pre plot(dataset['4.1.1_version'], 'r--', color='blue', label='4.1.1_version') plt.plot(dataset['3.0.0_version'], 'r--', color='orange', label='3.0.0_version ') plt.plot(dataset['mysql_server'], 'r--', color='lime',

${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy： gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 2.2. ShardingSphere-Proxy o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u ON i.user_id FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1; 不支持 CASE WHEN