X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/98365f1da1424a74d5e1a562f0885608fadb88e7..a7d96c8358a00088b485fadb5966eb4b231d2ff1:/roles/db.rb

diff --git a/roles/db.rb b/roles/db.rb
new file mode 100644
index 000000000..031865a6c
--- /dev/null
+++ b/roles/db.rb
@@ -0,0 +1,63 @@
+name "db"
+description "Role applied to all database servers"
+
+default_attributes(
+  :accounts => {
+    :users => {
+      :rails => {
+        :status => :role,
+        :members => [ :tomh, :grant ]
+      }
+    }
+  },
+  :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 => "horntail", :path => "/store/rails" }
+  },
+  :postgresql => {
+    :versions => [ "9.1" ],
+    :settings => {
+      :defaults => {
+        :listen_addresses => "*",
+        :max_connections => "500",
+        :max_stack_depth => "7MB",
+        :checkpoint_segments => "32",
+        :checkpoint_completion_target => "0.8",
+        :late_authentication_rules => [
+          { :address => "146.179.159.160/27" }
+        ]
+      }
+    }
+  },
+  :sysctl => {
+    :swappiness => {
+      :comment => "Only swap in an emergency",
+      :parameters => {
+        "vm.swappiness" => 0
+      }
+    }
+  }
+)
+
+run_list(
+  "recipe[nfs]"
+)