X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/2a974b16c9839ef4ed868eb5db456dd6db20e66f..3f0adbf98daf65d842dc28bf372fba289f6c74ec:/roles/yevaud.rb diff --git a/roles/yevaud.rb b/roles/yevaud.rb index 6d33455e4..42a29fc10 100644 --- a/roles/yevaud.rb +++ b/roles/yevaud.rb @@ -2,6 +2,9 @@ name "yevaud" description "Master role applied to yevaud" default_attributes( + :apt => { + :sources => ["postgresql"] + }, :devices => { :osdisktune1 => { :comment => "Tune os disk", @@ -55,8 +58,8 @@ default_attributes( }, :load => { :load => { - :warning => 250, - :critical => 300 + :warning => 400, + :critical => 500 } } } @@ -72,12 +75,12 @@ default_attributes( } }, :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" } } }, @@ -85,19 +88,15 @@ default_attributes( :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 => {