Puppet Galera

common/galera.yaml

Settings that can be used accross all galera setups

---

classes:
  - apt
  - galera
  - galera::repo

apt::key:
  mariadb:
    id: 'F1656F24C74CD1D8'
    server: 'keys.gnupg.net'
    before: Class[Galera::Repo]
apt::sources:
  percona:
    location: 'http://repo.percona.com/apt'
    release: '%{facts.os.distro.codename}'
    repos: 'main'
    key:
      id: '4D1BB29D63D98E422B2113B19334A25F8507EFA5'
      source: 'https://percona.com/downloads/deb-percona-keyring.gpg'

resources:
  package:
    percona-xtrabackup-24:
      require: Apt::Source[percona]

galera::wsrep_sst_method: rsync
galera::configure_firewall: false
galera::vendor_type: mariadb
galera::mysql_package_name: mariadb-server
galera::client_package_name: mariadb-client
galera::galera_package_name: galera-3
galera::purge_conf_dir: true
galera::local_ip: "%{facts.networking.ip}"
galera::bind_address: 0.0.0.0

galera::repo::apt_mariadb_repo_location: 'http://mirror.aarnet.edu.au/pub/MariaDB/repo/10.2/debian'
galera::repo::apt_mariadb_repo_key: '177F4010FE56CA3336300305F1656F24C74CD1D8'

bareos/galera.yaml

Setting specific for Bareos galera cluster

---

classes:
  - apt
  - galera
  - galera::repo
  - profile::galera

galera::galera_master: $IP
galera::cluster_name: $CLUSTER
galera::root_password: $PASSWORD
galera::status_password: $PASSWORD
galera::override_options:
  mysqld:
    wsrep_on: 'ON'

galera::galera_servers:
  - $IP1
  - $IP2
  - $IP3

profile::galera::import: $IMPORTTAG
profile::resources:
  mysql::db:
    bareos_qsu:
      user: bareos
      password: $PASSWORD
      host: $IP
    bareos_prod:
      user: bareos
      password: $PASSWORD
      host: $IP

---

Last update: April 13, 2020