CockroachDB: The Definitive Guide. 2nd Edition Guy Harrison, Jesse Seldess, Ben Darnell

Spis treści książki

• Preface
  • Building CockroachDB
  • Next Steps
  • Why We Wrote This Book
  • Who This Book Is For
  • How This Book Is Organized
  • Conventions Used in This Book
  • Accessing the Books Images Online
  • Using Code Examples
  • OReilly Online Learning
  • How to Contact Us
  • Acknowledgments
    • Guy Harrison
    • Jesse Seldess
    • Ben Darnell
    • Rob Reid
• I. Introduction to CockroachDB
• 1. Introduction to CockroachDB
  • A Brief History of Databases
    • Pre-Relational Databases
    • The Relational Model
    • Implementing the Relational Model
    • Transactions
    • The SQL Language
    • The RDBMS Hegemony
    • Enter the Internet
    • The NoSQL Movement
    • The Emergence of Distributed SQL
  • The Advent of CockroachDB
    • CockroachDB Design Goals
    • CockroachDB Releases
  • CockroachDB in Action
    • CockroachDB at Netflix
    • CockroachDB at Devsisters
    • CockroachDB at DoorDash
    • CockroachDB at Bose
    • CockroachDB at Form3
    • CockroachDB at Hard Rock Digital
    • CockroachDB at Spreedly
    • CockroachDB at Route
  • Summary
• 2. CockroachDB Architecture
  • The CockroachDB Cluster Architecture
  • The CockroachDB Software Stack
  • The CockroachDB SQL Layer
  • From SQL to Key-Values
    • Tables as Represented in the KV Store
    • Column Families
    • Indexes in the KV Store
    • Inverted Indexes
    • The STORING Clause
    • Table Definitions and Schema Changes
  • The CockroachDB Transaction Layer
    • MVCC Principles
    • Transaction Workflow
    • Write Intents
    • Parallel Commits
    • Transaction Cleanup
    • Overview of Transaction Flow
    • Read/Write Conflicts
    • Clock Synchronization and Clock Skew
  • The CockroachDB Distribution Layer
    • Meta Ranges
    • Gossip
    • Leaseholders
    • Range Splits
    • Multiregion Distribution
  • The CockroachDB Replication Layer
    • Raft
    • Raft and Leaseholders
    • Closed Timestamps and Follower Reads
  • The CockroachDB Storage Layer
    • Log-Structured Merge Trees
    • SSTables and Bloom Filters
    • Deletes and Updates
    • Multiversion Concurrency Control
    • The Block Cache
  • Summary
• 3. Getting Started
  • Installation
    • Installing CockroachDB Software
      • Installation on macOS
      • Installation on Linux
      • Installation on Microsoft Windows
    • Creating a CockroachDB Cloud Basic Instance
    • Starting a Local Single-Node Server
    • Starting Up CockroachDB in a Docker Container
    • Starting Up a Secure Server
    • Shutting Down the Server
    • Remote Connection
    • Creating a Kubernetes Cluster
    • Creating a Cluster with Terraform
  • Using a GUI Client
  • Exploring CockroachDB
    • Adding Some Data
    • Databases and Tables
    • Issuing SQL
    • The DB Console
  • Working with Programming Languages
    • Connecting to CockroachDB from Node.js
    • Connecting to CockroachDB from Java
    • Connecting to CockroachDB from Python
    • Connecting to CockroachDB from Go
  • Summary
• 4. CockroachDB SQL
  • SQL Language Compatibility
  • Querying Data with SELECT
    • The SELECT List
    • The FROM Clause
    • Joins
    • Anti-Joins
    • Cross Joins
    • Set Operations
    • Group Operations
    • Subqueries
    • Correlated Subquery
    • Lateral Subquery
    • The WHERE Clause
    • Common Table Expressions
    • ORDER BY
    • Window Functions
    • Other SELECT Clauses
    • CockroachDB Arrays
    • Working with JSON
    • Summary of SELECT
  • Creating Tables and Indexes
    • Column Definitions
    • Computed Columns
    • Data Types
    • Primary Keys
    • Constraints
    • Indexes
      • Inverted indexes
      • Hash-sharded indexes
    • Vectors
    • CREATE TABLE AS SELECT
    • Altering Tables
    • Dropping Tables
    • Views
    • Functions
    • Procedures
  • Inserting Data
  • UPDATE
  • UPSERT
  • DELETE
  • TRUNCATE
  • IMPORT INTO
  • Transactional Statements
    • BEGIN Transaction
    • SAVEPOINT
    • COMMIT
    • ROLLBACK
    • SELECT FOR UPDATE
    • SELECT FOR SHARE
    • AS OF SYSTEM TIME
  • Other Data Definition Language Targets
  • Administrative Commands
  • The Information Schema
  • Summary
• II. Developing Applications with CockroachDB
• 5. CockroachDB Schema Design
  • Logical Data Modeling
    • Normalization
    • Dont Go Too Far
    • Primary Key Choices
    • Special-Purpose Designs
  • Physical Design
    • Entities to Tables
    • Attributes to Columns
    • Primary Key Design
      • UUID-based primary keys
      • Avoiding hotspots with a composite key
      • Hash-sharded primary keys
      • Ordering of primary key attributes
      • Summary of primary key performance
    • Foreign Key Constraints
  • Denormalization
    • Replicating Columns to Avoid Joins
    • Summary Tables
    • Vertical Partitioning
    • Horizontal Partitioning
    • Repeating Groups
  • JSON Document Models
    • JSON Document Antipatterns
    • Indexing JSON Attributes
    • Using JSON or Arrays to Avoid Joins
  • Indexes
    • Index Selectivity
    • Index Break-Even Point
    • Index Overhead
    • Composite Indexes
    • Covering Indexes
    • Composite and Covering Index Performance
    • Guidelines for Composite Indexes
    • Indexes and Null Values
    • Inverted Indexes
    • Partial Indexes
    • Sort-Optimizing Indexes
    • Expression Indexes
    • Full-Text Indexes
    • Spatial Indexes
    • Hash-Sharded Indexes
    • Measuring Index Effectiveness
  • Summary
• 6. Application Design and Implementation
  • CockroachDB Programming
    • Performing CRUD Operations
    • Connection Pools
    • Prepared and Parameterized Statements
    • Batch Inserts
    • Pagination of Results
    • Projections
    • Client-Side Caching
  • Managing Transactions
    • Transaction Retry Errors
    • Implementing Transaction Retries
    • Automatic Transaction Retries
    • Using FOR UPDATE to Avoid Transaction Retry Errors
    • Reducing Contention by Eliminating Hot Rows
    • Reducing Transaction Elapsed Time
    • Reordering Statements
    • Time Travel Queries
    • Ambiguous Transactions Errors
    • Deadlocks
    • Transaction Priorities
  • Working with ORM Frameworks
  • Row-Level TTL
  • Summary
• 7. Application Migration and Integration
  • Migration Objectives
    • Database Consolidation
    • Failover Regions
    • Fragile Data Integrations
    • Unnecessary Caching Tier
    • Unnecessary Data Warehouse Workloads
    • Application Silos
  • Loading Data
    • File Locations
      • userfile storage
      • HTTP storage
      • Cloud storage
    • Importing from userfile Storage
    • Importing from Cloud Storage
    • Import Performance
  • Migrating from Another Database
    • Extracting and Converting DDL
      • Extracting Oracle DDL
      • Extracting DDL from SQL Server
      • Extracting DDL from MySQL
      • Extracting DDL from PostgreSQL
    • General Considerations When Converting DDL
    • Exporting Data
    • Migrating Schemas to CockroachDB
    • Loading Data into CockroachDB with MOLT Fetch
    • Loading Data into CockroachDB with IMPORT INTO
    • Directly Importing PostgreSQL or MySQL Dumps
    • Synchronizing and Switching Over
    • Updating Application Code
  • Mainframe Migrations
  • Exporting CockroachDB Data
  • Change Data Capture
    • Core Change Data Capture
    • Using the Changefeed Programmatically
    • Enterprise Change Data Capture
    • CDC Queries
      • Using cloud sinks
      • Webhook sinks
      • Managing jobs
    • Change Data Capture to Kafka
    • Change Data Capture to Pulsar
    • Change Data Capture to Snowflake
  • Summary
• 8. SQL Tuning
  • Finding Slow SQL
  • Explaining and Tracing SQL
    • EXPLAIN ANALYZE
    • EXPLAIN Options
    • EXPLAIN DEBUG
  • Changing SQL Execution
    • Optimizing Table Lookups
      • Index lookups
      • Index merges
      • Query distribution
      • Index hints
      • Full scans
      • Computed columns to the rescue
    • Optimizing Joins
    • Join Methods
      • Lookup joins
      • Hash and merge joins
      • Join hints
      • Outer joins and anti-joins
    • Optimizing Sorting and Aggregation
    • Disk Sorts
    • Optimizing DML
  • Optimizing the Optimizer
    • Optimizer Statistics
    • Viewing Statistics
    • Automatic Statistics
    • Manually Collecting Statistics
  • Summary
• III. Deploying and Administering CockroachDB
• 9. Planning a Deployment
  • Know Your Requirements
  • Comparison of Deployment Options
  • CockroachDB Cloud Basic Deployments
  • CockroachDB Cloud Standard Deployments
  • Single-Region Advanced Deployments
    • Common Planning TasksAdvanced Deployments
    • Benchmarking and Capacity Planning
    • CockroachDB Cloud Deployments
    • Self-Hosted on a Cloud Platform
    • Self-Hosted Bare-Metal On-Premises
    • Other Self-Hosted Considerations
    • Self-Hosted Kubernetes
  • Configuring for Self-Hosted High Availability
    • Disk Failure
    • Node Failures
    • Network Failure
    • Zone and Region Topologies
  • Summary
• 10. Single-Region Deployment
  • Deploying On-Premises or On-Cloud
    • Firewall Configuration
    • Operating System Configuration
    • Clock Synchronization On-Premises
    • Clock Synchronization on Cloud Platforms
    • Creating Certificates
    • Configuring the Nodes
    • Creating a Ballast File
    • Initializing the Cluster
    • Creating the First User
    • Installing a Load Balancer (On-Premises)
    • Cloud Load Balancers
    • Configuring Regions and Zones
  • Deploying on Kubernetes
    • Initializing the Operator
    • Initializing the Cluster
    • Creating a Client Pod
    • Load Balancing
    • Other Kubernetes Tasks
  • Summary
• 11. Multiregion Deployment
  • Multiregion Concepts
    • Regions and Zones
    • Survival Goals
    • Locality Rules
    • Planning Your Multiregion Deployment
  • Deploying in Multiregion
    • Converting to a Multiregion Database
    • Configuring Regional by Row
    • Setting Regional Survival Goal
    • Super Regions
  • Summary
• 12. Backup and Disaster Recovery
  • Backups
    • The BACKUP Command
    • Backup Destinations
    • Full Backup
    • Table- and Database-Level Backups
    • Incremental Backups
    • AS OF SYSTEM TIME Backup
    • Encrypted Backups
    • WITH REVISION HISTORY
    • SHOW BACKUP
    • Managing Backup Jobs
    • Scheduling Backups
    • Locality-Aware Backups
  • Restoring Data
  • Backup Validation
  • Exporting Data
  • Disaster Recovery Best Practices
    • Backup Scheduling and Configuration
    • Recovering from Human Errors
  • TwoData Center Replication
    • Physical Cluster Replication
    • Logical Data Replication
  • Summary
• 13. Security
  • Firewall Configuration
    • IP Allowlist with CockroachDB Cloud
    • Egress Perimeter Controls
    • Private Connectivity and VPC Peering
      • AWS PrivateLink
      • GCP Private Service Connect
    • Native Linux Firewall
    • Configuring a Firewall in GCP
    • Configuring a Firewall in AWS
    • Configuring Ports for Microsoft Azure
  • Encryption and Server Certificates
  • Encryption at Rest
    • Customer-Managed Encryption Keys
  • Authentication Mechanisms
    • Standard Authentication
    • Advanced Authentication
  • Authorization
    • Managing Users
    • Managing Privileges
    • Fine-Grained Access Control with Views
  • Logging and Auditing
  • Security Best Practices
  • Summary
• 14. Administration and Troubleshooting
  • Monitoring
    • CockroachDB Cloud Advanced Alerts
    • CockroachDB Cloud Standard Alerts
    • CockroachDB Cloud Basic Alerts
    • Availability Monitoring
    • The Cloud API
    • The Cluster API
    • Monitoring and Alerting with Prometheus
    • The Metrics Export Endpoint
    • Monitoring and Alerting with Datadog
  • Log Configuration
    • Log Channels
    • Log Format
    • Filter Levels
    • Log Destinations
    • Logging to Fluentd
    • Redaction
    • Logs in Cloud Deployments
  • Cluster Management
    • Upgrading the Cluster Version
    • Adding Nodes to a Cluster
    • Decommissioning Nodes
  • Troubleshooting
    • Clock Synchronization Errors
    • Node Liveness
    • Networking Issues
    • Loss of Client Connectivity
    • Running Out of Disk Space
    • Working with CockroachDB Support Resources
  • Summary
• 15. Cluster Optimization
  • Tuning Versus Firefighting
  • Workload Optimization
    • Detecting Problem Workloads
    • Review of Workload Optimization Strategies
    • Indexing
    • Ad Hoc or Analytic Queries
  • Cluster Balance
    • Causes of Imbalance
      • Hot ranges
      • Load balancing
      • Changes in cluster topology
    • Admission Control
  • Network
  • Memory Optimization
  • Key-Value Cache
    • max-sql-memory
    • Host Memory
  • Disk I/O
  • Scaling Out
  • Summary
• Index

pokaż cały spis treści

ukryj recenzje