description "Master role applied to yevaud"
default_attributes(
+ :apt => {
+ :sources => ["postgresql"]
+ },
:devices => {
:osdisktune1 => {
:comment => "Tune os disk",
:munin => {
:plugins => {
:cpu => {
- :system => {
+ :system => {
:warning => 500,
:critical => 600
}
},
:load => {
- :load => {
- :warning => 150,
- :critical => 200
+ :load => {
+ :warning => 250,
+ :critical => 300
}
}
}
}
},
:postgresql => {
- :versions => [ "9.1" ],
+ :versions => ["9.4"],
:settings => {
:defaults => {
- :shared_buffers => "3GB",
+ :shared_buffers => "8GB",
:maintenance_work_mem => "7144MB",
- :effective_cache_size => "8GB"
+ :effective_cache_size => "16GB"
}
}
},
:sysctl => {
:postgres => {
:comment => "Increase shared memory for postgres",
- :parameters => {
- "kernel.shmmax" => 4 * 1024 * 1024 * 1024,
- "kernel.shmall" => 4 * 1024 * 1024 * 1024 / 4096
+ :parameters => {
+ "kernel.shmmax" => 9 * 1024 * 1024 * 1024,
+ "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096
}
}
},
:tile => {
+ :database => {
+ :cluster => "9.4/main"
+ },
:node_file => "/store/database/nodes",
:styles => {
:default => {