lightweight Java framework that provides additional services at Java’s JDBC layer. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes 3.2 Using ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

is a lightweight Java framework that provides additional services at Java’s JDBC layer. ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates databases. 1.3. Deployment 5 Apache ShardingSphere document, v5.2.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes 1.3.2 Using ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

provides additional services at Java’s JDBC layer. 1 Apache ShardingSphere document, v5.2.0 ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates databases. 1.3. Deployment 7 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes Independent ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database ng=UTF-8 username: root password: rules: sharding: tables: ... 2.2 ShardingSphere-Proxy 2.2.1 Get ShardingSphere-Proxy ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm /opt/shardingsphere‐proxy‐bin/ Please refer to Configuration Manual for more details. 2.2. ShardingSphere-Proxy 8 Apache ShardingSphere document, v5.1.2 2.2.3 Import Dependencies If the backend database

standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database modeConfig, dataSourceMap, ruleConfigs, props); 7 Apache ShardingSphere document, v5.1.1 2.2 ShardingSphere-Proxy 2.2.1 Rule Configuration Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Edit % directory sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL:

SQL92 followed databases. 1.1. Introduction 2 Apache ShardingSphere document, v5.0.0 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database createDataSource(dataSourceMap, configurations, properties); 7 Apache ShardingSphere document, v5.0.0 2.2 ShardingSphere-Proxy 2.2.1 1. Rule Configuration Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Please sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL:

standard database: MySQL, Oracle, SQLServer, PostgreSQL and any SQL92 followed databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database rceMap, configurations, properties); 5 Apache ShardingSphere document, v5.0.0-beta 2.2 ShardingSphere-Proxy 2.2.1 1. Rule Configuration Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Please sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: