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

認識 CockroachDB！這本書是你實用的入門指南，從軟體安裝和基礎概念開始。然後教你如何建立適用於生產環境的 CockroachDB 叢集。你將掌握高可用性，並學習在單一和多區域模式下創建、優化和操作 CockroachDB 叢集。你還將遇到需要避免的反模式，以及整合測試和負載測試的技巧。

本書解釋了為什麼 CockroachDB 存在，介紹了它的主要優點，並迅速轉入安裝和配置 CockroachDB，以便你可以創建資料庫、將數據輸入到這些資料庫中，並從應用程式中查詢該數據。你將進一步了解 GDPR 和 CCPA 等數據隱私法規，以及 CockroachDB 的全球分佈數據功能如何幫助你遵守不斷變化的數據主權法規。從那裡，你將進入部署拓撲、整合測試和負載測試的指導、最佳實踐，以及生產部署的準備檢查清單。

你將學到什麼：
- 部署並與 CockroachDB 互動
- 設計和優化資料庫和表格
- 選擇正確的資料類型來建模你的數據
- 通過資料庫和表格加密保護數據
- 達到國際數據隱私法規的合規性
- 以增強性能的方式擴展你的資料庫
- 監控數據的變化和資料庫的健康狀態

適合閱讀對象：
希望為他們的數據提供安全、可靠且輕鬆分佈的開發人員和資料庫管理員；希望使用現代工具應對以前需要專門團隊解決的擴展挑戰的人；任何希望利用他們的資料庫解決非平凡的現實世界挑戰並保護他們的數據和使用者的人。

​Rob Reid is a software developer from London, England. In his career, he has written backend, frontend, and messaging software for the police, and travel, finance, commodity, sports betting, telecom, retail, and aerospace industries. He is an avid user of CockroachDB and has worked with the Cockroach Labs team in recent years to promote the database and embed it into development teams in the US and UK.

Rob Reid是來自英國倫敦的軟體開發人員。在他的職業生涯中，他曾為警察、旅遊、金融、商品、體育博彩、電信、零售和航空航天等行業撰寫後端、前端和訊息傳遞軟體。他是CockroachDB的狂熱使用者，近年來與Cockroach Labs團隊合作，推廣這個資料庫並將其嵌入美國和英國的開發團隊中。