PostgreSQL Replication, 2/e (Paperback)

Hans-Jurgen Schonig

  • 出版商: Packt Publishing
  • 出版日期: 2015-07-31
  • 售價: $1,940
  • 貴賓價: 9.5$1,843
  • 語言: 英文
  • 頁數: 291
  • 裝訂: Paperback
  • ISBN: 1783550600
  • ISBN-13: 9781783550609
  • 相關分類: PostgreSQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast

About This Book

  • Efficiently replicate PostgreSQL using high-end techniques to protect your data and run your server without interruptions
  • Improve reliability, fault-tolerance, and accessibility by maintaining consistency between redundant resources
  • Get grips with the latest version of PostgreSQL with this example-based guide

Who This Book Is For

This book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.

What You Will Learn

  • Use Point-in-time Recovery to perform data recovery as well as replication
  • Set up synchronous as well as asynchronous streaming replication
  • Get familiarized with the transaction log, the core component of most replication setups and its purpose
  • Improve speed and reliability with an understanding of pgpool and PgBouncer
  • Increase your data security and geographically distribute data
  • Make your systems more available and secure with Linux High Availability
  • Scale out with PL/Proxy and Postgres-XC
  • Detect, investigate, and solve replication-related problems

In Detail

PostgreSQL offers a comprehensive set of replication related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems.

This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups.

Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy.

Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL.

商品描述(中文翻譯)

利用PostgreSQL複寫的強大功能,使您的資料庫更加強健、安全、可擴展和快速。

關於本書
- 使用高端技術有效地複寫PostgreSQL,以保護您的資料並使伺服器無間斷運行。
- 通過維持冗余資源之間的一致性,提高可靠性、容錯能力和可訪問性。
- 通過這本以實例為基礎的指南,瞭解最新版本的PostgreSQL。

本書適合對設置和理解複寫的PostgreSQL管理員。通過本書,您將能夠通過瞭解PostgreSQL複寫,使您的資料庫更加強健和安全。

您將學到什麼
- 使用時間點恢復進行資料恢復和複寫。
- 設置同步和非同步流式複寫。
- 熟悉事務日誌,大多數複寫設置的核心組件及其用途。
- 通過瞭解pgpool和PgBouncer,提高速度和可靠性。
- 通過地理分佈資料,提高資料安全性。
- 使用Linux高可用性,使系統更加可用和安全。
- 使用PL/Proxy和Postgres-XC進行擴展。
- 檢測、調查和解決與複寫相關的問題。

詳細內容
PostgreSQL提供了一套全面的複寫相關功能。發揮PostgreSQL的威力,為您提供無數機會,並在其他資料庫系統上獲得競爭優勢。

本書將引導您了解PostgreSQL複寫的最重要概念。它包含了設計和操作複寫設置所需的所有資訊。

從理解複寫概念、PostgreSQL事務日誌和時間點恢復開始,我們逐漸轉向設置非同步和同步複寫。接下來,您將學習監控PostgreSQL集群設置,處理監控工具,然後瞭解Linux高可用性。此外,我們還探索了廣泛使用的工具,如Slony、SkyTools、Postgres-XC和walbouncer,並設置了PL/Proxy。

最後,您將熟悉BDR的新技術,該技術允許在PostgreSQL中進行雙向複寫。