
A Definitive Guide to Apache ShardingSphere
By :

ShardingSphere-Proxy is a database proxy that is transparent to you or any user. It provides you with all the features of the Apache ShardingSphere ecosystem, such as sharding, read/write splitting, shadow database, data encryption/decryption, and distributed governance.
Unlike ShardingSphere-JDBC, ShardingSphere-Proxy implements some of the prevailing database-access protocols and, theoretically, can support all database clients that are based on the MySQL, PostgreSQL, and openGauss protocols. When you utilize ShardingSphere-Proxy, you will feel it effectively works in the same way as a database.
The following is ShardingSphere-Proxy's deployment overview diagram:
Figure 5.3 – The ShardingSphere-Proxy topography
As you can see, the proxy is positioned above multiple databases and below multiple applications. This is especially convenient if you plan on connecting multiple applications and database instances as, with...