--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dev/provisioning/modules/sysconfig/manifests/mariadb.pp	Fri Jan 15 15:35:00 2016 +0100
@@ -0,0 +1,93 @@
+class sysconfig::mariadb (
+    $db_name      = hiera('sysconfig::params::db_name',      sysconfig::params::db_name),
+    $db_drpl_name = hiera('sysconfig::params::db_drpl_name', $sysconfig::params::db_drpl_name),
+    $db_user      = hiera('sysconfig::params::db_user',      $sysconfig::params::db_user),
+    $db_pw        = hiera('sysconfig::params::db_pw',        $sysconfig::params::db_pw),
+    $db_host      = hiera('sysconfig::params::db_host',      $sysconfig::params::db_host),
+    $db_port      = hiera('sysconfig::params::db_port',      $sysconfig::params::db_port),
+) inherits sysconfig::params {
+
+    $mariadb_packages = [
+        'mariadb-server'
+    ]
+
+    package { $mariadb_packages:
+        ensure => present,
+        notify  => Service["mariadb"]
+    }
+
+    service { "mariadb":
+        ensure => running,
+        enable => true
+    }
+
+    augeas { "mariadb_server_cnf/max_allowed_packet":
+        lens    => "MySQL.lns",
+        incl    => "/etc/my.cnf.d/server.cnf",
+        changes => "set target[.='mysqld']/max_allowed_packet 16M",
+        notify  => Service["mariadb"],
+        require => Package["mariadb-server"]
+    }
+
+    augeas { "mariadb_server_cnf/collation-server":
+        lens    => "MySQL.lns",
+        incl    => "/etc/my.cnf.d/server.cnf",
+        changes => "set target[.='mysqld']/collation-server utf8mb4_general_ci",
+        notify  => Service["mariadb"],
+        require => Package["mariadb-server"]
+    }
+
+    augeas { "mariadb_server_cnf/character-set-server":
+        lens    => "MySQL.lns",
+        incl    => "/etc/my.cnf.d/server.cnf",
+        changes => "set target[.='mysqld']/character-set-server utf8mb4",
+        notify  => Service["mariadb"],
+        require => Package["mariadb-server"]
+    }
+
+    augeas { "mariadb_client_cnf/default-character-set":
+        lens    => "MySQL.lns",
+        incl    => "/etc/my.cnf.d/client.cnf",
+        changes => "set target[.='client']/default-character-set utf8mb4",
+        notify  => Service["mariadb"],
+        require => Package["mariadb-server"]
+    }
+
+    augeas { "mariadb_mysql-client_cnf/default-character-set":
+        lens    => "MySQL.lns",
+        incl    => "/etc/my.cnf.d/mysql-clients.cnf",
+        changes => "set target[.='mysql']/default-character-set utf8mb4",
+        notify  => Service["mariadb"],
+        require => Package["mariadb-server"]
+    }
+
+    mysql::db { "drupal_db":
+        dbname => $db_drpl_name,
+        user => $db_user,
+        password => $db_pw,
+        host => $db_host,
+        charset => 'utf8mb4',
+        collate => 'utf8mb4_general_ci',
+        require => Service["mariadb"],
+    }
+    mysql::db { "corpus_db":
+        dbname => $db_name,
+        user => $db_user,
+        password => $db_pw,
+        host => $db_host,
+        charset => 'utf8mb4',
+        collate => 'utf8mb4_general_ci',
+        require => Service["mariadb"],
+    }
+
+    #TODO: create user
+
+    #TODO: create databases
+
+    # max_allowed_packet : > 16M ->
+    # [mysqld]
+    # collation-server     = utf8mb4_general_ci
+    # character-set-server = utf8mb4
+
+
+}