nominatim: extend WAL archive delete script to check slave delay

[chef.git] / roles / katla.rb

diff --git a/roles/katla.rb b/roles/katla.rb
index ece28c5224b02a7d96866e22513abee5f3afd3ad..674dd854efcc363d49273afa4212e05aa14a5440 100644 (file)
--- a/roles/katla.rb
+++ b/roles/katla.rb
@@ -2,6 +2,51 @@ name "katla"
 description "Master role applied to katla"
 
 default_attributes(
+  :db => {
+    :cluster => "9.1/main"
+  },
+  :devices => {
+    :store_slow => {
+      :comment => "RAID array mounted on /store/arrays/slow",
+      :type => "block",
+      :bus => "scsi",
+      :serial => "3600605b005a0609019290f178be8de77",
+      :attrs => {
+        "queue/scheduler" => "deadline",
+        "queue/nr_requests" => "975",
+        "queue/rq_affinity" => "2"
+      }
+    },
+    :store_fast => {
+      :comment => "RAID array mounted on /store/arrays/fast",
+      :type => "block",
+      :bus => "scsi",
+      :serial => "3600605b005a0726019d062ae23b426fd",
+      :attrs => {
+        "queue/scheduler" => "deadline",
+        "queue/nr_requests" => "975",
+        "queue/rq_affinity" => "2"
+      }
+    },
+    :store_ssd_1 => {
+      :comment => "First disk of RAID array mounted on /store/arrays/ssd",
+      :type => "block",
+      :bus => "ata",
+      :serial => "INTEL_SSDSC2BA400G3_BTTV3141041E400HGN",
+      :attrs => {
+        "queue/scheduler" => "noop"
+      }
+    },
+    :store_ssd_2 => {
+      :comment => "Second disk of RAID array mounted on /store/arrays/ssd",
+      :type => "block",
+      :bus => "ata",
+      :serial => "INTEL_SSDSC2BA400G3_BTTV3141044Q400HGN",
+      :attrs => {
+        "queue/scheduler" => "noop"
+      }
+    }
+  },
   :networking => {
     :interfaces => {
       :internal_ipv4 => {
@@ -12,9 +57,30 @@ default_attributes(
         :hwaddress => "00:25:90:94:91:00"
       }
     }
+  },
+  :postgresql => {
+    :settings => {
+      :defaults => {
+        :shared_buffers => "64GB",
+        :work_mem => "64MB",
+        :maintenance_work_mem => "1GB",
+        :effective_cache_size => "180GB"
+      }
+    }
+  },
+  :sysctl => {
+    :postgres => {
+      :comment => "Increase shared memory for postgres",
+      :parameters => {
+        "kernel.shmmax" => 66 * 1024 * 1024 * 1024,
+        "kernel.shmall" => 66 * 1024 * 1024 * 1024 / 4096
+      }
+    }
   }
-);
+)
 
 run_list(
-  "role[ic]"
+  "role[ic]",
+  "role[db-master]",
+  "role[db-backup]"
 )