Puppet Class: pgpool::config::loadbalance

Defined in:
manifests/config/loadbalance.pp

Overview

Class: pgpool::config::loadbalance

This class allows for the configuration of the loadbalancer options within the pgpool.conf file.

Parameters

load_balance_mode

String. Should SELECT queries will be distributed to each backend for load balancing. Defaults to off.

ignore_leading_white_space

String. Ignore leading spaces at the start of the query in load balancer mode. Defaults to on.

white_function_list

String. Comma seperate list of function names that do NOT update the DB. Defaults to ''.

black_function_list

String. Comma seperate list of function names that update the DB. Defaults to ''.

Variables

N/A

Examples

class { ‘pgpool::config::loadbalance’:

load_balance_mode => 'on',

}

Authors

Alex Schultz <aschultz@next-development.com>

Parameters:

  • load_balance_mode (Any) (defaults to: 'off')
  • ignore_leading_white_space (Any) (defaults to: 'on')
  • white_function_list (Any) (defaults to: '')
  • black_function_list (Any) (defaults to: 'currval,lastval,nextval,setval') 


40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
 
# File 'manifests/config/loadbalance.pp', line 40

class pgpool::config::loadbalance (
  $load_balance_mode          = 'off',
  $ignore_leading_white_space = 'on',
  $white_function_list        = '',
  $black_function_list        = 'currval,lastval,nextval,setval'

) {

  $loadbalance_config = {
    'load_balance_mode'          => { value => $load_balance_mode },
    'ignore_leading_white_space' => { value => $ignore_leading_white_space },
    'white_function_list'        => { value => $white_function_list },
    'black_function_list'        => { value => $black_function_list },
  }

  $loadbalance_defaults = {
    ensure => present
  }

  create_resources(pgpool::config::val, $loadbalance_config, $loadbalance_defaults)
}