ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

Sharding

Definition - What does Sharding mean?

Sharding refers to a specific type of database setup where multiple partitions create many pieces of a database that are then referred to as shards. This practice can help with server hosting and other aspects of database maintenance, and can also contribute to faster query times by diversifying the responsibilities of a database structure.

Techopedia explains Sharding

As a way to make database systems more scalable, database sharding has emerged as a kind of horizontal partitioning that can help deal with the problem of slower response times for growing databases. The distribution of database responsibilities across these multiple shards helps engineers to make the most of CPU, memory and resources for a given hardware set.

While sharding can be effective in terms of using resources efficiently, it can also make a project more complicated. Some issues with sharding involve which kinds of workers should share roles in developing partitioned database structures, as well as whether sharding is best for a particular infrastructure. Other key issues include backups for shards and reliability. Sharding is often used by companies that offer software as a service or other remote sourcing services, such as modern cloud computing services.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.