puppet-mysql

Puppet mysql module

Downloads
11.5K
Stars
17

This module manages MySQL. It gives you the choice MySQL server you want to use: Oracle, MariaDB or Percona

Parameters, first one is the default:

  • type : oracle|mariadb|percona
  • multi: false|true
  • manage_repo: do not manage repo config

Requires: camptocamp/apt rgevaert/pwgen

Sample Usages:

  1. Install mariadb MySQL server:

class { 'mysql': type => 'mariadb'; }

  1. Install Oracle MySQL that come with the Debian
    repositories. Setup multiple MySQL instance with
    MySQLd_multi.

class { 'mysql': multi => true; }

mysql::multi::instance{ 'mysqld1': groupnr => 1, bind_address => '0.0.0.0', port => 3307; 'mysqld2': groupnr => 2, bind_address => '0.0.0.0', port => 3308; 'mysqld3': groupnr => 3, bind_address => '0.0.0.0', port => 3309, ensure => 'stopped'; }

  1. Change a setting in your MySQL configuration.

mysql::config::param { 'bind-address': section => 'mysqld', value => '0.0.0.0'; }

mysql::config::param { 'bind-address1': section => 'mysqld1', param => 'bind-address', value => '0.0.0.0'; }

Package Rankings
Top 12.61% on Forge.puppet.com
Related Projects