How to scale a database without sharding

Description

Scaling a relational database can be a complex task, but it doesn’t need to be. A Distributed SQL database, such as CockroachDB, delivers completely automated, effortless, and elastic cloud scale while guaranteeing transactions. It is a database that reimagines the execution and storage layers while still allowing you, the developer, to still use familiar SQL syntax. In the livestream we walk through how to never shard another database and gain effortless scale as well as: • Horizontal scale of a database without sharding • How active-active endpoints eliminate downtime • Online schema changes and rolling upgrades • Anchor rows of data to a location to improve performance 00:00 - 03:00 Scaling a database 03:00 - 07:49 Why do we scale databases? 07:49 - 11:14 The challenges of sharding 11:14 - 14:22 What is the cost of sharding? 14:23 - 17:36 How did we scale CockroachDB? 17:40 - 19:46 CockroachDB demo 19:46 - 22:00 How does CockroachDB handle data sharding? 22:00 - 24:03 Is there any machine or memory requirements to run Cockroach demo? 24:04 - 26:18 CockroachDB demo and enterprise license 26:20 - 33:48 What's going on underneath the covers of CockroachDB? 33:48 - 36:24 Raft and the distributed consensus protocol 36:24 - 37:54 Why Ben Darnell is the smartest database engineer 37:54 - 41:01 How does Raft scale? 41:02 - 44:09 More features of Cockroach 44:10 - 47:46 The overview of the Cockroach cluster 47:47 - 51:02 CockroachDB Dedicated vs CockroachDB 53:27 - 55:21 TPC-C database benchmarks 55:22 - 57:35 The importance of vendor published benchmarks #CockroachDB #DistributedSQL If you want to give CockroachDB Serverless a try I promise you can spin up a cluster faster than you could cook a bowl of ramen: www.cockroachlabs.com/serverless