dbShards Features
Sharding Features
- MySQL-compatible C driver for compatibility with popular scripting languages such as PHP, Perl and Ruby.
- MySQL-compatible JDBC driver for Java applications, including full support for Spring JDBC, Hibernate and Java Persistence API (JPA)
- Comprehensive tools to perform initial sharding of single database into multiple shards
- Support for a wide range of sharding strategies and algorithms, including:
- Session-based Sharding
- Transaction-based Sharding
- Shard by range
- Shard by modulo
- Shard by application-provided shard id
- Support for physical and virtual shards
- Global table support for replicating dimension tables to all shards
Replication & Reliability Features
- High performance semi-synchronous reliable replication (no transactions are lost if the master fails)
- Transparent failover in case of master failure
- Support for auto_increment columns
- Planned failover allows master and slave to be switched, allowing maintenance to be performed without taking applications down
- Point-in-time backup and recovery