首頁 > 計(jì)算機(jī)網(wǎng)絡(luò) >
編程語言與程序設(shè)計(jì)
> PostgreSQL 9 High Availability Cookbook最新章節(jié)目錄
舉報(bào) 
會(huì)員
PostgreSQL 9 High Availability Cookbook
最新章節(jié)：
Index
Acomprehensiveseriesofdependablerecipestodesign,build,andimplementaPostgreSQLserverarchitecturefreeofcommonpitfallsthatcanoperateforyearstocome.Eachchapterispackedwithinstructionsandexamplestosimplifyevenhighlycomplexdatabaseoperations.IfyouareaPostgreSQLDBAworkingonLinuxsystemswhowantadatabasethatnevergivesup,thisbookisforyou.Ifyou'veeverexperiencedadatabaseoutage,restoredfromabackup,spenthourstryingtorepairamalfunctioningcluster,orsimplywanttoguaranteesystemstability,thisbookisdefinitelyforyou.
目錄(157章)
倒序
- 封面
- 版權(quán)頁
- 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 更新時(shí)間：2021-12-08 12:32:35
推薦閱讀
- UI圖標(biāo)創(chuàng)意設(shè)計(jì)
- Python自然語言處理實(shí)戰(zhàn)：核心技術(shù)與算法
- Hands-On Machine Learning with scikit：learn and Scientific Python Toolkits
- The Android Game Developer's Handbook
- JavaScript高效圖形編程
- HTML5+CSS3+JavaScript Web開發(fā)案例教程（在線實(shí)訓(xùn)版）
- HDInsight Essentials（Second Edition）
- Gradle for Android
- C語言程序設(shè)計(jì)
- Java程序員面試筆試寶典（第2版）
- Python+Tableau數(shù)據(jù)可視化之美
- Hands-On Nuxt.js Web Development
- Azure Serverless Computing Cookbook
- Android應(yīng)用開發(fā)深入學(xué)習(xí)實(shí)錄
- Julia數(shù)據(jù)科學(xué)應(yīng)用
- Learning Image Processing with OpenCV
- XML程序設(shè)計(jì)（第二版）
- JavaScript前端開發(fā)基礎(chǔ)教程
- 第五空間戰(zhàn)略：大國間的網(wǎng)絡(luò)博弈
- 虛擬現(xiàn)實(shí)：引領(lǐng)未來的人機(jī)交互革命
- 面向?qū)ο蠓治雠c設(shè)計(jì)（第3版）
- jMonkeyEngine 3.0 Cookbook
- Bootstrap for ASP.NET MVC（Second Edition）
- 自動(dòng)化測(cè)試實(shí)戰(zhàn)寶典：Robot Framework+Python從小工到專家
- 大學(xué)計(jì)算機(jī)基礎(chǔ)教程
- Java程序設(shè)計(jì)
- Cocos2d-x Cookbook
- 鮮活的數(shù)據(jù)：數(shù)據(jù)可視化指南
- Python科學(xué)計(jì)算入門與實(shí)戰(zhàn)：視頻教學(xué)版
- Web Development with MongoDB and NodeJS（Second Edition）
