Skip to content

rgevaert/puppet-mysql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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