Get a practical introduction to CockroachDB. This book starts with installation and foundational concepts and takes you through to creating clusters that are ready for production environments. You will learn how to create, optimize, and operate CockroarchDB clusters in single and multi-region environments. You 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. Just as quickly, you’ll be creating databases, getting data into those databases, and querying that data from your applications. You’ll progress to data privacy laws such as GDPR and CCPA, and learn how CockroachDB’s global distribution features can help you comply with ever-shifting data sovereignty regulations. From there, you’ll 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 modeling 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
Intermediate user level
| About the Author |
|
xi | |
| About the Technical Reviewer |
|
xiii | |
| Acknowledgments |
|
xv | |
| Introduction |
|
xvii | |
|
Chapter 1 The Reason for CockroachDB |
|
|
1 | (4) |
|
|
|
1 | (1) |
|
CockroachDB's Architecture |
|
|
2 | (1) |
|
What Does CockroachDB Solve? |
|
|
2 | (2) |
|
|
|
4 | (1) |
|
Chapter 2 Installing CockroachDB |
|
|
5 | (26) |
|
|
|
5 | (1) |
|
|
|
5 | (1) |
|
|
|
6 | (1) |
|
|
|
6 | (1) |
|
|
|
6 | (23) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
|
|
9 | (11) |
|
|
|
20 | (1) |
|
|
|
21 | (7) |
|
|
|
28 | (1) |
|
CockroachDB Serverless/Dedicated |
|
|
29 | (1) |
|
|
|
29 | (1) |
|
Connecting to Your Cluster |
|
|
29 | (1) |
|
|
|
30 | (1) |
|
|
|
31 | (36) |
|
|
|
31 | (2) |
|
|
|
33 | (22) |
|
|
|
33 | (1) |
|
|
|
34 | (3) |
|
|
|
37 | (1) |
|
|
|
38 | (1) |
|
|
|
39 | (1) |
|
|
|
39 | (1) |
|
|
|
40 | (1) |
|
|
|
41 | (2) |
|
|
|
43 | (1) |
|
|
|
44 | (1) |
|
|
|
45 | (1) |
|
|
|
46 | (2) |
|
|
|
48 | (1) |
|
|
|
49 | (1) |
|
|
|
50 | (1) |
|
|
|
51 | (2) |
|
|
|
53 | (2) |
|
|
|
55 | (3) |
|
|
|
58 | (9) |
|
|
|
59 | (4) |
|
|
|
63 | (4) |
|
Chapter 4 Managing CockroachDB from the Command Line |
|
|
67 | (16) |
|
|
|
67 | (1) |
|
The start and start-single-node Commands |
|
|
68 | (1) |
|
|
|
69 | (1) |
|
|
|
70 | (1) |
|
|
|
71 | (2) |
|
|
|
73 | (5) |
|
|
|
78 | (1) |
|
|
|
78 | (2) |
|
|
|
80 | (3) |
|
Chapter 5 Interacting with CockroachDB |
|
|
83 | (40) |
|
Connecting to CockroachDB |
|
|
83 | (13) |
|
|
|
83 | (5) |
|
Connecting Programmatically |
|
|
88 | (8) |
|
|
|
96 | (18) |
|
|
|
96 | (2) |
|
|
|
98 | (3) |
|
|
|
101 | (8) |
|
|
|
109 | (5) |
|
|
|
114 | (9) |
|
Exporting and Importing Data |
|
|
114 | (2) |
|
Watching for Database Changes |
|
|
116 | (7) |
|
|
|
123 | (16) |
|
|
|
123 | (2) |
|
Location-Specific Considerations |
|
|
125 | (4) |
|
UK Company with UK and European Customers |
|
|
125 | (1) |
|
European Company with European and American Customers |
|
|
126 | (1) |
|
American Company with American Customers |
|
|
127 | (1) |
|
American Company with American and European Customers |
|
|
127 | (1) |
|
A Non-Chinese Company with Chinese Customers |
|
|
128 | (1) |
|
Personally Identifiable Information |
|
|
129 | (1) |
|
|
|
129 | (10) |
|
|
|
130 | (3) |
|
|
|
133 | (6) |
|
Chapter 7 Deployment Topologies |
|
|
139 | (20) |
|
|
|
140 | (3) |
|
|
|
140 | (1) |
|
|
|
140 | (3) |
|
|
|
143 | (9) |
|
|
|
143 | (6) |
|
|
|
149 | (2) |
|
|
|
151 | (1) |
|
|
|
152 | (1) |
|
|
|
152 | (7) |
|
|
|
157 | (2) |
|
|
|
159 | (48) |
|
|
|
161 | (4) |
|
|
|
165 | (29) |
|
|
|
165 | (19) |
|
|
|
184 | (10) |
|
|
|
194 | (13) |
|
|
|
194 | (9) |
|
|
|
203 | (4) |
|
|
|
207 | (42) |
|
|
|
208 | (12) |
|
|
|
208 | (1) |
|
|
|
209 | (5) |
|
|
|
214 | (6) |
|
|
|
220 | (7) |
|
|
|
227 | (4) |
|
Backing Up and Restoring Data |
|
|
231 | (12) |
|
|
|
233 | (3) |
|
|
|
236 | (1) |
|
|
|
237 | (3) |
|
|
|
240 | (1) |
|
|
|
241 | (2) |
|
|
|
243 | (1) |
|
|
|
243 | (1) |
|
|
|
243 | (1) |
|
|
|
244 | (5) |
| Index |
|
249 | |
Rob Reid is a software developer from London, England. In his career, he has written backend, frontend, and messaging software for the police, 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.
