Link Blog

Page 38 of 128 (2551 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