How NOT to scale your database // True cost of manual sharding.

Описание: In this video you'll first learn how NOT to scale your database and then some details about the true cost of manual database sharding. Then we'll get into the automatic and cost-efficient way of sharding and scaling a database.

There is a full report detailing the ways that you can reduce manual operations and reduce costs. Get your copy of the report here: https://cockroa.ch/do-more-with-less

So you've outgrown your SQL database and it's time to scale out. That's a good problem to have – but it can also be a massively expensive one if you approach it the wrong way.

0:00 Intro
0:14 The problem with vertical scaling
0:47 Horizontal scaling/sharding
1:00 Challenge 1: partitioning the database
1:18 Challenge 2: linking the application with sharded nodes
2:23 Challenge 3: DB ops with manual sharding
3:09 Challenge 4: Usage pattern changes
3:24 Challenge 5: Scaling out again
3:43 What does all of this cost?
4:15 Is there a better way? Yes.
4:34 Automated sharding with distributed SQL

#cockroachdb #distributedsql