X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/fba89b0d71a9dd87d0c3c57fb2f84263c3b36a14..3308749a82da1eaeea282a5b51e68fcf824c3655:/roles/db.rb diff --git a/roles/db.rb b/roles/db.rb index bb13e00c5..24ae10683 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -15,45 +15,26 @@ default_attributes( :enable => false } }, - :munin => { - :plugins => { - :postgres_connections_openstreetmap => { - :waiting => { - :warning => 10, - :critical => 20 - } - }, - :postgres_locks_openstreetmap => { - :accesssharelock => { - :warning => 900, - :critical => 1000 - }, - :rowexclusivelock => { - :warning => 250, - :critical => 300 - } - } - } - }, - :nfs => { - "/store/rails" => { :host => "ironbelly", :path => "/store/rails" } - }, :postgresql => { - :versions => ["9.5"], :settings => { :defaults => { :listen_addresses => "*", - :max_connections => "1000", + :max_connections => "1500", :max_stack_depth => "7MB", - :checkpoint_segments => "32", + :wal_level => "logical", :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", :cpu_tuple_cost => "0.1", + :jit => "off", :log_min_duration_statement => "1000", :late_authentication_rules => [ - { :address => "10.0.16.0/20" }, - { :address => "10.0.32.0/20" }, - { :address => "10.0.48.0/20" } + { :address => "10.0.48.0/20" }, # amsterdam + { :address => "10.0.64.0/20" }, # dublin + { :database => "replication", :user => "replication", :address => "10.0.0.4/32" }, # snap-02 + { :database => "replication", :user => "replication", :address => "10.0.0.10/32" }, # eddie + { :database => "replication", :user => "replication", :address => "10.0.48.49/32" }, # snap-01 + { :database => "replication", :user => "replication", :address => "10.0.48.50/32" }, # karm + { :database => "replication", :user => "replication", :address => "10.0.64.50/32" } # snap-03 ] } } @@ -67,7 +48,3 @@ default_attributes( } } ) - -run_list( - "recipe[nfs]" -)