Practical CockroachDB building fault-tolerant distributed SQL databases
Get a practical introduction to CockroachDB. This book starts with installation and foundational concepts and takes you through to creating clusters that are ready for production environments. You will learn how to create, optimize, and operate CockroarchDB clusters in single and multi-region enviro...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York, New York :
Apress Media LLC
[2022]
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009686300806719 |
Tabla de Contenidos:
- Intro
- Table of Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: The Reason for CockroachDB
- What Is CockroachDB?
- CockroachDB's Architecture
- What Does CockroachDB Solve?
- Who Is CockroachDB For?
- Chapter 2: Installing CockroachDB
- Licensing
- Free
- Paid For
- CockroachDB Core
- Local Installation
- Binary Install
- Docker Install
- Kubernetes Install
- 1_pod-disruption-budget.yaml
- 2_stateful-set.yaml
- 3_private-service.yaml
- 4_public-service.yaml
- 5_init.yaml
- Multinode Clusters
- Multiregion Clusters
- Multiregion Deployment
- Zone Failure Goal
- Regional Failure Goal
- The demo Command
- CockroachDB Serverless/Dedicated
- Creating a Cluster
- Connecting to Your Cluster
- Summary
- Chapter 3: Concepts
- Database Objects
- Data Types
- UUID
- ARRAY
- BIT
- BOOL
- BYTES
- DATE
- ENUM
- DECIMAL
- FLOAT
- INET
- INTERVAL
- JSONB
- SERIAL
- STRING
- TIME/TIMETZ
- TIMESTAMP/TIMESTAMPTZ
- GEOMETRY
- Functions
- Geo-partitioned Data
- REGION BY ROW
- REGION BY TABLE
- Chapter 4: Managing CockroachDB from the Command Line
- The Cockroach Binary
- The start and start-single-node Commands
- The demo Command
- The cert Command
- The sql Command
- The node Command
- The import Command
- The sqlfmt Command
- The workload Command
- Chapter 5: Interacting with CockroachDB
- Connecting to CockroachDB
- Connecting with Tools
- Connecting Programmatically
- Go Example
- Python Example
- Ruby Example
- Crystal Example
- C# Example
- Designing Databases
- Database Design
- Schema Design
- Table Design
- Naming
- Column Data Types
- Indexes
- View Design
- Simplify Queries
- Restrict Table Data
- Moving Data
- Exporting and Importing Data
- Watching for Database Changes
- Kafka Sink
- Webhook Sink.
- Chapter 6: Data Privacy
- Global Regulations
- Location-Specific Considerations
- UK Company with UK and European Customers
- European Company with European and American Customers
- American Company with American Customers
- American Company with American and European Customers
- A Non-Chinese Company with Chinese Customers
- Personally Identifiable Information
- Encryption
- In Transit
- At Rest
- Database Encryption
- Table Encryption
- Chapter 7: Deployment Topologies
- Single-Region Topologies
- Development
- Basic Production
- Multiregion Topologies
- Regional Tables
- Global Tables
- Follower Reads
- Follow-the-Workload
- Antipatterns
- Summary
- Chapter 8: Testing
- Structural Testing
- Functional Testing
- Black Box Testing
- Create a Simple Application
- Test the Application
- Testing with Application Code
- White Box Testing
- Referential Integrity Checks
- Indexes and Query Plans
- Nonfunctional Testing
- Performance Testing
- Scaling Up Your Test Environment
- Resilience Testing
- Chapter 9: Production
- Best Practices
- SELECT Performance
- INSERT Performance
- UPDATE Performance
- Cluster Maintenance
- Moving a Cluster
- Backing Up and Restoring Data
- Full Backups
- Incremental Backups
- Encrypted Backups
- Locality-Aware Backups
- Scheduled Backups
- Cluster Design
- Cluster Sizing
- Node Sizing
- Monitoring
- Index.
