pgpool
Table of Contents
- Overview
- Module Description - What the module does and why it is useful
- Setup - The basics of getting started with pgpool
- Usage - Configuration options and additional functionality
- Reference - An under-the-hood peek at what the module is doing and how
- Limitations - OS compatibility, etc.
- Development - Guide for contributing to the module.
Overview
This module can be used to manage the installation and configuration of pgpool.
Module Description
The module leverages augeas to manage the configuration file for pgpool. Additionally it allows you to manage the pool hba configuration file via the augeas pg_hba provider. You can also manage the pool_password file with the pool password resource provided by the module. The module does not manage the installation of the pgdg repository for installation of the latest version of pgpool. You can provide the package name to the pgpool module if you have built your own or would like to leverage a version that is shipped with your OS.
Setup
Setup Requirements
As part of using this module, you will need to have the following modules installed.
- camptocamp/augeas
- puppetlabs/stdlib
- herculesteam/augeasproviders_core
- herculesteam/augeasproviders_postgresql
Additionally there is a submode that references an external Augeas lense. If you want to check out this module, make sure to recursively fetch the module to get the augeas-pgpool submodule.
git clone --recursive https://github.com/mwhahaha/puppet-pgpool.git
Usage
Here is a sample configuration for a streaming replica master/slave setup and pgpool on the same node as the application.
# install the package and the service
class { 'pgpool': }
# setup our pgpool.conf
class { 'pgpool::config::connection': }
class { 'pgpool::config::healthcheck':
health_check_period => 5,
health_check_timeout => 10,
health_check_user => 'pgpool',
health_check_password => 'mypassword',
health_check_max_retries => 1,
}
class { 'pgpool::config::loadbalance':
load_balance_mode => 'on',
}
class { 'pgpool::config::logs':
log_connections => 'on',
log_statement => 'on',
log_min_messages => 'info',
}
class { 'pgpool::config::masterslave':
master_slave_mode => 'on',
master_slave_sub_mode => 'stream',
sr_check_period => 5,
sr_check_user => 'pgpool',
sr_check_password => 'mypassword',
delay_threshold => 1024000,
}
class { 'pgpool::config::pools':
enable_pool_hba => 'on',
}
class { 'pgpool::config::replication':
replication_mode => 'off',
}
class { 'pgpool::config::service':
pid_file_name => '/var/run/pgpool-II-93/pgpool-II-93.pid',
logdir => '/tmp',
}
class { 'pgpool::config::ssl': }
class { 'pgpool::config::watchdog': }
# configure our backend systems
pgpool::config::backend { 'db-n01':
id => '0',
hostname => '10.0.0.4',
port => 5432,
application_name => 'db-n01',
data_directory => '/var/lib/pgsql/9.3/data',
}
pgpool::config::backend { 'db-n02':
id => '1',
hostname => '10.0.0.5',
port => 5432,
application_name => 'db-n02',
data_directory => '/var/lib/pgsql/9.3/data',
}
# configure our application user password access
pgpool::pool_passwd { 'my_app_user':
password_hash => 'md5d6d70ecf643d4sec9ca6623fee1233ea',
}
# configure the pgpool hba configuration
pgpool::hba { 'my_app_user':
type => 'host',
database => 'my_db_name',
user => 'my_app_user',
address => '127.0.0.1/32',
auth_method => 'md5',
}
Reference
Here is a list of all the available classes and resources for this module.
Classes:
- pgpool
- pgpool::config
- pgpool::service
- pgpool::package
- pgpool::monitor
- pgpool::config::watchdog
- pgpool::config::pools
- pgpool::config::loadbalance
- pgpool::config::healthcheck
- pgpool::config::other
- pgpool::config::memorycache
- pgpool::config::ssl
- pgpool::config::logs
- pgpool::config::replication
- pgpool::config::masterslave
- pgpool::config::connection
- pgpool::config::heartbeat
- pgpool::config::service
- pgpool::config::failover
Resources:
- pgpool::pool_passwd
- pgpool::pcp
- pgpool::hba
- pgpool::config::backend
- pgpool::config::val
- pgpool::config::wdother
Limitations
This has only been tested on RedHat/CentOS 6. It might work on Debian/Ubuntu.
Development
Pull requests welcome.
Other resources
To use pgpool::monitor, the code for the pgpool-monitor package is available from pgpool-monitor.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent