Bookmark and Share
Tools for sharding
(Publish Date: 2009-8-18 11:33am, Total Visits: 4267, Today: 1, This Week: 2, This Month: 7)

(high performance MySQL 2nd Ed. Page 417~432)

1. MySQL proxy

HSCALE - Horizontal Scaling for MySQL

HSCALE is a plugin written for MySQL Proxy which allows you to transparently split up tables into multiple tables called partitions. In later versions you will be able to put each partition on a different MySQL server.

Spock Proxy

Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set.
Spock is built on Rails and ActiveRecord.

2. (

which is written in Java. Google

Hibernate Shards offers critical data clustering and support for horizontal partitioning (also called sharding) to Hibernate. Now, customers can keep their data in more than one relational database for whatever reason-too much data or to isolate certain datasets, for instance-without added complexity when building and managing applications. Hibernate Shards is designed to encapsulate and reduce the complexity of building applications that work with sharded datasets.

3. HiveDB (,

MySQLConf 09: This is Not a Web App: The Evolution of a MySQL Deployment at Google


MySQL Scale out

MySQL Cluster is designed not to have any single point of failure.

MySQL Sharding ?? (Share Nothing)


Database Sharding Blog


Database Sharding at Netlog, with MySQL and PHP

?“DataBase Sharding at Netlog”,?DataBase Scale Out

Sharding (Partition)???


A partition is a structure that divides a space into two parts. Multiple partitions can break up that space into an arbitrary number of parts. One common use is taking a single large table and splitting it into parts in order to place those parts that are accessed more frequently on faster (more expensive) storage.