Mercurial > repos > other > Puppet

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
442:2879e2d4148e 443:c6c9a2cfcfbd
141 mysql::db { 'mydb': 141 mysql::db { 'mydb':
142 user => 'myuser', 142 user => 'myuser',
143 password => 'mypass', 143 password => 'mypass',
144 host => 'localhost', 144 host => 'localhost',
145 grant => ['SELECT', 'UPDATE'], 145 grant => ['SELECT', 'UPDATE'],
146 sql => '/path/to/sqlfile.gz', 146 sql => ['/path/to/sqlfile.gz'],
147 import_cat_cmd => 'zcat', 147 import_cat_cmd => 'zcat',
148 import_timeout => 900, 148 import_timeout => 900,
149 mysql_exec_path => '/opt/rh/rh-myql57/root/bin', 149 mysql_exec_path => '/opt/rh/rh-myql57/root/bin',
150 } 150 }
151 ``` 151 ```
500 provider => 'xtrabackup', 500 provider => 'xtrabackup',
501 incremental_backups => false, 501 incremental_backups => false,
502 backuprotate => 5, 502 backuprotate => 5,
503 execpath => '/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin', 503 execpath => '/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin',
504 time => ['23', '15'], 504 time => ['23', '15'],
505 }
506 ```
507
508 The next example shows how to use mariabackup (a fork of xtrabackup) as a backup provider.
509 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`).
510
511 ```puppet
512 class { 'mysql::server':
513 package_name => 'mariadb-server',
514 package_ensure => '1:10.3.21+maria~xenial',
515 service_name => 'mysqld',
516 root_password => 'AVeryStrongPasswordUShouldEncrypt!',
517 }
518
519 class { 'mysql::server::backup':
520 backupuser => 'mariabackup',
521 backuppassword => 'AVeryStrongPasswordUShouldEncrypt!',
522 provider => 'xtrabackup',
523 backupmethod => 'mariabackup',
524 backupmethod_package => 'mariadb-backup',
525 backupdir => '/tmp/backups',
526 backuprotate => 15,
527 execpath => '/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin',
528 time => ['23', '15'],
505 } 529 }
506 ``` 530 ```
507 531
508 ## Reference 532 ## Reference
509 533