舉報 
會員
PostgreSQL 9 High Availability Cookbook
最新章節：
Index
Acomprehensiveseriesofdependablerecipestodesign,build,andimplementaPostgreSQLserverarchitecturefreeofcommonpitfallsthatcanoperateforyearstocome.Eachchapterispackedwithinstructionsandexamplestosimplifyevenhighlycomplexdatabaseoperations.IfyouareaPostgreSQLDBAworkingonLinuxsystemswhowantadatabasethatnevergivesup,thisbookisforyou.Ifyou'veeverexperiencedadatabaseoutage,restoredfromabackup,spenthourstryingtorepairamalfunctioningcluster,orsimplywanttoguaranteesystemstability,thisbookisdefinitelyforyou.
最新章節
- Index
- Moving a shard to another server
- Talking to the right shard
- Building a sharding API
- Creating a scalable nextval replacement
- Transforming foreign tables into local tables
品牌：中圖公司
上架時間：2021-12-08 12:26:16
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-12-08 12:32:35
- Moving a shard to another server
- Talking to the right shard
- Building a sharding API
- Creating a scalable nextval replacement
- Transforming foreign tables into local tables
- Optimizing foreign table access
- Using a foreign table in a query
- Creating a foreign table
- Mapping a remote user
- Setting up a foreign PostgreSQL server
- Identifying horizontal candidates
- Introduction
- Chapter 10. Data Distribution
- Using an outage to test migration
- Performing a managed resource migration
- Combining and ordering related actions
- Grouping associated resources
- Adding an e-mail alert
- Adding a virtual IP to hide the cluster
- Adding PostgreSQL to cluster management
- Adding XFS to cluster management
- Adding LVM to cluster management
- Adding DRBD to cluster management
- Starting with base options
- Preparing startup services
- Configuring Corosync
- Installing the components
- Introduction
- Chapter 9. Cluster Control
- Detaching a problematic node
- Switching live stack systems
- Using LVM snapshots
- Maintaining an XFS filesystem
- Tweaking XFS performance
- Formatting an XFS filesystem
- Correcting a DRBD split brain
- Verifying a DRBD filesystem
- Incorporating the second LVM layer
- Adding block-level replication
- Getting started with the Linux Volume Manager
- Preparing systems for the stack
- Introduction
- Chapter 8. Advanced Stack
- Managing WAL files with walctl
- Cloning a database with walctl
- Installing and configuring walctl
- Swapping active nodes with repmgr
- Cloning a database with repmgr
- Installing and configuring repmgr
- Managing WAL files with OmniPITR
- Installing and configuring OmniPITR
- Restoring a database with Barman
- Backing up a database with Barman
- Installing and configuring Barman
- Deciding when to use third-party tools
- Introduction
- Chapter 7. Replication Management Tools
- Copying a few tables with Londiste
- Setting up Londiste
- Copying a few tables with Bucardo
- Setting up Bucardo
- Copying a few tables with Slony
- Setting up Slony
- Faking replication with pg_receivexlog
- Bulletproofing with synchronous replication
- Upgrading to asynchronous replication
- Setting up a hot standby
- Securing the WAL stream
- Deciding what to copy
- Introduction
- Chapter 6. Replication
- Creating a Graphite dashboard
- Customizing a Graphite graph
- Building a graph in Graphite
- Adding collectd data to Graphite
- Installing and configuring Graphite
- Adding a custom PostgreSQL monitor to collectd
- Installing and configuring collectd
- Getting to know check_postgres
- Enhancing Nagios with check_mk
- Configuring Nagios to monitor a database host
- Installing and configuring Nagios
- Figuring out what to monitor
- Introduction
- Chapter 5. Monitoring
- Logging checkpoints properly
- Debugging with strace
- Checking the pg_stat_statements view
- Checking the pg_stat_activity view
- Examining /proc/net/bonding/bond0
- Interpreting /proc/meminfo
- Correlating performance with dstat
- Viewing past performance with sar
- Tracking I/O-heavy processes with iotop
- Evaluating the current disk performance with iostat
- Installing common statistics packages
- Performing triage
- Introduction
- Chapter 4. Troubleshooting
- Combining the power of PgBouncer and pgpool
- Swapping active nodes with pgpool
- Testing a write query on pgpool
- Configuring pgpool for master/slave mode
- Installing pgpool
- Evaluating PgBouncer pool health
- Listing PgBouncer client connections
- Listing PgBouncer server connections
- Connecting to PgBouncer
- Configuring PgBouncer safely
- Installing PgBouncer
- Determining connection costs and limits
- Introduction
- Chapter 3. Pooling Resources
- Applying bonus kernel tweaks
- Mitigating the impact of hardware failure
- Managing software upgrades
- Managing system migrations
- Reducing contention with concurrent indexes
- Terminating rogue connections
- Exploring the magic of virtual IPs
- Defusing cache poisoning
- Identifying important tables
- Configuration – managing scary settings
- Configuration – getting it right the first time
- Determining acceptable losses
- Introduction
- Chapter 2. Handling and Avoiding Downtime
- Protecting your eggs
- Tallying up
- Saddling up to a SAN
- Selecting a chassis
- Managing motherboards
- Exploring nimble networking
- Making the most of memory
- Picking a processor
- Investing in a RAID
- Sizing storage
- Having enough IOPS
- Planning for redundancy
- Introduction
- Chapter 1. Hardware Planning
- Customer support
- Reader feedback
- Conventions
- Sections
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- About the Author
- Credits
- 版權頁
- 封面
- 封面
- 版權頁
- 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
