The blueprint to deliver distributed data at scale

Dive into the core concepts of distributed SQL, then explore the architecture and capabilities of CockroachDB, including its suitable use cases. Follow a step-by-step guide to getting started, both with a local installation and Cockroach Labs’ free cloud service, before finishing up with a walkthrough of CockroachDB’s SQL dialect.

• Chapter 1: Why Name a Database After Cockroaches?

• Chapter 2: CockroachDB Architecture

• Chapter 3: Getting Started

• Chapter 4: CockroachDB SQL

Learn the fundamentals of CockroachDB schema design. Then work through application design and implementation, as well as integration with and/or migration from other databases. Finally, practice working with data in CockroachDB, including managing transactions, exploring change data capture, and building SQL tuning skills.

• Chapter 5: CockroachDB Schema Design

• Chapter 6: Application Design & Implementation

• Chapter 7: Application Migration & Integration

• Chapter 8: SQL Tuning

The final section covers releasing your brand-new CockroachDB application into the wild. Learn how to master the planning and execution of single- and multi-region deployments. Essential topics include backup and disaster recovery; security; monitoring, administration, and troubleshooting; and cluster optimization.

• Chapter 9: Planning a Deployment

• Chapter 10: Single-Region Deployment

• Chapter 11: Multi-Region Deployment

• Chapter 12: Backup & Disaster Recovery

• Chapter 13: Security

• Chapter 14: Administration & Troubleshooting

• Chapter 15: Cluster Optimization