An Introduction to Distributed SQL

Описание: Application data demands have continued to rise. In response, database architects and administrators have become custodians of business applications and are expected to manage growing transaction loads across increasingly larger databases. In addition, these applications must be kept running securely, without downtime, and with minimal latency.

Distributed SQL is the solution to these modern application demands as it offers the consistency and structure of early relational databases with the scalability, survivability, and performance first pioneered in NoSQL databases.

Join this interactive session with Rob Reid, Technical Evangelist at Cockroach Labs to learn how using a distributed SQL database can help you deliver modern, resilient business applications faster, more cost-effectively, and more scalably. Specifically, in this session you will learn:
How distributed SQL came to be
Key characteristics of a distributed SQL database
Fundamentals of how CockroachDB, a modern distributed SQL solution, works
Challenges distributed SQL databases can solve in terms of horizontal scalability, high availability, resilience, data locality, and compliance

Introduction to Distributed SQL
00:00 Welcome and Introduction
00:40 A brief history of databases
02:08 What is CockroachDB?
02:35 Monolithic vs distributed systems
03:20 RPO and RTO explained
05:12 How to ensure resilience pins your data infrastructure
08:28 What is the impact of downtime?
10:24 What is consistency in a database?
11:08 What is resilience in a database?
11:23 The benefits of a geo-distributed database
11:56 Why databases should be easy to scale
12:28 What is a node in a database?
12:52 What is a cluster in a database?
13:08 Data locality explained
13:31 Ranges in databases explained
14:07 Replicas in databases explained
15:41 How read operations work in CockroachDB
16:42 How write operations work in CockroachDB
17:33 How replicas rebalance in CockroachDB
19:34 How SQL execution is distributed in CockroachDB
22:49 Cost-based optimizer in CockroachDB
23:56 A database you can deploy across multiple clouds
24:39 How a distributed SQL database can simplify your architecture

About Cockroach Labs:
Cockroach Labs is a pioneering software company at the forefront of database technology, dedicated to delivering resilient and scalable database solutions to run mission-critical workloads for the world's most important businesses. With a mission to scale when others fail, Cockroach Labs is revolutionizing the way businesses manage their data with its innovative cloud native distributed SQL database, CockroachDB.

More resources
Learn about CockroachDB and get started free: https://cockroa.ch/3Q3SVOu
Apply for a career with Cockroach Labs: https://cockroa.ch/4hJSYuQ