puppet-mysql

puppet-mysql copied to clipboard

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'; }

2. 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'; }

3. 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'; }