CockroachDB: The Definitive Guide

CockroachDB is the distributed SQL database that handles the demands of today’s data-driven applications. The second edition of this popular hands-on guide shows software developers, architects, and DevOps/SRE teams how to use CockroachDB for applications that scale elastically and provide seamless delivery for end users while remaining indestructible.

Data professionals will learn how to migrate existing applications to CockroachDB’s performant, cloud-native data architecture. You’ll also quickly discover the benefits of strong data correctness and consistency guarantees, plus optimizations for delivering ultra-low latencies to globally distributed end users.

• Uncover the power of distributed SQL
• Learn how to start, manage, and optimize projects in CockroachDB
• Explore best practices for data modeling, schema design, and distributed infrastructure
• Discover strategies for migrating data into CockroachDB
• See how to read, write, and run ACID transactions across distributed systems
• Maximize resiliency in multiregion clusters
• Secure, monitor, and fine-tune your CockroachDB deployment for peak performance

Table of Contents

Part I. Introduction to CockroachDB

Chapter 1. Introduction to CockroachDB

Chapter 2. CockroachDB Architecture

Chapter 3. Getting Started

Chapter 4. CockroachDB SQL

Part II. Developing Applications with CockroachDB

Chapter 5. CockroachDB Schema Design

Chapter 6. Application Design and Implementation

Chapter 7. Application Migration and Integration

Chapter 8. SQL Tuning

Part Ill. Deploying and Administering CockroachDB

Chapter 9. Planning a Deployment

Chapter 10. Single-Region Deployment

Chapter 11. Multiregion Deployment

Chapter 12. Backup and Disaster Recovery

Chapter 13. Security

Chapter 14. Administration and Troubleshooting

About the Authors

Guy Harrison is CTO at ProvenDB and a software professional with more than 20 years of experience in database design, development, administration, and optimization. He is the author of Next Generation Databases (Apress), MongoDB Performance Tuning (Apress), Oracle Performance Survival Guide (Prentice Hall), MySQL Stored Procedure Programming (O’Reilly), AI, Quantum Computing and Web3 (self-published), and many other books and articles on database technology.

Jesse Seldess is VP of Education at Cockroach Labs, where he leads the documentation and training teams. He has nearly 20 years of experience in technical documentation and has built teams from the ground up at Cockroach Labs and AppNexus (now Xandr).

Ben Darnell is the cofounder and chief architect at Cockroach Labs, where he built the distributed consensus protocols that underpin CockroachDB’s transactional model. He started his career at Google and then went on to a series of startups where he saw firsthand the need for better scalable storage systems.

Rob Reid is Cockroach Labs’ Technical Evangelist and a software developer from London, England. In his career, he has written backend, frontend, and messaging software for the police, travel, finance, commodities, sports betting, telecoms, retail, and aerospace industries. He is the author of Practical CockroachDB: Building Fault- Tolerant Distributed SQL Databases (Apress) and Understanding Multi-Region Application Architecture (O’Reilly) and has two CockroachDB tattoos.