sharding


splitting a database into several pieces, usually to improve the speed and reliability of your application.

sharding strictly speaking is a synonym for “horizontal part-tioning” or dividing up a database table by its rows.

in common use, sharding refers to having some data for an app on one database server, and other data in another. often this is done by having specific tables hosted on specific servers, with a function determining which server contains the information being requested.

sharding is frequently discussed with regard to large web based applications, but is not limited to any particular industry.

as a practical example, a wordpress multisite installation hosting several hundred thousand blogs could have the tables for sites 1-100,000 running on one database server 100,001-200,000 on another or 200,001+ on a third. an alternative sharding implementation could be to have the 50 busiest blogs’ tables split between the first two servers all remaining blog data on the third server. likewise, data could be part-tioned based upon the geographic location of the web servers delivering each blog.
when our site became so popular it kept overwhelming our database servers, we looked into sharding the database between five different data centers.

Read Also:

  • Sharp as a whip

    probably a b-st-rdization of smart as a whip, meaning unusually intelligent or quick witted. often changed for comic effect by subst-tuting ‘whip’ for an object with no edges. “although arthur looks like a clueless dork, he’s as sharp as a whip and completely in control.” “as sharp as chewed gum, more like!”

  • shatnel

    the particles of poo that fly from the b-tt during an explosive release. “you got shatnel all over the wall”

  • Shatted

    owned. the word you utter when you’ve just been completely rocked. the word is basically a mix of shattered & sh-tted, meaning you’ve been shot down or beaten, or just plain f-cked over. the example will help more. random dude: holy f-ck! my house just burnt down, and i lost my wife and kids in […]

  • rævkjørt

    norwegian defininition of being f-cked in the -ss, usually used in a negative context. example 1: rævkjørte jævel! (-ssf-cked b-st-rd!). example 2: jeg ble nettop rævkjørt av en h-m- (i just got f-cked in the -ss by a f-ggot). note: using the word “f-ggot” instead of “gay” as it is normally to be used in […]

  • ragadoo

    1.noun, a reference from a wutang clan song.2. philipine security gaurd thats was shot on duty. 1. yo! shot that b-tch like a ragadoo. 2. phillip ragadoo was shot yesterday.


Disclaimer: sharding definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.