ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

Database Shard

Definition - What does Database Shard mean?

A database shard is a horizontal partition in a search engine or database. Each individual partition is known as shard or database shard. Each database shard is kept on a separate database server instance to help in spreading the load. Database shards are based on the fact that after a certain point it is feasible and cheaper to scale sites horizontally than vertically by adding more machines.

Techopedia explains Database Shard

Within a database, some data always remains in all database shards. In fact, all database shards act as the single source for the unique subset of data. One of the salient features associated with database shards is that they are much faster. Individual database shards can simply outperform a single large database due to its smaller size. There is significant reduction of disk I/O, as the ratio between the memory and data on disk is also improved. This also results in fewer database locks, faster index searches and improvement in individual transaction performances. Database sharding is a highly scalable technique in order to improve the overall performance and throughput of large database-centric business applications and high transactions.

Database shards help in improving scalability with growth in a near linear fashion. They are easier to manage as common database maintenance can be easily done on database shards. Database shards also help in reducing costs, as most implementations take advantage of lower-cost open-source databases.

There are challenges to having database shards, like having automated backups for the shards, database shard redundancy and disaster recovery strategy.

Database shards are increasingly becoming more popular due to the exponential rise in transaction volume and business application databases. Database shards are mostly used by social networking websites, online service providers and software as a service companies.

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.