首頁 > 計(jì)算機(jī)網(wǎng)絡(luò) >
編程語言與程序設(shè)計(jì)
> PostgreSQL Replication(Second Edition)最新章節(jié)目錄
目錄(118章)
倒序
- 封面
- 版權(quán)信息
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- Chapter 1. Understanding the Concepts of Replication
- The CAP theorem and physical limitations of replication
- Different types of replication
- Using sharding and data distribution
- Summary
- Chapter 2. Understanding the PostgreSQL Transaction Log
- How PostgreSQL writes data
- The XLOG and replication
- Understanding consistency and data loss
- Tuning checkpoints and the XLOG
- Experiencing the XLOG in action
- Making use of replication slots
- Summary
- Chapter 3. Understanding Point-in-time Recovery
- Understanding the purpose of PITR
- Archiving the transaction log
- Taking base backups
- Replaying the transaction log
- Summary
- Chapter 4. Setting Up Asynchronous Replication
- Setting up streaming replication
- Configuring a cascaded replication
- Turning slaves into masters
- Mixing streaming-based and file-based recovery
- Making streaming-only replication more robust
- Efficient cleanup and the end of recovery
- Conflict management
- Dealing with timelines
- Delayed replicas
- Summary
- Chapter 5. Setting Up Synchronous Replication
- Synchronous replication setup
- Understanding the practical implications and performance
- Redundancy and stopping replication
- Summary
- Chapter 6. Monitoring Your Setup
- Checking your archive
- Checking pg_stat_replication
- Checking for operating system processes
- Checking for replication slots
- Dealing with monitoring tools
- Summary
- Chapter 7. Understanding Linux High Availability
- Understanding the purpose of High Availability
- Measuring availability
- Durability and availability
- Detecting failures
- The split-brain syndrome
- Understanding Linux-HA
- Setting up a simple HA cluster
- Common maintenance tasks
- Summary
- Chapter 8. Working with PgBouncer
- Understanding the fundamental PgBouncer concepts
- Installing PgBouncer
- Configuring your first PgBouncer setup
- Improving performance
- Maintaining PgBouncer
- Summary
- Chapter 9. Working with pgpool
- Installing pgpool
- Understanding the features of pgpool
- Understanding the pgpool architecture
- Setting up replication and load balancing
- Checking the replication
- Running pgpool with streaming replication
- Dealing with failovers and High Availability
- Summary
- Chapter 10. Configuring Slony
- Installing Slony
- Understanding how Slony works
- Replicating your first database
- Deploying DDLs
- Adding tables to replication and managing problems
- Performing failovers
- Summary
- Chapter 11. Using SkyTools
- Installing SkyTools
- Dissecting SkyTools
- Managing pgq queues
- Using Londiste to replicate data
- A word about walmgr
- Summary
- Chapter 12. Working with Postgres-XC
- Understanding the Postgres-XC architecture
- Installing Postgres-XC
- Configuring a simple cluster
- Optimizing for performance
- Creating tables and issuing queries
- Adding nodes
- Handling failovers and dropping nodes
- Summary
- Chapter 13. Scaling with PL/Proxy
- Understanding the basic concepts
- Setting up PL/Proxy
- Extending and handling clusters in a clever way
- Summary
- Chapter 14. Scaling with BDR
- Understanding BDR replication concepts
- Installing BDR
- Setting up a simple cluster
- Understanding sets
- Controlling replication
- Summary
- Chapter 15. Working with Walbouncer
- The concepts of walbouncer
- Installing walbouncer
- Using additional configuration options
- Adjusting filtering rules
- Summary
- Index 更新時(shí)間:2021-07-16 13:34:08
推薦閱讀
- JBoss Weld CDI for Java Platform
- 觸·心:DT時(shí)代的大數(shù)據(jù)精準(zhǔn)營銷
- 動(dòng)手玩轉(zhuǎn)Scratch3.0編程:人工智能科創(chuàng)教育指南
- 深入淺出Spring Boot 2.x
- Mastering Natural Language Processing with Python
- Mastering Concurrency in Go
- INSTANT MinGW Starter
- 云原生Spring實(shí)戰(zhàn)
- INSTANT CakePHP Starter
- Backbone.js Blueprints
- Apache Mesos Essentials
- Drupal 8 Module Development
- 自制編程語言
- Visual Basic程序設(shè)計(jì)實(shí)驗(yàn)指導(dǎo)(第二版)
- OpenStack Networking Essentials
- Mastering Apache Storm
- 算法圖解
- Python 快速入門(第3版)
- Solr權(quán)威指南(下卷)
- 深入理解Java虛擬機(jī):JVM高級特性與最佳實(shí)踐
- Android應(yīng)用開發(fā)攻略
- Java Web應(yīng)用開發(fā)
- Mastering MeteorJS Application Development
- HTML 5與CSS 3權(quán)威指南(第4版·下冊)
- 架構(gòu)真意:企業(yè)級應(yīng)用架構(gòu)設(shè)計(jì)方法論與實(shí)踐
- 機(jī)器學(xué)習(xí)入門:Python語言實(shí)現(xiàn)
- 深入理解Kotlin協(xié)程
- 面向?qū)ο笫窃鯓庸ぷ鞯模ǖ?版)
- Python從入門到精通(第2版)
- 軟件設(shè)計(jì)模式(慕課版)