Getting started with CockroachDB : a guide to using a modern, cloud-native, and distributed SQL database for your data-intensive apps / Kishen Das Kondabagilu Rajanna.

Format:

Book

Author/Creator:

Rajanna, Kishen Das Kondabagilu, author.

Language:

English

Subjects (All):

Database management.

SQL (Computer program language).

Cloud computing.

Application software--Development.

Application software.

Web applications.

Relational databases.

Physical Description:

1 online resource (246 pages)

Edition:

[First edition].

Place of Publication:

Birmingham, UK : Packt Publishing, [2022]

Biography/History:

Das Kondabagilu Rajanna Kishen: Kishen Das Kondabagilu Rajanna is currently working as a distributed query engineer at Adobe. His previous experience includes leading the data warehouse team at Cloudera, managing the SaaS platform at Rubrik, writing core services for the Oracle public cloud, and managing data infrastructure at Apple.

Summary:

Getting Started with CockroachDB helps you get to grips with the fundamentals of using CockroachDB effectively. From installation and configuration steps to troubleshooting common and not-so-common issues, this book covers all the necessary techniques to deploy and manage a high-performance database service.

Contents:

Cover

Title page

Copyright and Credits

Dedications

Contributors

Table of Contents

Preface

Section 1: Getting to Know CockroachDB

Chapter 1: CockroachDB - A Brief Introduction

The history and evolution of databases

SQL

Object-oriented databases

NoSQL

NewSQL

Database concepts

Cardinality

Overview of database models

Processing models

Embedded and mobile databases

Database storage engines

CAP theorem

Consistency and partition tolerance (CP)

Availability and partition tolerance (AP)

Consistency and availability (CA)

CockroachDB

Why yet another database?

Inspiration

Key terms and concepts

High-level overview

Summary

Chapter 2: How Does CockroachDB Work Internally?

Technical requirements

Installing a single-node CockroachDB cluster using Docker

Execution of a SQL query

SQL query execution

Parsing

Logical planning

Physical planning

Query execution

Managing a transactional key-value store

Data distribution across multiple nodes

The MSKVS

Meta ranges

Table data

Data replication for resilience and availability

What is consensus?

The Raft distributed consensus protocol

Interactions with the disk for data storage

Storage engine

Section 2: Exploring the Important Features of CockroachDB

Chapter 3: Atomicity, Consistency, Isolation, and Durability (ACID)

An overview of ACID properties

Atomicity

Consistency

Isolation

Durability

ACID from CockroachDB's perspective

Chapter 4: Geo-Partitioning

Introduction to geo-partitioning

Cloud, regions, and zones

Region

Zone

Regions and zones on various cloud providers

Geo-partitioning in CockroachDB

Single region

Multi-region.

Summary

Chapter 5: Fault Tolerance and Auto-Rebalancing

Achieving fault tolerance

Achieving fault tolerance at the storage layer

Working example of fault tolerance at play

Automatic rebalancing

Recovering from multi-node failures

Chapter 6: How Indexes Work in CockroachDB

Introduction to indexes

Different types of indexes

Primary indexes

Secondary indexes

Hash-sharded indexes

Duplicate indexes

Inverted indexes

Partial indexes

Spatial indexes

Table joins and indexes

Best practices while using indexes

Section 3: Working with CockroachDB

Chapter 7: Schema Creation and Management

DDL

CREATE

ALTER

DROP

DML

DQL

Supported data types

Column-level constraints

Table joins

Using sequences

Managing schema changes

Chapter 8: Exploring the Admin User Interface

Introducing the admin UI

Cluster overview

Metrics deep dive

Database and table definitions

Understanding sessions

Transactions

Tracking jobs

Chapter 9: An Overview Of Security Aspects

Introduction to security concepts

Client and node authentication

Generating certificates and keys

Client authentication

Node authentication

Authorization mechanisms

Roles

Privileges

Data encryption at rest and in flight

Encryption at rest

Encryption in flight

Audit logging

RTO and RPO

Keeping the network secure

Security best practices

Chapter 10: Troubleshooting Issues

Collecting debug logs

Log files

Log levels

Log channels

Emitting logs to an external sink

Gathering Cockroach debug logs

Connection issues

Tracking slow queries.

Capacity planning

Configuration issues

Guidelines to avoid issues during an upgrade

Network latency

Advanced debugging options

Chapter 11: Performance Benchmarking and Migration

Performance - Things to consider

Infrastructure

Popular benchmark suites

Benchmarking your specific use cases

Performance benchmarking for CockroachDB

Migration - Things to consider

Migrating from traditional databases

Migrating from PostgreSQL to CockroachDB

Appendix: Bibliography and Additional Resources

Index

Other Books You May Enjoy.

Notes:

Description based on print version record.

ISBN:

9781800567757

1800567758

OCLC:

1304905323