Home Articles FAQs XREF Games Software Instant Books BBS About FOLDOC RFCs Feedback Sitemap


You are here: irt.org | FOLDOC | sharding

<database> A form of data partitioning in which a large database table is split over multiple servers in order to balance load. Some property of the data is used to select which server should handle a given row, e.g. the primary id modulo the number of servers.

Sharding should be a last resort in database performance optimisation because of the difficulty of changing the allocation of data to servers, e.g. if the number of servers changes or the distribution is found to be uneven.

Sharding Your Database, Ovid, perl.org (http://blogs.perl.org/users/ovid/2010/05/sharding-your-database.html).


Nearby terms: ShapeTools « shar « sharchive « sharding » Share and enjoy! » shared memory » Shared Time Repair of Big Electronic Systems

FOLDOC, Topics, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, ?, ALL

©2018 Martin Webb