ShardingSphere-Proxy

1. Rule Configuration

Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Please refer to Configuration Manual for more details.

Edit %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml. Please refer to Configuration Manual for more details.

%SHARDINGSPHERE_PROXY_HOME% is the shardingsphere proxy extract path. for example: /Users/ss/shardingsphere-proxy-bin/

2. Import Dependencies

If the backend database is PostgreSQL, there’s no need for additional dependencies.

If the backend database is MySQL, please download mysql-connector-java-5.1.47.jar or mysql-connector-java-8.0.11.jar and put it into %SHARDINGSPHERE_PROXY_HOME%/lib directory.

3. Start Server

  • Use default configuration to start
sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh

Default port is 3307, default profile directory is %SHARDINGSPHERE_PROXY_HOME%/conf/ .

  • Customize port and profile directory
sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory}

4. Use ShardingSphere-Proxy

Use MySQL or PostgreSQL client to connect ShardingSphere-Proxy. For example with MySQL:

mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port}