view modules/mysql/examples/monitor.pp @ 389:668df4711671

Update MySQL modules
author IBBoard <dev@ibboard.co.uk>
date Mon, 03 Jan 2022 17:16:21 +0000
parents
children c6c9a2cfcfbd
line wrap: on
line source

# @summary
#   Add a monitoring user to the database

$mysql_monitor_password = 'password'
$mysql_monitor_username = 'monitoring'
$mysql_monitor_hostname = $::facts['networking']['hostname']

mysql_user { "${mysql_monitor_username}@${mysql_monitor_hostname}":
  ensure        => present,
  password_hash => mysql::password($mysql_monitor_password),
  require       => Class['mysql::server::service'],
}

mysql_grant { "${mysql_monitor_username}@${mysql_monitor_hostname}/*.*":
  ensure     => present,
  user       => "${mysql_monitor_username}@${mysql_monitor_hostname}",
  table      => '*.*',
  privileges => ['PROCESS', 'SUPER'],
  require    => Mysql_user["${mysql_monitor_username}@${mysql_monitor_hostname}"],
}