SKU/Artículo: AMZ-B0G12RYMX5
Mastering PostgreSQL Administration & Scaling: Build, Optimize, and Automate Modern Databases for High Performance and Resilience
Format:
Hardcover
Detalles del producto
Disponibilidad:
En stock
En stock
Peso con empaque:
1.36 kg
1.36 kg
Devolución:
Sí
Sí
Condición
Nuevo
Nuevo
Producto de:
Amazon
Amazon
Viaja desde
USA
USA
Sobre este producto
- PostgreSQL has become the backbone of modern data platforms—powering transactional systems, analytics engines, SaaS applications, financial systems, and distributed cloud services. Yet running PostgreSQL in production is no longer about managing a single server. It requires scaling, observability, automation, failover safety, backup integrity, and predictable resilience.This book is a complete, practical, and deeply technical guide to building and operating production-grade PostgreSQL environments—from single-instance administration to fully automated high-availability clusters with self-healing, monitoring, and disaster recovery.Designed for database administrators, DevOps engineers, SREs, platform teams, and backend developers, this book teaches not only how to run PostgreSQL, but how to trust it in real-world operational environments.What You Will Learn Foundations & Core AdministrationPostgreSQL architecture, memory layout, WAL, background processes, and directory structureRole management, access control, authentication, and security hardeningConfiguration tuning, logging, and lifecycle administrationPerformance, Query Optimization & ScalingUnderstanding query planning, indexing strategies, and execution profilingImproving joins, complex queries, and workload performanceTuning memory, storage, I/O, autovacuum, and checkpoint behaviorHigh Availability & Automated FailoverStreaming replication and replication topology designPatroni-based automated failover with Distributed Consensus (DCS)HAProxy load balancing and PgBouncer connection poolingRecovery safety, replica integrity, and split-brain avoidanceInfrastructure-as-Code & AutomationProvisioning repeatable environments with TerraformConfiguration management with Ansible roles and playbooksRolling upgrades, controlled switchover, and zero-downtime migration workflowsMonitoring, Backup & Disaster RecoveryPrometheus + Grafana observability for real-time performance insightpgBackRest backups with full, incremental, WAL archiving, and PITR restore drillsValidating RPO/RTO objectives and failure-mode readinessFull End-to-End Production DeploymentA complete, reproducible, capstone lab guides you through building a self-healing, observed, scaled PostgreSQL HA cluster with:Automated failoverSecure routing layersContinuous backup + PITR readinessLoad testing and failover validation under real workload pressureWho This Book Is ForDatabase Administrators who want to run PostgreSQL with confidenceDevOps & SRE Engineers implementing resilient stateful servicesBackend & Platform Engineers deploying mission-critical data workloadsOrganizations migrating from proprietary databases to PostgreSQLIf your goal is to operate PostgreSQL as a reliable platform—not just a database—this book is for you.No guesswork. No outdated patterns. No theory without implementation.Master PostgreSQL not just to run it — but to trust it. Build systems that are automated, resilient, observable, recoverable, and engineered for the real world.
AR$114.045
44% OFF
AR$63.355
IMPORT EASILY
By purchasing this product you can deduct VAT with your RUT number
AR$114.045
44% OFF
AR$63.355
Pagá fácil y rápido con Mercado Pago o MODO
Llega en 8 a 12 días hábiles
con envío
Tienes garantía de entrega
Este producto viaja
de USA ![]()
a tus manos en
![]()
a tus manos en
Compra protegida
Disfruta de una experiencia de compra segura y confiable
Tarjetas de Crédito y Débito
Visa
Mastercard
American Express
Pagos a través de PayPal
Compra procesada en dólares con dinero en cuenta o tarjetas internacionales.
Paypal
Pagos a través de MODO
Compra procesada en pesos desde la App de tu banco.
PayPal
