Introduction

ShardingSphere-Proxy is the second product of Apache ShardingSphere. It defines itself as a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages.

  • Totally transparent to applications, it can be used directly as MySQL/PostgreSQL.
  • Applicable to any kind of client end that is compatible with MySQL/PostgreSQL protocol.

ShardingSphere-Proxy Architecture

Comparison

ShardingSphere-JDBC ShardingSphere-Proxy ShardingSphere-Sidecar
Database Any MySQL/PostgreSQL MySQL
Connections Count Cost High Low High
Supported Languages Java Only Any Any
Performance Low loss Relatively high loss Low loss
Decentralization Yes No Yes
Static Entry No Yes No

The advantages of ShardingSphere-Proxy lie in supporting heterogeneous languages and providing operational entries for DBA.