Book Image

Getting Started with CockroachDB

By : Kishen Das Kondabagilu Rajanna
Book Image

Getting Started with CockroachDB

By: Kishen Das Kondabagilu Rajanna

Overview of this book

Getting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through a SQL interface. The book will also uncover how you can use the database to provide solutions where the data is highly available. Starting with CockroachDB's installation, setup, and configuration, this SQL 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 and serve it locally. In addition to this, you'll get to grips with fault tolerance and auto-rebalancing, how indexes work, and the CockroachDB Admin UI. The book will guide you in building scalable cloud services on top of CockroachDB, covering administrative and security aspects and tips for troubleshooting, performance enhancements, and a brief guideline on migrating from traditional databases. By the end of this book, you'll have gained sufficient knowledge to manage your data on CockroachDB and interact with it from your application layer.

Related Content you might be interested in

Current Title:

Small book image
Getting Started with CockroachDB
Kishen Das Kondabagilu Rajanna
Mar, 2022 | 246 pages
No titles found
Table of Contents (17 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the color images
Conventions used
Get in touch
Share Your Thoughts
1
Section 1: Getting to Know CockroachDB
Section 1: Getting to Know CockroachDB
Free Chapter
2
Chapter 1: CockroachDB – A Brief Introduction
Chapter 1: CockroachDB – A Brief Introduction
The history and evolution of databases
Database concepts
CAP theorem
CockroachDB
Summary
3
Chapter 2: How Does CockroachDB Work Internally?
Chapter 2: How Does CockroachDB Work Internally?
Technical requirements
Installing a single-node CockroachDB cluster using Docker
Execution of a SQL query
Managing a transactional key-value store
Data distribution across multiple nodes
Data replication for resilience and availability
Interactions with the disk for data storage
Summary
4
Section 2: Exploring the Important Features of CockroachDB
Section 2: Exploring the Important Features of CockroachDB
5
Chapter 3: Atomicity, Consistency, Isolation, and Durability (ACID)
Chapter 3: Atomicity, Consistency, Isolation, and Durability (ACID)
An overview of ACID properties
ACID from CockroachDB's perspective
Summary
6
Chapter 4: Geo-Partitioning
Chapter 4: Geo-Partitioning
Technical requirements
Introduction to geo-partitioning
Cloud, regions, and zones
Geo-partitioning in CockroachDB
Summary
7
Chapter 5: Fault Tolerance and Auto-Rebalancing
Chapter 5: Fault Tolerance and Auto-Rebalancing
Technical requirements
Achieving fault tolerance
Automatic rebalancing
Recovering from multi-node failures
Summary
8
Chapter 6: How Indexes Work in CockroachDB
Chapter 6: How Indexes Work in CockroachDB
Technical requirements
Introduction to indexes
Different types of indexes
Best practices while using indexes
Summary
9
Section 3: Working with CockroachDB
Section 3: Working with CockroachDB
10
Chapter 7: Schema Creation and Management
Chapter 7: Schema Creation and Management
Technical requirements
DDL
DML
DQL
Supported data types
Column-level constraints
Table joins
Using sequences
Managing schema changes
Summary
11
Chapter 8: Exploring the Admin User Interface
Chapter 8: Exploring the Admin User Interface
Technical requirements
Introducing the admin UI
Cluster overview
Metrics deep dive
Database and table definitions
Understanding sessions
Transactions
Tracking jobs
Summary
12
Chapter 9: An Overview Of Security Aspects
Chapter 9: An Overview Of Security Aspects
Technical requirements
Introduction to security concepts
Client and node authentication
Authorization mechanisms
Data encryption at rest and in flight
Audit logging
RTO and RPO
Keeping the network secure
Security best practices
Summary
13
Chapter 10: Troubleshooting Issues
Chapter 10: Troubleshooting Issues
Technical requirements
Collecting debug logs
Connection issues
Tracking slow queries
Capacity planning
Configuration issues
Guidelines to avoid issues during an upgrade
Network latency
Advanced debugging options
Summary
14
Chapter 11: Performance Benchmarking and Migration
Chapter 11: Performance Benchmarking and Migration
Technical requirements
Performance – Things to consider
Performance benchmarking for CockroachDB
Migration – Things to consider
Migrating from traditional databases
Summary
15
Other Books You May Enjoy
Other Books You May Enjoy
Packt is searching for authors like you
Share Your Thoughts
Appendix: Bibliography and Additional Resources
Appendix: Bibliography and Additional Resources
Why subscribe?

Audit logging

SQL audit logging is an important security feature that you can use to track all the activities that are occurring in a given CockroachDB cluster. Specifically, you can select tables whose activity must be tracked and only enable audit logging on them.

The following information gets logged during auditing:

  • Full query text.
  • The date and time of the query.
  • The client's IP address.
  • The application's name.
  • The user.
  • The event type, which will be SENSITIVE_TABLE_ACCESS. This indicates that it's an event related to SQL audit logging.
  • The name of the table that was queried.

Now, let's look at an example. We will enable audit logging for one of the tables in the default databases. startrek is a database that comes by default with the open source CockroachDB: 

$ show databases;
  database_name | owner | primary_region | regions | survival_goal
----------------+-------+----------------+---------+----...
Previous Section
End of Section 7
Next Section