Forge Home

mysql

Puppet module for mysql

Aneesh C

aneesh

10,020 downloads

3,574 latest version

4.6 quality score

Version information

  • 7.0.0 (latest)
  • 6.3.0
  • 6.2.0
  • 6.1.0
  • 6.0.1
  • 6.0.0
  • 5.0.0
  • 4.0.0
  • 3.0.0
  • 2.0.0
  • 1.1.0
  • 1.0.3
  • 1.0.2
  • 1.0.1
  • 1.0.0
released Oct 30th 2018
This version is compatible with:
  • RedHat
    ,
    CentOS
    ,
    Ubuntu
    ,
    Debian

Start using this module

Documentation

aneesh/mysql — version 7.0.0 Oct 30th 2018

MySQL Module

Overview

This module install and configure mysql database server.

Usage

Default configuration:

include mysql

Custom configuration:

class { 'mysql':
    mysqld_datadir               => '/var/lib/mysql',
    mysqld_socket                => '/var/run/mysqld/mysqld.sock',
    mysqld_user                  => 'mysql',
    mysqld_bind_address          => '127.0.0.1',
    mysqld_local_infile          => '0',
    mysqld_pid_file              => '/var/run/mysqld/mysqld.pid',
    mysqld_port                  => '3306',
    mysqld_basedir               => '/usr',
    mysqld_tmpdir                => '/tmp',
    mysqld_lc_messages_dir       => '/usr/share/mysql',
    mysqld_skip_external_locking => true,
    mysqld_key_buffer            => '16M',
    mysqld_max_allowed_packet    => '16M',
    mysqld_thread_stack          => '192K',
    mysqld_thread_cache_size     => '8',
    mysqld_myisam_recover        => 'BACKUP',
    mysqld_query_cache_limit     => '1M',
    mysqld_query_cache_size      => '16M',
    mysqld_log_error             => '/var/log/mysql/error.log',
    mysqld_expire_logs_days      => '10',
    mysqld_max_binlog_size       => '100M',
    mysqld_safe_log_error        => '/var/log/mysql/mysql.log',
    mysqld_safe_socket           => '/var/run/mysqld/mysqld.sock',
    mysqld_safe_nice             => '0',
    client_port                  => '3306',
    client_socket                => '/var/run/mysqld/mysqld.sock',
    mysqldump_quick              => true,
    mysqldump_quote_names        => true,
    mysqldump_max_allowed_packet => '16M',
    isamchk_key_buffer           => '16M',
    includedir                   => [ '/etc/mysql/conf.d/' ],
}