Mercurial > repos > other > Puppet
view modules/website/manifests/mysql.pp @ 5:f2056be70cb8
Increase memory a bit more for optimisation
author | IBBoard <dev@ibboard.co.uk> |
---|---|
date | Sat, 30 Aug 2014 10:05:08 +0000 |
parents | 894e6287926f |
children | 3523e4c2604c |
line wrap: on
line source
class website::mysql ( $mysqluser, $mysqlpassword, $mysqlsuffix = '', $phpsuffix = '', $phpmysqlsuffix = '') { class { 'mysql::client': package_name => "mysql${mysqlsuffix}", bindings_enable => false, #Deal with bindings manually } class { 'mysql::bindings': php_enable => true, php_package_name => "php${phpsuffix}-mysql${phpmysqlsuffix}", } class { 'mysql::server': package_name => "mysql${mysqlsuffix}-server", override_options => { 'mysqld' => { 'query_cache_size' => '32M', 'join_buffer_size' => '524288', #512K 'tmp_table_size' => '64M', 'max_heap_table_size' => '64M', 'table_open_cache' => '500', 'slow_query_log' => '1', 'slow_query_log_file' => '/var/log/mysql/slow-query.log', 'log-queries-not-using-indexes' => '1', } }, require => File['/var/log/mysql/'] } file { '/var/log/mysql': ensure => directory, owner => 'mysql', group => 'mysql', } $username = strip($mysqluser) $password = strip($mysqlpassword) $configured_marker = '/etc/mysql/.is-configured' exec { 'Rename root MySQL user for security': command => "mysql -uroot -e 'UPDATE mysql.user SET User = \"$username\", Password = PASSWORD(\"$password\") WHERE User = \"root\"; DELETE FROM mysql.user WHERE User = ''; FLUSH PRIVILEGES;' && touch $configured_marker", provider => shell, creates => $configured_marker } }