Mercurial > repos > other > Puppet
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