mysql

Mysql module

7,334,635 downloads

9,729 latest version

1.9 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 16.2.0 (latest)
  • 16.1.0
  • 16.0.0
  • 15.0.0
  • 14.0.0
  • 13.3.0
  • 13.2.0
  • 13.1.0
  • 13.0.1
  • 13.0.0
  • 12.0.3
  • 12.0.2
  • 12.0.1
  • 12.0.0
  • 11.1.0
  • 11.0.3
  • 11.0.2
  • 11.0.1
  • 11.0.0
  • 10.10.0
  • 10.9.1
  • 10.9.0
  • 10.8.0
  • 10.7.1
  • 10.7.0
  • 10.6.0
  • 10.5.0
  • 10.4.0
  • 10.3.0
  • 10.2.1
  • 10.2.0
  • 10.1.0
  • 10.0.0
  • 9.1.0
  • 9.0.0
  • 8.1.0
  • 8.0.1
  • 8.0.0
  • 7.0.0
  • 6.2.0
  • 6.1.0
  • 6.0.0
  • 5.4.0
  • 5.3.0
  • 5.2.1
  • 5.2.0
  • 5.1.0
  • 5.0.0
  • 4.0.1
  • 4.0.0
  • 3.11.0
  • 3.10.0
  • 3.9.0
  • 3.8.0
  • 3.7.0
  • 3.6.2
  • 3.6.1
  • 3.6.0
  • 3.5.0
  • 3.4.0
  • 3.3.0
  • 3.2.0
  • 3.1.0
  • 3.0.0
  • 2.3.1
  • 2.3.0
  • 2.2.3
  • 2.2.2
  • 2.2.1
  • 2.2.0 (deleted)
  • 2.1.0
  • 2.0.1
  • 2.0.0
  • 2.0.0-rc5 (pre-release)
  • 2.0.0-rc4 (pre-release)
  • 2.0.0-rc3 (pre-release)
  • 2.0.0-rc2 (pre-release)
  • 2.0.0-rc1 (pre-release)
  • 1.0.0
  • 0.9.0
  • 0.8.1
  • 0.8.0
  • 0.7.1
  • 0.7.0
  • 0.6.1
  • 0.6.0
  • 0.5.0
  • 0.4.0
  • 0.3.0
  • 0.2.0
  • 0.0.1
released Jul 5th 2013

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'puppetlabs-mysql', '0.8.0'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add puppetlabs-mysql
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install puppetlabs-mysql --version 0.8.0

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

puppetlabs/mysql — version 0.8.0 Jul 5th 2013

2013-07-01 - Version 0.8.0 Features:

  • mysql::perl class to install perl-DBD-mysql.
  • minor improvements to the providers to improve reliability
  • Install the MariaDB packages on Fedora 19 instead of MySQL.
  • Add new mysql class parameters:
  • max_connections: The maximum number of allowed connections.
  • manage_config_file: Opt out of puppetized control of my.cnf.
  • ft_min_word_len: Fine tune the full text search.
  • ft_max_word_len: Fine tune the full text search.
  • Add new mysql class performance tuning parameters:
  • key_buffer
  • thread_stack
  • thread_cache_size
  • myisam-recover
  • query_cache_limit
  • query_cache_size
  • max_connections
  • tmp_table_size
  • table_open_cache
  • long_query_time
  • Add new mysql class replication parameters:
  • server_id
  • sql_log_bin
  • log_bin
  • max_binlog_size
  • binlog_do_db
  • expire_logs_days
  • log_bin_trust_function_creators
  • replicate_ignore_table
  • replicate_wild_do_table
  • replicate_wild_ignore_table
  • expire_logs_days
  • max_binlog_size

Bugfixes:

  • No longer restart MySQL when /root/.my.cnf changes.
  • Ensure mysql::config runs before any mysql::db defines.

2013-06-26 - Version 0.7.1 Bugfixes:

  • Single-quote password for special characters
  • Update travis testing for puppet 3.2.x and missing Bundler gems

2013-06-25 - Version 0.7.0 This is a maintenance release for community bugfixes and exposing configuration variables.

  • Add new mysql class parameters:
  • basedir: The base directory mysql uses
  • bind_address: The IP mysql binds to
  • client_package_name: The name of the mysql client package
  • config_file: The location of the server config file
  • config_template: The template to use to generate my.cnf
  • datadir: The directory MySQL's datafiles are stored
  • default_engine: The default engine to use for tables
  • etc_root_password: Whether or not to add the mysql root password to /etc/my.cnf
  • java_package_name: The name of the java package containing the java connector
  • log_error: Where to log errors
  • manage_service: Boolean dictating if mysql::server should manage the service
  • max_allowed_packet: Maximum network packet size mysqld will accept
  • old_root_password: Previous root user password
  • php_package_name: The name of the phpmysql package to install
  • pidfile: The location mysql will expect the pidfile to be
  • port: The port mysql listens on
  • purge_conf_dir: Value fed to recurse and purge parameters of the /etc/mysql/conf.d resource
  • python_package_name: The name of the python mysql package to install
  • restart: Whether to restart mysqld
  • root_group: Use specified group for root-owned files
  • root_password: The root MySQL password to use
  • ruby_package_name: The name of the ruby mysql package to install
  • ruby_package_provider: The installation suite to use when installing the ruby package
  • server_package_name: The name of the server package to install
  • service_name: The name of the service to start
  • service_provider: The name of the service provider
  • socket: The location of the MySQL server socket file
  • ssl_ca: The location of the SSL CA Cert
  • ssl_cert: The location of the SSL Certificate to use
  • ssl_key: The SSL key to use
  • ssl: Whether or not to enable ssl
  • tmpdir: The directory MySQL's tmpfiles are stored
  • Deprecate mysql::package_name parameter in favor of mysql::client_package_name
  • Fix local variable template deprecation
  • Fix dependency ordering in mysql::db
  • Fix ANSI quoting in queries
  • Fix travis support (but still messy)
  • Fix typos

2013-01-11 - Version 0.6.1

  • Fix providers when /root/.my.cnf is absent

2013-01-09 - Version 0.6.0

  • Add mysql::server::config define for specific config directives
  • Add mysql::php class for php support
  • Add backupcompress parameter to mysql::backup
  • Add restart parameter to mysql::config
  • Add purge_conf_dir parameter to mysql::config
  • Add manage_service parameter to mysql::server
  • Add syslog logging support via the log_error parameter
  • Add initial SuSE support
  • Fix remove non-localhost root user when fqdn != hostname
  • Fix dependency in mysql::server::monitor
  • Fix .my.cnf path for root user and root password
  • Fix ipv6 support for users
  • Fix / update various spec tests
  • Fix typos
  • Fix lint warnings

2012-08-23 - Version 0.5.0

  • Add puppetlabs/stdlib as requirement
  • Add validation for mysql privs in provider
  • Add pidfile parameter to mysql::config
  • Add ensure parameter to mysql::db
  • Add Amazon linux support
  • Change bind_address parameter to be optional in my.cnf template
  • Fix quoting root passwords

2012-07-24 - Version 0.4.0

  • Fix various bugs regarding database names
  • FreeBSD support
  • Allow specifying the storage engine
  • Add a backup class
  • Add a security class to purge default accounts

2012-05-03 - Version 0.3.0

  • #14218 Query the database for available privileges
  • Add mysql::java class for java connector installation
  • Use correct error log location on different distros
  • Fix set_mysql_rootpw to properly depend on my.cnf

2012-04-11 - Version 0.2.0

2012-03-19 - William Van Hevelingen blkperl@cat.pdx.edu

  • (#13203) Add ssl support (f7e0ea5)

2012-03-18 - Nan Liu nan@puppetlabs.com

  • Travis ci before script needs success exit code. (0ea463b)

2012-03-18 - Nan Liu nan@puppetlabs.com

  • Fix Puppet 2.6 compilation issues. (9ebbbc4)

2012-03-16 - Nan Liu nan@puppetlabs.com

  • Add travis.ci for testing multiple puppet versions. (33c72ef)

2012-03-15 - William Van Hevelingen blkperl@cat.pdx.edu

  • (#13163) Datadir should be configurable (f353fc6)

2012-03-16 - Nan Liu nan@puppetlabs.com

  • Document create_resources dependency. (558a59c)

2012-03-16 - Nan Liu nan@puppetlabs.com

  • Fix spec test issues related to error message. (eff79b5)

2012-03-16 - Nan Liu nan@puppetlabs.com

  • Fix mysql service on Ubuntu. (72da2c5)

2012-03-16 - Dan Bode dan@puppetlabs.com

  • Add more spec test coverage (55e399d)

2012-03-16 - Nan Liu nan@puppetlabs.com

  • (#11963) Fix spec test due to path changes. (1700349)

2012-03-07 - François Charlier fcharlier@ploup.net

  • Add a test to check path for 'mysqld-restart' (b14c7d1)

2012-03-07 - François Charlier fcharlier@ploup.net

  • Fix path for 'mysqld-restart' (1a9ae6b)

2012-03-15 - Dan Bode dan@puppetlabs.com

  • Add rspec-puppet tests for mysql::config (907331a)

2012-03-15 - Dan Bode dan@puppetlabs.com

  • Moved class dependency between sever and config to server (da62ad6)

2012-03-14 - Dan Bode dan@puppetlabs.com

  • Notify mysql restart from set_mysql_rootpw exec (0832a2c)

2012-03-15 - Nan Liu nan@puppetlabs.com

  • Add documentation related to osfamily fact. (8265d28)

2012-03-14 - Dan Bode dan@puppetlabs.com

  • Mention osfamily value in failure message (e472d3b)

2012-03-14 - Dan Bode dan@puppetlabs.com

  • Fix bug when querying for all database users (015490c)

2012-02-09 - Nan Liu nan@puppetlabs.com

  • Major refactor of mysql module. (b1f90fd)

2012-01-11 - Justin Ellison justin.ellison@buckle.com

  • Ruby and Python's MySQL libraries are named differently on different distros. (1e926b4)

2012-01-11 - Justin Ellison justin.ellison@buckle.com

  • Per @ghoneycutt, we should fail explicitly and explain why. (09af083)

2012-01-11 - Justin Ellison justin.ellison@buckle.com

  • Removing duplicate declaration (7513d03)

2012-01-10 - Justin Ellison justin.ellison@buckle.com

  • Use socket value from params class instead of hardcoding. (663e97c)

2012-01-10 - Justin Ellison justin.ellison@buckle.com

  • Instead of hardcoding the config file target, pull it from mysql::params (031a47d)

2012-01-10 - Justin Ellison justin.ellison@buckle.com

  • Moved $socket to within the case to toggle between distros. Added a $config_file variable to allow per-distro config file destinations. (360eacd)

2012-01-10 - Justin Ellison justin.ellison@buckle.com

  • Pretty sure this is a bug, 99% of Linux distros out there won't ever hit the default. (3462e6b)

2012-02-09 - William Van Hevelingen blkperl@cat.pdx.edu

  • Changed the README to use markdown (3b7dfeb)

2012-02-04 - Daniel Black grooverdan@users.sourceforge.net

  • (#12412) mysqltuner.pl update (b809e6f)

2011-11-17 - Matthias Pigulla mp@webfactory.de

  • (#11363) Add two missing privileges to grant: event_priv, trigger_priv (d15c9d1)

2011-12-20 - Jeff McCune jeff@puppetlabs.com

  • (minor) Fixup typos in Modulefile metadata (a0ed6a1)

2011-12-19 - Carl Caum carl@carlcaum.com

  • Only notify Exec to import sql if sql is given (0783c74)

2011-12-19 - Carl Caum carl@carlcaum.com

  • (#11508) Only load sql_scripts on DB creation (e3b9fd9)

2011-12-13 - Justin Ellison justin.ellison@buckle.com

  • Require not needed due to implicit dependencies (3058feb)

2011-12-13 - Justin Ellison justin.ellison@buckle.com

  • Bug #11375: puppetlabs-mysql fails on CentOS/RHEL (a557b8d)

2011-06-03 - Dan Bode dan@puppetlabs.com - 0.0.1

  • initial commit