Page 38 of 128 (2549 total posts)

April 2022

March 2022

24-03-2022
The Basics of Database Sharding - Brent Ozar Unlimited®

The Basics of Database Sharding - Brent Ozar Unlimited®

Source: brentozar.com

There are many ways to scale out your database; many of these techniques require advanced management and expensive add-ons or editions. Database sharding is a flexible way of scaling out a database. In this presentation, Jeremiah Peschka explains how to scale out using database sharding, covers basic techniques, and shares some of the pitfalls. This...

Tags: sharding partitioning scaling architecture database
23-03-2022
Sharding your database

Sharding your database

Source: craigkerstiens.com

I’m increasingly encountering users on Heroku that are encountering the need to shard their data. For most users this is something you delay as long as possible as you can generally go for sometime before you have to worry about it. Additionally scaling up your database is often a reasonable approach early on and something I encourage as a starting point as scaling up is easy to do with regards to databases. However, for the 1% of users that do need to shard when the time comes many are left wondering where to start, hence the following guide.

Tags: database sharding partitioning scaling performance
23-03-2022
Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes - Dare Obasanjo

Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes - Dare Obasanjo

Source: 25hoursaday.com

OpiniDatabase sharding is the process of splitting up a database across multiple machines to improve the scalability of an application. The justification for database sharding is that after a certain scale point it is cheaper and more feasible to scale a site horizontally by adding more machines than to grow it vertically by adding beefier servers.

Tags: scaling database performance sharding paritioning b-trees hashtables indexes databases