percona

Puppet module for percona

Alessandro De Salvo

desalvo

11,343 downloads

5,546 latest version

2.1 quality score

Version information

  • 0.1.14 (latest)
  • 0.1.6
  • 0.1.5
  • 0.1.4
  • 0.1.3
  • 0.1.0
released Mar 31st 2017

Start using this module

Documentation

desalvo/percona — version 0.1.14 Mar 31st 2017

puppet-percona

Puppet module for managing Percona XtraDB.

Table of Contents

  1. Overview - What is the percona module?

Overview

This module is intended to be used to manage the Percona XtraDB system configuration. Percona XtraDB is an enhanced version of the InnoDB storage engine for MySQL® and MariaDB®.

Parameters

The following parameters are supported:

  • mysql_version: the Percona mysql version to be used. Currently 5.5 or 5.6 [default: 5.5]
  • root_password: the root password of the database [default: unset]
  • old_passwords: set this to true to support the old mysql 3.x hashes for the passwords [default: false]
  • datadir: the mysql data directory [default: /var/lib/mysql]
  • bind_address: the mysql bind address
  • port: the mysql server port [default: 3306]
  • server_id: the server id [default: 1]
  • skip_slave_start: set this to true to skip the slave startup on boot [default: true]
  • ist_recv_addr: the IST receiver address for WSREP [default: ipaddress]
  • wsrep_max_ws_size: the WSREP max working set size [default: 2G]
  • wsrep_cluster_address: the WSREP cluster address list, like gcomm://:4010,:4010 [default: gcomm://]
  • wsrep_provider: the WSREP provider [default: libgalera_smm.so]
  • wsrep_max_ws_rows: the WSREP max working set rows [default: 1024000]
  • wsrep_sst_receive_address: the SST receiver address [default: ipaddress:4020]
  • wsrep_slave_threads: number of WSREP slave threads [default: 2]
  • wsrep_sst_method: the WSREP SST method, like rsync or xtrabackup [default: rsync]
  • wsrep_sst_auth: the auth string for SST, if needed [default: undef]
  • wsrep_cluster_name: the WSREP cluster name [default: default]
  • binlog_format: the binlog format [default: ROW]
  • default_storage_engine: the default storage engine [default: InnoDB]
  • innodb_autoinc_lock_mode: the innodb lock mode [default: 2]
  • innodb_locks_unsafe_for_binlog: set this to true if you want to use unsafe locks for the binlogs [default: 1]
  • innodb_buffer_pool_size: the innodb buffer pool size [default: 128M]
  • innodb_log_file_size: the innodb log file size [default: 256M]
  • bulk_insert_buffer_size: the size of the insert buffer [default: 128M]
  • innodb_flush_log_at_trx_commit: set this to allow flushing of logs at transaction commit [default: 2]
  • innodb_file_per_table: set this to true to allow using sepafate files for the innodb tablespace [default: true]
  • innodb_file_format: the file format for innodb [default: Barracuda]
  • innodb_file_format_max: the higher level of file formats for innodb [default: Barracuda]
  • sort_buffer_size: the size of the sort buffer [default: 64M]
  • read_buffer_size: the size of the read buffer [default: 64M]
  • read_rnd_buffer_size: the size of the rnd buffer [default: 64M]
  • key_buffer_size: size of keys [default: 64M]
  • myisam_sort_buffer_size: the myisam sort buffer size [default: 64M]
  • max_connections: the maximum number of allowed connections [default: 151]
  • thread_cache: the number of thread caches [default: 2]
  • thread_stack: the stack size for each thread [default: 256K]
  • query_cache_limit: the size of individual query results that can be cached
  • query_cache_size: the size of the query cache [default: 64M]
  • table_open_cache: the number of open tables for all threads [default: 400]
  • skip_external_locking: disable external locking if true [default: true]
  • ssl: Use SSL [default: false]
  • ssl_ca: SSL CA bundle file
  • ssl_cert: use certificate file
  • ssl_key: use key file
  • tmpdir: the path of the directory to use for creating temporary files [default: /tmp]
  • log_warnings: log warning level [default: none]

Usage

Example

This is a simple example to configure a percona server.

Using the percona XtraDB module

class { 'percona':
    root_password => 'dummy_password',
    wsrep_cluster_address => 'gcomm://192.168.0.1:4010,192.168.0.2:4010',
    wsrep_cluster_name => 'mycluster'
}

Please note that in case you already have other DB machines in the cluster you will need to use the same value of innodb_log_file_size for all the components of the cluster.

Contributors

Release Notes

0.1.14

  • Support for the noarch repo
  • Support for additional parameters
  • Support for /root/.my.cnf
  • Puppet 4 support

0.1.13

  • Add support for RHEL7
  • Remove deprecated directive thread_concurrency

0.1.12

  • Add log_warning setting

0.1.11

  • Add support for changing server port

0.1.10

  • Fixed behaviour with multiple versions and bad key server on Debian/Ubuntu
  • Refactoring of the module internals

0.1.6

  • Replaced consensus_timeout with install_timeout
  • Updated compat package

0.1.5

  • Fixed mysql db initialization when using a custom datadir location

0.1.4

  • Better handling of the datadir parameter

0.1.3

  • Fixed bug on percona startup procedure

0.1.2

  • Improved documentation

0.1.1

  • Added support for Ubuntu/Debian.
  • Better handling of the initial setup.

0.1.0

  • Initial version.