mysql

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

Only tested on (and probably only works on) Ubuntu

Parameters, first one is the default:

• type : oracle|mariadb|percona
• multi: false|true

Requires: puppetlabs/apt

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

2.0.0

• Dependency is now puppetlabs/apt insted of camptocamp/apt (tests haven't been updated though)
• Oracle, Percona and MariaDB version updates
• Removed secure installation scripts which was never executed

1.0.0

• The following variables have been removed from params.pp. They were changed into class variables: notify_services multi_password multi_initscript (was initscript) multi_create_instance_script (was create_instance_script)

  Check if the defaults are still sane for your environment.

• Fix some dynamic lookup variables.