changeset 168:b13e0de66b54 puppet-3.6

Change MySQL/MariaDB settings to support all Unicode
author IBBoard <dev@ibboard.co.uk>
date Fri, 01 Sep 2017 11:29:55 +0100
parents d9c434339b2f
children 4efaba4fbe94
files modules/website/manifests/mysql.pp
diffstat 1 files changed, 4 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/modules/website/manifests/mysql.pp	Tue Aug 01 19:09:38 2017 +0100
+++ b/modules/website/manifests/mysql.pp	Fri Sep 01 11:29:55 2017 +0100
@@ -24,6 +24,10 @@
         'max_heap_table_size' => '64M',
         'table_open_cache' => '64',
         'log-queries-not-using-indexes' => '1',
+        # Settings for best MySQL 4-byte Unicode support
+        'innodb_large_prefix' => 'true',
+        'innodb_file_format' => 'barracuda',
+        'innodb_file_per_table' => '1',
       }
     },
   }