description "Master role applied to yevaud"
default_attributes(
+ :apt => {
+ :sources => ["postgresql"]
+ },
:devices => {
:osdisktune1 => {
:comment => "Tune os disk",
},
:load => {
:load => {
- :warning => 250,
- :critical => 300
+ :warning => 400,
+ :critical => 500
}
}
}
}
},
:postgresql => {
- :versions => ["9.1"],
+ :versions => ["9.5"],
:settings => {
:defaults => {
- :shared_buffers => "3GB",
+ :shared_buffers => "8GB",
:maintenance_work_mem => "7144MB",
- :effective_cache_size => "8GB"
+ :effective_cache_size => "16GB"
}
}
},
:postgres => {
:comment => "Increase shared memory for postgres",
:parameters => {
- "kernel.shmmax" => 4 * 1024 * 1024 * 1024,
- "kernel.shmall" => 4 * 1024 * 1024 * 1024 / 4096
- }
- },
- :cpu_tune => {
- :comment => "Tune kern sched migration cost",
- :parameters => {
- "kernel.sched_autogroup_enabled" => 0,
- "kernel.sched_migration_cost_ns" => 25000000
+ "kernel.shmmax" => 9 * 1024 * 1024 * 1024,
+ "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096
}
}
},
:tile => {
+ :database => {
+ :cluster => "9.5/main"
+ },
:node_file => "/store/database/nodes",
:styles => {
:default => {