1 files changed, 26 insertions, 0 deletions
diff --git a/manifests/instance.pp b/manifests/instance.pp
new file mode 100644
index 0000000..2523e28
--- /dev/null
+++ b/manifests/instance.pp
@@ -0,0 +1,26 @@
+# Database definitions
+define database::instance(
+  $password,
+  $ensure     = 'present',
+  $privileges = "all"
+) {
+  include mysql::server
+
+  mysql_database { "${name}":
+    ensure  => $ensure,
+    require => Service['mysql'],
+  }
+
+  mysql_user { "${name}@%":
+    ensure        => $ensure,
+    password_hash => mysql_password($password),
+    require       => Mysql_database["${name}"],
+  }
+
+  if $ensure == 'present' {
+    mysql_grant { "${name}@%/${name}":
+      privileges => $privileges,
+      require    => Mysql_user["${name}@%"],
+    }
+  }
+}