diff modules/mysql/README.md @ 443:c6c9a2cfcfbd

Update MySQL module Fixes a problem with MariaDB and blank certificate paths
author IBBoard <dev@ibboard.co.uk>
date Mon, 08 May 2023 11:48:41 +0100
parents 668df4711671
children adf6fe9bbc17
line wrap: on
line diff
--- a/modules/mysql/README.md	Mon Apr 03 19:41:02 2023 +0100
+++ b/modules/mysql/README.md	Mon May 08 11:48:41 2023 +0100
@@ -143,7 +143,7 @@
   password        => 'mypass',
   host            => 'localhost',
   grant           => ['SELECT', 'UPDATE'],
-  sql             => '/path/to/sqlfile.gz',
+  sql             => ['/path/to/sqlfile.gz'],
   import_cat_cmd  => 'zcat',
   import_timeout  => 900,
   mysql_exec_path => '/opt/rh/rh-myql57/root/bin',
@@ -505,6 +505,30 @@
 }
 ```
 
+The next example shows how to use mariabackup (a fork of xtrabackup) as a backup provider.
+Note that on most Linux/BSD distributions, this will require setting `backupmethod_package => 'mariadb-backup'` in the `mysql::server::backup` declaration in order to override the default xtrabackup package (`percona-xtrabackup`).
+
+```puppet
+class { 'mysql::server':
+  package_name            => 'mariadb-server',
+  package_ensure          => '1:10.3.21+maria~xenial',
+  service_name            => 'mysqld',
+  root_password           => 'AVeryStrongPasswordUShouldEncrypt!',
+}
+
+class { 'mysql::server::backup':
+  backupuser              => 'mariabackup',
+  backuppassword          => 'AVeryStrongPasswordUShouldEncrypt!',
+  provider                => 'xtrabackup',
+  backupmethod            => 'mariabackup',
+  backupmethod_package    => 'mariadb-backup',
+  backupdir               => '/tmp/backups',
+  backuprotate            => 15,
+  execpath                => '/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin',
+  time                    => ['23', '15'],
+}
+```
+
 ## Reference
 
 ### Classes