From: Tom Hughes <tom@compton.nu>
Date: Mon, 13 Feb 2017 14:16:09 +0000 (+0000)
Subject: Configure mysql for the "barracuda" file format for civicrm
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/938bd0ba7ccc932a35b0987d95a48b01ed2e7180?ds=sidebyside

Configure mysql for the "barracuda" file format for civicrm
---

diff --git a/cookbooks/mysql/templates/default/my.cnf.erb b/cookbooks/mysql/templates/default/my.cnf.erb
index 7e445fa92..65740ec67 100644
--- a/cookbooks/mysql/templates/default/my.cnf.erb
+++ b/cookbooks/mysql/templates/default/my.cnf.erb
@@ -3,6 +3,10 @@
 
 [<%= section %>]
 <% settings.each do |name, value| -%>
+<% if value.is_a?(TrueClass) -%>
+<%= name %>
+<% else -%>
 <%= name %> = <%= value %>
 <% end -%>
 <% end -%>
+<% end -%>
diff --git a/roles/crm.rb b/roles/crm.rb
index 44b521cba..28f20e14a 100644
--- a/roles/crm.rb
+++ b/roles/crm.rb
@@ -23,6 +23,15 @@ default_attributes(
       }
     },
     :trusted_users => ["www-data"]
+  },
+  :mysql => {
+    :settings => {
+      :mysqld => {
+        :innodb_strict_mode => true,
+        :innodb_file_per_table => true,
+        :innodb_file_format => "Barracuda"
+      }
+    }
   }
 )