Practical Cockroachdb: Building Fault-Tolerant Distributed SQL Databases

Meet CockroachDB! This book is your practical introduction and starts at the beginning, with software installation and foundational concepts. It then teaches you how to create CockroachDB clusters that are ready for production environments. You will master high availability. And you will learn to create, optimize, and operate CockroarchDB clusters in single- and multi-region patterns. You also will encounter anti-patterns to avoid, as well as testing techniques for integration and load testing.
The book explains why CockroachDB exists, goes over its major benefits, and quickly transitions into installing and configuring CockroachDB so you can create databases, get data into those databases, and query that data from your applications. You will progress to data privacy laws such as GDPR and CCPA, and learn how CockroachDB's global distribution data features can help you comply with ever-shifting data sovereignty regulations. From there, you move into deployment topologies, guidance on integration testing and load testing, best practices, and a readiness checklist for production deployments.
What You Will Learn

• Deploy and interact with CockroachDB
  
• Design and optimize databases and tables
• Choose the correct data types for modelling your data
• Protect data with database and table encryption
• Achieve compliance with international data privacy regulations
• Scale your databases in a way that enhances their performance
• Monitor changes to the data and health of your databases

Who This Book Is For
Developers and database administrators who want to provide a secure, reliable, and effortlessly distributed home for their data; those who wish to use a modern tool to tackle the kinds of scaling challenges that have previously required dedicated teams of people to solve; anyone who wants to leverage their database to solve non-trivial, real-world challenges while protecting their data and users