Reduce random_page_cost for postgres instances on SSD

[chef.git] / roles / foundation.rb

diff --git a/roles/foundation.rb b/roles/foundation.rb
index 4926edeb2e59fbdd990c471fc92f9f5a6613ba30..02b880d5d65a2d3834c34202995de63381965d57 100644 (file)
--- a/roles/foundation.rb
+++ b/roles/foundation.rb
@@ -8,9 +8,10 @@ default_attributes(
     :keepalive => false
   },
   :apt => {
-    :sources => ["passenger"]
+    :sources => ["passenger", "brightbox-ruby-ng"]
   },
   :elasticsearch => {
+    :version => "5.x",
     :cluster => {
       :name => "foundation"
     },
@@ -22,6 +23,19 @@ default_attributes(
     :memory_limit => 400,
     :chunk_growth_factor => 1.05,
     :min_item_size => 5
+  },
+  :mysql => {
+    :settings => {
+      :mysqld => {
+        :innodb_buffer_pool_size => "512M",
+        :key_buffer_size => "64M",
+        :max_connections => "200",
+        :query_cache_size => "48M",
+        :query_cache_type => "1",
+        :sort_buffer_size => "8M",
+        :tmp_table_size => "48M"
+      }
+    }
   }
 )
 
@@ -30,5 +44,6 @@ run_list(
   "role[elasticsearch]",
   "recipe[foundation::wiki]",
   "recipe[foundation::board]",
-  "recipe[foundation::dwg]"
+  "recipe[foundation::dwg]",
+  "recipe[foundation::owg]"
 )