舉報 
會員
PostgreSQL 9 High Availability Cookbook
最新章節：
Index
Acomprehensiveseriesofdependablerecipestodesign,build,andimplementaPostgreSQLserverarchitecturefreeofcommonpitfallsthatcanoperateforyearstocome.Eachchapterispackedwithinstructionsandexamplestosimplifyevenhighlycomplexdatabaseoperations.IfyouareaPostgreSQLDBAworkingonLinuxsystemswhowantadatabasethatnevergivesup,thisbookisforyou.Ifyou'veeverexperiencedadatabaseoutage,restoredfromabackup,spenthourstryingtorepairamalfunctioningcluster,orsimplywanttoguaranteesystemstability,thisbookisdefinitelyforyou.
目錄(157章)
倒序
- 封面
- 版權頁
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Sections
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Hardware Planning
- Introduction
- Planning for redundancy
- Having enough IOPS
- Sizing storage
- Investing in a RAID
- Picking a processor
- Making the most of memory
- Exploring nimble networking
- Managing motherboards
- Selecting a chassis
- Saddling up to a SAN
- Tallying up
- Protecting your eggs
- Chapter 2. Handling and Avoiding Downtime
- Introduction
- Determining acceptable losses
- Configuration – getting it right the first time
- Configuration – managing scary settings
- Identifying important tables
- Defusing cache poisoning
- Exploring the magic of virtual IPs
- Terminating rogue connections
- Reducing contention with concurrent indexes
- Managing system migrations
- Managing software upgrades
- Mitigating the impact of hardware failure
- Applying bonus kernel tweaks
- Chapter 3. Pooling Resources
- Introduction
- Determining connection costs and limits
- Installing PgBouncer
- Configuring PgBouncer safely
- Connecting to PgBouncer
- Listing PgBouncer server connections
- Listing PgBouncer client connections
- Evaluating PgBouncer pool health
- Installing pgpool
- Configuring pgpool for master/slave mode
- Testing a write query on pgpool
- Swapping active nodes with pgpool
- Combining the power of PgBouncer and pgpool
- Chapter 4. Troubleshooting
- Introduction
- Performing triage
- Installing common statistics packages
- Evaluating the current disk performance with iostat
- Tracking I/O-heavy processes with iotop
- Viewing past performance with sar
- Correlating performance with dstat
- Interpreting /proc/meminfo
- Examining /proc/net/bonding/bond0
- Checking the pg_stat_activity view
- Checking the pg_stat_statements view
- Debugging with strace
- Logging checkpoints properly
- Chapter 5. Monitoring
- Introduction
- Figuring out what to monitor
- Installing and configuring Nagios
- Configuring Nagios to monitor a database host
- Enhancing Nagios with check_mk
- Getting to know check_postgres
- Installing and configuring collectd
- Adding a custom PostgreSQL monitor to collectd
- Installing and configuring Graphite
- Adding collectd data to Graphite
- Building a graph in Graphite
- Customizing a Graphite graph
- Creating a Graphite dashboard
- Chapter 6. Replication
- Introduction
- Deciding what to copy
- Securing the WAL stream
- Setting up a hot standby
- Upgrading to asynchronous replication
- Bulletproofing with synchronous replication
- Faking replication with pg_receivexlog
- Setting up Slony
- Copying a few tables with Slony
- Setting up Bucardo
- Copying a few tables with Bucardo
- Setting up Londiste
- Copying a few tables with Londiste
- Chapter 7. Replication Management Tools
- Introduction
- Deciding when to use third-party tools
- Installing and configuring Barman
- Backing up a database with Barman
- Restoring a database with Barman
- Installing and configuring OmniPITR
- Managing WAL files with OmniPITR
- Installing and configuring repmgr
- Cloning a database with repmgr
- Swapping active nodes with repmgr
- Installing and configuring walctl
- Cloning a database with walctl
- Managing WAL files with walctl
- Chapter 8. Advanced Stack
- Introduction
- Preparing systems for the stack
- Getting started with the Linux Volume Manager
- Adding block-level replication
- Incorporating the second LVM layer
- Verifying a DRBD filesystem
- Correcting a DRBD split brain
- Formatting an XFS filesystem
- Tweaking XFS performance
- Maintaining an XFS filesystem
- Using LVM snapshots
- Switching live stack systems
- Detaching a problematic node
- Chapter 9. Cluster Control
- Introduction
- Installing the components
- Configuring Corosync
- Preparing startup services
- Starting with base options
- Adding DRBD to cluster management
- Adding LVM to cluster management
- Adding XFS to cluster management
- Adding PostgreSQL to cluster management
- Adding a virtual IP to hide the cluster
- Adding an e-mail alert
- Grouping associated resources
- Combining and ordering related actions
- Performing a managed resource migration
- Using an outage to test migration
- Chapter 10. Data Distribution
- Introduction
- Identifying horizontal candidates
- Setting up a foreign PostgreSQL server
- Mapping a remote user
- Creating a foreign table
- Using a foreign table in a query
- Optimizing foreign table access
- Transforming foreign tables into local tables
- Creating a scalable nextval replacement
- Building a sharding API
- Talking to the right shard
- Moving a shard to another server
- Index 更新時間：2021-12-08 12:32:35
推薦閱讀
- 程序員面試筆試寶典（第3版）
- OpenDaylight Cookbook
- 控糖控脂健康餐
- Learning RxJava
- Practical Game Design
- Unity 5.x By Example
- Scala謎題
- Learning SciPy for Numerical and Scientific Computing（Second Edition）
- Windows內核編程
- C語言程序設計實驗指導 （第2版）
- Mastering OAuth 2.0
- Spark技術內幕：深入解析Spark內核架構設計與實現原理
- Java 11 and 12：New Features
- 量子計算機編程：從入門到實踐
- Python滲透測試編程技術：方法與實踐（第2版）
- H5頁面設計與制作（全彩慕課版·第2版）
- 川哥教你Spring Boot 2實戰
- Practical Time Series Analysis
- Visual FoxPro數據庫程序設計
- Office VBA開發經典：中級進階卷
- Spring Microservices
- Learning QGIS（Second Edition）
- Java入門經典
- Python深度學習實戰：基于TensorFlow和Keras的聊天機器人以及人臉、物體和語音識別
- Harbor權威指南：容器鏡像、Helm Chart等云原生制品的管理與實踐
- Visual C++從入門到精通（第5版）
- C語言程序設計教程
- Expert Delphi
- Ionic Cookbook
- Beginning C# 7 Hands-On：Advanced Language Features
