Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 5.1.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 5.1.3 Usage . . Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 5.2.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 5.2.3 Usage . . Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 5.3.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 5.4 ShardingSphere‐Scaling

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 4.1.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 4.1.3 Usage . . Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 4.2.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 4.2.3 Usage . . Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 268 4.3.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 4.4 ShardingSphere‐Scaling

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210 5.3.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 5.4 ShardingSphere‐Scaling gSphere-Proxy ShardingS phere-Sidecar Database Any My SQL/PostgreSQL My SQL/PostgreSQL Connections Count Cost High Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low v5.1.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Supported Languages Java Only Any Performance Low loss Relatively High loss Decentralization

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 5.3.2 Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234 6 Dev Manual 235 gSphere-Proxy ShardingS phere-Sidecar Database Any My SQL/PostgreSQL My SQL/PostgreSQL Connections Count Cost High Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low v5.1.2 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Supported Languages Java Only Any Performance Low loss Relatively High loss Decentralization

ShardingSphere can achieve smooth business migration without business intrusion. • Low Ops & Maintenance Cost ShardingSphere offers a flat learning curve to DBAs and is interaction‐friendly while allowing the v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Only Any Performance Low loss Relatively High loss Decentralization v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Only Any Performance Low loss Relatively High loss Decentralization

basic way to ensure data security. ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Shadow Database In full‐link online load testing scenarios, ShardingSphere ShardingSphere can achieve smooth business migration without business intrusion. • Low Ops & Maintenance Cost ShardingSphere offers a flat learning curve to DBAs and is interaction‐friendly while allowing the v5.2.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Only Any Performance Low loss Relatively High loss Decentralization

basic way to ensure data security. ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere business intrusion. 1.2. Product Features 2 Apache ShardingSphere document • Low Ops & Maintenance Cost ShardingSphere offers a flat learning curve to DBAs and is interaction‐friendly while allowing the document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Only Any Performance Low loss Relatively High loss Decentralization

basic way to ensure data security. ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere business intrusion. 1.2. Product Features 2 Apache ShardingSphere document • Low Ops & Maintenance Cost ShardingSphere offers a flat learning curve to DBAs and is interaction‐friendly while allowing the document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Only Any Performance Low loss Relatively High loss Decentralization

mapper XML file prevents the burden of writing SQL statements repeatedly in the application. In comparison to JDBC, almost 95% of the code is reduced using Mapper XML file in MyBatis. All these Mapped