Whether building from scratch or rearchitecting an existing app, modern distributed applications need a distributed database. This essential reference guide to CockroachDB, the world’s most evolved distributed SQL database, shows how to architect apps for effortless scale, bulletproof resilience, and low-latency performance for users anywhere.
Distributed SQL systems bring together the best ideas of databases from the last 50 years: the relational model, strong consistency guarantees, and elastic scalability. This trinity is what modern applications need to stay in the game.
DoorDash has been able to use CockroachDB to forklift-migrate and scale numerous workloads without having to rewrite applications — only small index or schema changes. This definitive resource is for both new engineers and seasoned veterans who want to learn CockroachDB’s internals, deployment, and capabilities. Engineers looking to build and run scalable applications using CockroachDB would do well to read this book.
Distributed SQL databases combine the benefits of the relational database model with native support for distributed cloud architecture. CockroachDB pairs the transactional consistency of standard SQL with elastic scalability, multi-region and multi-cloud deployment, and high levels of fault tolerance and availability. Developers thinking about their next-generation enterprise application requirements will find this guide very timely.
We know that sometimes (stuff) happens. And, at scale, (stuff) is always happening.
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.
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.
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.
Design and build applications for distributed infrastructure, including data modeling and schema design
Plan a CockroachDB deployment for resiliency and lowest possible latency across single-region and multi-region clusters
Migrate data into CockroachDB using the PostgreSQL wire protocol
Secure, monitor, and optimize your CockroachDB deployment
Read and write data and run ACID transactions across distributed infrastructure