PostgreSQL 12 High Availability Cookbook 3rd Edition
暫譯: PostgreSQL 12 高可用性食譜第三版

Name: PostgreSQL 12 High Availability Cookbook 3rd Edition
Price: 1577 TWD
Availability: InStock
Author: Thomas, Shaun
ISBN: 1838984852

Thomas, Shaun

出版商: Packt Publishing
出版日期: 2020-02-24
售價: $1,660
貴賓價: 9.5 折 $1,577
語言: 英文
頁數: 734
裝訂: Quality Paper - also called trade paper
ISBN: 1838984852
ISBN-13: 9781838984854
相關分類: PostgreSQL、SQL

立即出貨 (庫存=1)

買這商品的人也買了...

~~$450~~ $356

演算法圖鑑：26種演算法 + 7種資料結構，人工智慧、數據分析、邏輯思考的原理和應用 step by step 全圖解
~~$520~~ $406

區塊鏈生存指南：帶你用 Python 寫出區塊鏈！（iT邦幫忙鐵人賽系列書）
$1,168

Rust Web Programming: A hands-on guide to developing fast and secure web apps with the Rust programming language
~~$1,200~~ $948

NoSQL 開發完美方案：Redis + Docker 高性能虛擬化實戰
~~$580~~ $493

網站最佳化實務｜運用機器學習改善網站，提升使用者體驗
~~$520~~ $411

精通資料分析｜使用 Excel、Python 和 R (Advancing Into Analytics: From Excel to Python and R)

商品描述

Databases are nothing without the data they store. In the event of an outage or technical catastrophe, immediate recovery is essential. This updated edition ensures that you will learn the important concepts related to node architecture design, as well as techniques such as using repmgr for failover automation. From cluster layout and hardware selection to software stacks and horizontal scalability, this PostgreSQL cookbook will help you build a PostgreSQL cluster that will survive crashes, resist data corruption, and grow smoothly with customer demand.

You’ll start by understanding how to plan a PostgreSQL database architecture that is resistant to outages and scalable, as it is the scaffolding on which everything rests. With the bedrock established, you'll cover the topics that PostgreSQL database administrators need to know to manage a highly available cluster. This includes configuration, troubleshooting, monitoring and alerting, backups through proxies, failover automation, and other considerations that are essential for a healthy PostgreSQL cluster. Later, you’ll learn to use multi-master replication to maximize server availability. Later chapters will guide you through managing major version upgrades without downtime.

By the end of this book, you’ll have learned how to build an efficient and adaptive PostgreSQL 12 database cluster.

商品描述(中文翻譯)

資料庫沒有儲存的數據就毫無意義。在發生故障或技術災難時，立即恢復至關重要。本書的更新版確保您將學習與節點架構設計相關的重要概念，以及使用 repmgr 進行故障轉移自動化等技術。從叢集佈局和硬體選擇到軟體堆疊和橫向擴展，本 PostgreSQL 食譜將幫助您建立一個能夠抵抗崩潰、抵禦數據損壞並隨著客戶需求平穩增長的 PostgreSQL 叢集。

您將首先了解如何規劃一個能抵抗故障且可擴展的 PostgreSQL 數據庫架構，因為這是所有事物的基礎。在基礎建立後，您將涵蓋 PostgreSQL 數據庫管理員需要了解的主題，以管理一個高可用性的叢集。這包括配置、故障排除、監控和警報、通過代理進行備份、故障轉移自動化以及其他對健康的 PostgreSQL 叢集至關重要的考量。稍後，您將學習使用多主複製來最大化伺服器的可用性。後面的章節將指導您如何在不造成停機的情況下管理主要版本升級。

在本書結束時，您將學會如何建立一個高效且具適應性的 PostgreSQL 12 數據庫叢集。

作者簡介

Shaun Thomas

Shaun Thomas has been experimenting with PostgreSQL since late 2000 and serves as a database consultant, teacher, blogger, and support engineer with 2ndQuadrant. He has presented at conferences such as Postgres Open, 2Q PGCONF, and PgConf on topics such as handling extreme throughput, high availability, failover techniques, monitoring tools, database architecture, multi-master conflict avoidance, and high availability upgrade concepts. He believes in a multi-disciplinary approach when it comes to high availability. He believes that PostgreSQL has a stupendous future ahead, and he can't wait to see the advancements subsequent versions will bring.

作者簡介(中文翻譯)

肖恩·托馬斯 (Shaun Thomas)

肖恩·托馬斯自2000年底以來一直在實驗PostgreSQL，並擔任2ndQuadrant的資料庫顧問、教師、部落客和支援工程師。他曾在Postgres Open、2Q PGCONF和PgConf等會議上發表演講，主題包括處理極端吞吐量、高可用性、故障轉移技術、監控工具、資料庫架構、多主機衝突避免以及高可用性升級概念。他相信在高可用性方面採取多學科的方法是非常重要的。他認為PostgreSQL擁有驚人的未來，並迫不及待想要看到後續版本將帶來的進步。