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.
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