Splitting a database into several pieces, usually to improve the speed and reliability of your application.
Sharding strictly speaking is a synonym for "horizontal partitioning" 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 partitioned based upon the geographic location of the web servers delivering each blog.
Sharding strictly speaking is a synonym for "horizontal partitioning" 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 partitioned 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.
by Brian Layman June 20, 2011
Get the sharding mug.Kindergarten communism
Best response is a Liberty Prime Quote like “Death is a Preferable Alternative to Communism”
Best response is a Liberty Prime Quote like “Death is a Preferable Alternative to Communism”
Person 1 eating candy
Person 2 can I have some
Person 1 no
Person 2 Sharing is Caring
Person 1 BETTER DEAD THAN RED
Person 2 can I have some
Person 1 no
Person 2 Sharing is Caring
Person 1 BETTER DEAD THAN RED
by Liberty Prime’s Canadian bro December 29, 2019
Get the Sharing is Caring mug.Related Words
The practice that is popular in Japan that involves the pulling down of unsuspecting women's tops in public exposing their breasts, known as "topsharking", whereas "lowsharking" involves the pulling down down of unsuspecting women's panties in public.
by bobbyrice January 12, 2007
Get the sharking mug.Taking a dump in a friend's toilet and closing the lid without flushing, similar to a sardine in a can.
by JermBoy May 31, 2010
Get the Shardine mug.A sharting spider is a particularly heinous sub-specie of the "Barking Spider" in that it's defense method is not just a warning signal and fowl smell, but also warns potential predators with a deposit of substance known by naturalists as 'beware brown'. They are particularly fond of burrowing in 'tighty whiteys'.
subject 1: (Notices subject 2's dirty underwear on the floor) "Woah! Either you never learned to wipe your ass or you were born without a sphincter!"
Subject 2: "What?....No...I'm dealing with an infestation of Sharting Spiders. That wasn't me!"
Subject 2: "What?....No...I'm dealing with an infestation of Sharting Spiders. That wasn't me!"
by Prince of dorkness June 21, 2010
Get the sharting spider mug.by great tit. May 14, 2011
Get the shedding caterpillars mug.by 🖕🏻😊🖕🏻 June 28, 2016
Get the sharing a blanket mug.