Skip to content

paradoxbound/puppet-mysql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

62 Commits
 
 
 
 
 
 
 
 
 
 

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

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

About

Puppet mysql module

Resources

Stars

Watchers

Forks

Packages

No packages published