# HG changeset patch
# User IBBoard <dev@ibboard.co.uk>
# Date 1504261795 -3600
# Node ID b13e0de66b5496a43f90295726bc31ddce196efa
# Parent  d9c434339b2fe862457294d1693e6148f66c3a19
Change MySQL/MariaDB settings to support all Unicode

diff -r d9c434339b2f -r b13e0de66b54 modules/website/manifests/mysql.pp
--- 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',
       }
     },
   }