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

Get hands-on with deploying and managing your database services to provide scalable and high-speed data access on CockroachDB. 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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Rajanna, Kishen Das Kondabagilu (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing, 2022.
Edición:[First edition].
Temas:
Database management.
SQL (Computer program language)
Cloud computing.
Application software > Development.
Web applications.
Relational databases.
Bases de données > Gestion.
SQL (Langage de programmation)
Infonuagique.
Logiciels d'application > Développement.
Applications Web.
Bases de données relationnelles.
Application software > Development
Cloud computing
Database management
Relational databases
Web applications
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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
  • Summary
  • 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
  • Atomicity
  • Consistency
  • Isolation
  • Durability
  • Summary
  • Chapter 4: Geo-Partitioning
  • Technical requirements
  • 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
  • Technical requirements
  • Achieving fault tolerance
  • Achieving fault tolerance at the storage layer
  • Working example of fault tolerance at play
  • Automatic rebalancing
  • Recovering from multi-node failures
  • Summary
  • Chapter 6: How Indexes Work in CockroachDB
  • Technical requirements
  • 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
  • Summary
  • Section 3: Working with CockroachDB
  • Chapter 7: Schema Creation and Management
  • Technical requirements
  • DDL
  • CREATE
  • ALTER
  • DROP
  • DML
  • DQL
  • Supported data types
  • Column-level constraints
  • Table joins
  • Using sequences
  • Managing schema changes
  • Summary
  • Chapter 8: Exploring the Admin User Interface
  • Technical requirements
  • Introducing the admin UI
  • Cluster overview
  • Metrics deep dive

Ejemplares similares