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 7e445fa926140b0757696939a3f0f358319e5b77..65740ec674582de8ccc02374602149f03532ec32 100644 (file)
--- 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 44b521cbacc2296c9780eeec7bb1c52345ec7732..28f20e14a3106d283bd24b471f35e45a4ae20b5e 100644 (file)
--- 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"
+      }
+    }
   }
 )