mysql

Manage your percona, mariadb or oracle MySQL
Daniele Salatti

Daniele Salatti

DanieleSalatti

7,721 downloads

7,721 latest version

1.5 quality score

Version information

  • 2.0.0 (latest)
released Jul 3rd 2019

Start using this module

Documentation

DanieleSalatti/mysql — version 2.0.0 Jul 3rd 2019

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