Apache ShardingSphere
Apache ShardingSphere is an open-source ecosystem for distributed database systems providing data sharding, distributed transactions, and database governance. It supports MySQL, PostgreSQL, and other databases with transparent sharding capabilities.
APIs
Apache ShardingSphere
ShardingSphere provides ShardingSphere-JDBC for Java applications, ShardingSphere-Proxy with MySQL/PostgreSQL wire protocol compatibility, DistSQL for distributed database manag...
Capabilities
Features
Horizontal database sharding with flexible sharding algorithms
Transparent primary/replica read-write splitting
XA and BASE distributed transaction support
Transparent data encryption at the SQL layer
Shadow database for production traffic testing
SQL-based distributed database management language
Query across heterogeneous database instances
Use Cases
Horizontally scale relational databases without changing application code
Shard data by tenant ID for SaaS applications
Scale read traffic with primary/replica splitting
Online data migration between database clusters
Integrations
MySQL-compatible sharding and proxy
PostgreSQL protocol support for sharding
Cluster coordination and configuration storage
ShardingSphere Spring Boot starter for Java applications
Kubernetes operator for cloud-native deployment