From 938bd0ba7ccc932a35b0987d95a48b01ed2e7180 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Mon, 13 Feb 2017 14:16:09 +0000 Subject: [PATCH] Configure mysql for the "barracuda" file format for civicrm --- cookbooks/mysql/templates/default/my.cnf.erb | 4 ++++ roles/crm.rb | 9 +++++++++ 2 files changed, 13 insertions(+) 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" + } + } } ) -- 2.43.2