sdb_mysql

Table of Contents

1. Module Description
2. Setup

Module Description

The sdb_mysql module installs, configures, and manages multiple MySQL instances. It requires the module puppetlabs/mysql, please install the puppetlabs/mysql module before using sdb_mysql module.

sudo puppet module install puppetlabs-mysql

The code structure is very similar to puppetlabs/mysql and the goal is to reuse all parameters of puppetlabs/mysql.

Setup

Module installation

Install sdb_mysql module on your system.

sudo git clone https://github.com/schroedingerdb/puppet-sdb_mysql.git /etc/puppet/modules/sdb_mysql

Beginning with sdb_mysql

The behavior of the module is similar to puppetlabs/mysql. Read the documentation of puppetlabs/mysql for details. If you want to install multiple MySQL instances you can do this:

$root_password = "root"

$override_options = {
  'mysqld' => {
    'bind-address' => '0.0.0.0',
  }
}

class { 'mysql::server':
  root_password => $root_password,
  override_options => $override_options
}

class { 'sdb_mysql':;}

sdb_mysql::instance {
  'mysql-1': port => 3307, override_options => $override_options ;
  'mysql-2': port => 3308, override_options => $override_options ;
  'mysql-3': port => 3309, override_options => $override_options ;
}

With this example you will install one normal mysql server instance on port 3306 and three multiple instances on other ports.

Stop and start services

After running puppet with the example above you can stop and start service as usual.

sudo service mysql stop
sudo service mysql-1 stop
sudo service mysql-2 stop
sudo service mysql-3 stop

sudo service mysql start
sudo service mysql-1 start
sudo service mysql-2 start
sudo service mysql-3 start

###Config, data and log folder With the example above these folder exists.

/etc/mysql/
/etc/mysql-1/
..
/var/lib/mysql/
/var/lib/mysql-1/
..
/var/log/mysql/
/var/log/mysql-1/

Parameters

sdb_mysql::instance

override_options

Same behavior like: https://forge.puppetlabs.com/puppetlabs/mysql#mysqlserver

The hash of override options to pass into MySQL. Structured like a hash in the my.cnf file:

$override_options = {
  'section' => {
    'item'             => 'thing',
  }
}

users

Same behavior like: https://forge.puppetlabs.com/puppetlabs/mysql#mysqlserver

Optional hash of users to create, which are passed to mysql_user.

users => {
  'someuser@localhost' => {
    ensure                   => 'present',
    max_connections_per_hour => '0',
    max_queries_per_hour     => '0',
    max_updates_per_hour     => '0',
    max_user_connections     => '0',
    password_hash            => '*F3A2A51A9B0F2BE2468926B4132313728C250DBF',
  },
}

grants

Same behavior like: https://forge.puppetlabs.com/puppetlabs/mysql#mysqlserver

Optional hash of grants, which are passed to mysql_grant.

grants => {
  'someuser@localhost/somedb.*' => {
    ensure     => 'present',
    options    => ['GRANT'],
    privileges => ['SELECT', 'INSERT', 'UPDATE', 'DELETE'],
    table      => 'somedb.*',
    user       => 'someuser@localhost',
  },
}