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.Scalding hot diarehhea that when you are done you feel the need to stick a popsicle up your asshole for relief.
by Haywood Chablome April 8, 2005
Get the ass scalding diarehea mug.Related Words
shralding
• shrading
• shralping
• thralding
• shredding
• sharding
• Shielding
• shredding the cheese
• shredding the gnar
• Shadding
I was shalking to her the other night while I was on the toilet.
by Gelatini May 19, 2011
Get the Shalking mug.by bLoWsKiEs December 18, 2009
Get the shredding twine mug.by CharacterLimit April 29, 2020
Get the Shrödingers Dictator mug.The act of covering the the entire toilet seat with your ass when you take a dump, in order to minimise the spread of stink from your shit.
Lean back on the seat to plug up as much of the hole until you flush.
Note - May require a fat ass.
Lean back on the seat to plug up as much of the hole until you flush.
Note - May require a fat ass.
Guy wanting to take a shit: What are you doing in the bathroom?
Shitter: I'm giving birth to king kong's finger.
Guy wanting to take a shit: No way, I can't smell anything, you must be masturbating.
Shitter: Nah, I'm just shading the poo.
Shitter: I'm giving birth to king kong's finger.
Guy wanting to take a shit: No way, I can't smell anything, you must be masturbating.
Shitter: Nah, I'm just shading the poo.
by poo shader October 24, 2010
Get the Shading the poo mug.v. snowboarding
by JackieC January 26, 2004
Get the shredding mug.