Sharding-JDBC-Server is the MySQL protocol agent based on Sharding-JDBC, and more friendly for management and debugging. You can use any clients compatible with MySQL protocol, e.g. MySQL Command Client, MySQL Workbench to connect to Sharding-JDBC-Server to query and modify data.

In brief, Sharding-JDBC-Server is a standard MySQL (Other databases might be included in future) that also supports Sharding, Read-write-splitting, and orchestration and is also like the management interface for all back-end MySQL Sharding. In fact, it is the control node, the management node, and the routing node.

Sharding-JDBC-Server is suitable for uses to manage and debug, and can be connected easily by various MySQL clients, and Sharding-JDBC is more suitable for online programs for it reduces the cost of secondary transmit.


  1. Download the latest version of Sharding-JDBC-Server from
  2. Modify the conf/sharding-config.yaml file after decompression, and configure the sharding rule. Refer to The YAML configuration in Sharding-JDBC
  3. Run bin/ in Linux, or bin/start.bat in Windows to start Sharding-JDBC-Server.
  4. Connect to it by means of any client tools, e.g. mysql -u root -h -P3307


  1. The default port of Sharding-JDBC-Server is 3307, and can be changed by passing the port parameter to the startup script, e.g. bin/ 3308.
  2. There is only one logical data source in Sharding-JDBC-Server, named sharding-db.
  3. Currently, Sharding-JDBC-Server does not support authorization, therefore you can login with any username and password at startup.