May 23, 2012

Post: MySQL Performance Forum: Hot Topics

As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance discussions as it names says…

Post: Sharding and Time Base Partitioning

… data belonging to same user is equal. Consider Blog or Forum as example – most likely few last posts will get majority… other type of this data. Besides separating “cold” data from “hot” it often makes sense to separate data based on its… makes sense to separate data on the server level. Keeping Hot and Production Critical dataset small you can both make system…

Post: RAID and Scale Out Discussions

… disks. For example for BoardReader now indexing almost billion of forum posts we decided to go ahead with raw drives for… volume internal storage option. Ie find me 12 or more hot swap SATA hard drives in the case in Dell range…