دانلود کتاب Practical CockroachDB: Building Fault-Tolerant Distributed SQL Databases

فهرست مطالب :

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