book

Getting Started with CockroachDB

by Kishen Das Kondabagilu Rajanna

March 2022

Intermediate to advanced

246 pages

4h 36m

English

Packt Publishing

Read now

Unlock full access

ContributorsAbout the authorAbout the reviewers
Who this book is forWhat this book coversTo get the most out of this bookDownload the example code filesDownload the color imagesConventions usedGet in touchShare Your Thoughts
The history and evolution of databasesSQLObject-oriented databases NoSQLNewSQLDatabase concepts CardinalityOverview of database modelsProcessing modelsEmbedded and mobile databasesDatabase storage enginesCAP theoremConsistency and partition tolerance (CP)Availability and partition tolerance (AP)Consistency and availability (CA)CockroachDBWhy yet another database?InspirationKey terms and conceptsHigh-level overviewSummary
Technical requirementsInstalling a single-node CockroachDB cluster using DockerExecution of a SQL querySQL query executionParsing Logical planningPhysical planningQuery execution Managing a transactional key-value storeData distribution across multiple nodesThe MSKVSMeta ranges Table dataData replication for resilience and availabilityWhat is consensus? The Raft distributed consensus protocolInteractions with the disk for data storageStorage engine Summary
An overview of ACID propertiesAtomicity Consistency Isolation Durability ACID from CockroachDB's perspectiveAtomicity Consistency IsolationDurability Summary
Technical requirementsIntroduction to geo-partitioning Cloud, regions, and zonesRegionZone Regions and zones on various cloud providersGeo-partitioning in CockroachDBSingle region Multi-region Summary
Technical requirements Achieving fault tolerance Achieving fault tolerance at the storage layerWorking example of fault tolerance at playAutomatic rebalancing Recovering from multi-node failures Summary
Technical requirementsIntroduction to indexesDifferent types of indexesPrimary indexesSecondary indexes Hash-sharded indexesDuplicate indexesInverted indexes Partial indexesSpatial indexesTable joins and indexesBest practices while using indexes Summary

Technical requirementsDDLCREATE ALTER DROPDMLDQLSupported data typesColumn-level constraints Table joinsUsing sequencesManaging schema changesSummary
Technical requirementsIntroducing the admin UICluster overview Metrics deep dive Database and table definitionsUnderstanding sessions Transactions Tracking jobsSummary
Technical requirements Introduction to security conceptsClient and node authenticationGenerating certificates and keys Client authentication Node authenticationAuthorization mechanismsRoles PrivilegesData encryption at rest and in flightEncryption at restEncryption in flightAudit logging RTO and RPOKeeping the network secureSecurity best practicesSummary
Technical requirements Collecting debug logsLog files Log levels Log channels Emitting logs to an external sinkGathering Cockroach debug logs Connection issuesTracking slow queriesCapacity planningConfiguration issuesGuidelines to avoid issues during an upgradeNetwork latencyAdvanced debugging optionsSummary
Technical requirements Performance – Things to consider Infrastructure Popular benchmark suites Benchmarking your specific use casesPerformance benchmarking for CockroachDBMigration – Things to consider Migrating from traditional databasesMigrating from PostgreSQL to CockroachDBSummary
Other Books You May EnjoyPackt is searching for authors like youShare Your Thoughts

Content preview from Getting Started with CockroachDB

Preface

This book will introduce you to the inner workings of CockroachDB and help you understand how it provides faster access to distributed data through a SQL interface. You'll learn how you can use the database to provide solutions that require data to be highly available.

Starting with CockroachDB's installation, setup, and configuration, this book will familiarize you with the database architecture and database design principles. You'll then discover several options that CockroachDB provides to store multiple copies of your data to ensure fast data access. The book covers the internals of CockroachDB, how to deploy and manage it on the cloud, performance tuning to get the best out of CockroachDB, and how to scale data across continents ...