Skip to content

antriver/puppet-mysql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

80 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Puppet mysql module

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Puppet 58.9%
  • Shell 30.4%
  • Perl 10.7%