Many of us sooner or later have to scale our web applications. When we
are talking about scalability we are always talking about the data and
data storage. There are many options for data storage nowdays as
relational databases, key-value storages and document oriented storages ,
but great part of web applications are using MySQL relational database
as the main data storage maibly because of its flexebility. This article
describes one of the MySQL scaling approaches - partitioning.
Read complete article: Scaling MySQL database with partitioning & subpartitioning