summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2013-02-19introduce helpers for mysql backupsmh
2013-02-18Too much linting for factsGabriel Filion
ng brought a problem with my latest linting commit: facts are _always_ strings, so unquoting the value that we're testing against is actually wrong, even though puppet-lint complains. Signed-off-by: Gabriel Filion <lelutin@gmail.com>
2013-01-16lint mysql::serverGabriel Filion
2013-01-02fix typomh
2013-01-02make trocla an optional dependencymh
2013-01-02mysql 5.0 does not yet know about :trigger_privmh
2013-01-02get rid off trailing ,mh
2013-01-02Merge remote-tracking branch 'riseup/master'mh
Conflicts: manifests/client.pp manifests/server.pp manifests/server/base.pp manifests/server/cron/backup.pp manifests/server/munin/default.pp manifests/server/nagios.pp
2013-01-02lintingmh
2013-01-02Merge remote-tracking branch 'shared/master'mh
Conflicts: files/config/my.cnf.Debian manifests/server/base.pp manifests/server/munin/default.pp manifests/server/nagios.pp
2012-12-10some need the password not quoted...mh
2012-12-09simplify and correct dependenciesmh
1. it is important that the root password works 2. we don't need to chain the dependencies
2012-12-09document intend of refreshonyl for setting root pwmh
2012-12-09fix dependency issuesmh
2012-12-09woraround a puppet provider bugmh
2012-12-06lintingmh
2012-06-272.7 underscore rename: site-mysqlMicah Anderson
2012-06-17fix typomh
2012-06-14take hiera out of the paramsmh
2012-06-14take hiera out of the paramsmh
2012-06-14some more hiera variables removedo
2012-06-13remove hierao
2012-06-08refactor things for >2.7mh
2012-05-14use correct backup locationmh
Up to now we used an empty backup location... :/
2012-04-29Merge remote-tracking branch 'laurantb/master'mh
Conflicts: manifests/server/cron/backup.pp
2012-04-18fix trocla function lookup in template, without this, you get:Micah Anderson
err: Could not retrieve catalog from remote server: Error 400 on SERVER: Failed to parse template mysql/root/my.cnf.erb: undefined method `function_trocla' for #<Puppet::Parser::Scope:0xf6457e2c> at /etc/puppet/modules/mysql/manifests/server/base.pp:50 on node
2012-04-18fix another trivial syntax errorMicah Anderson
2012-04-18fix syntax errorMicah Anderson
2012-04-11Merge remote-tracking branch 'lelutin/nagios_service' into sharedMicah Anderson
2012-04-11Merge remote-tracking branch 'lelutin/squeeze_my_cnf' into sharedMicah Anderson
2012-04-11fix $use_munin hiera check to be use_munin instead of incorrect use_nagiosMicah Anderson
add $use_nagios hiera check
2012-04-09Import my.cnf from Debian SqueezeGabriel Filion
Lenny support was phased out and squeeze is the current stable. There is an instruction in the file that originally came from lenny: skip-bdb doesn't exist anymore in the mysql version in squeeze, so the config file makes a fresh mysql install crash on Squeeze. Signed-off-by: Gabriel Filion <lelutin@gmail.com>
2012-04-04switch hiera to pull its variables in parameterized classes instead of ↵Micah Anderson
inline in the manifest
2012-04-04add note to README about mysql::server::account_security removing accounts ↵Micah Anderson
by default, and how to get around it
2012-04-04Merge remote-tracking branch 'immerda/master'Micah Anderson
Conflicts: manifests/server/munin/default.pp manifests/server/nagios.pp
2012-03-07Merge branch 'shared'Micah Anderson
2012-03-07fix typo in name of mysql_qcache_mem graphMicah Anderson
2012-03-07Merge branch 'shared'Micah Anderson
2012-03-07Merge commit '356fdab8147f8a32a3f14514f2bb77f4f312c734' into sharedMicah Anderson
Conflicts: files/munin/mysql_connections manifests/server/base.pp manifests/server/munin/default.pp
2012-03-07Merge branch 'shared'Micah Anderson
2012-03-07Merge remote-tracking branch 'lelutin/root_pw_no_arg' into sharedMicah Anderson
Conflicts: manifests/server/base.pp
2012-02-29Merge remote-tracking branch 'lelutin/nagios_service'Micah Anderson
2012-02-23Use the right parameter to nagios::service::mysqlGabriel Filion
check_hostname is not defined. We need to use check_host instead
2012-02-10correct key for trocla lookupmh
2012-02-10migrate everything to hiera/trocla and use the new scoping stylemh
2012-01-22add the trigger privilege to the list of potential MYSQL_USER_PRIVSMicah Anderson
2012-01-17add innodb_file_per_table option by defaultmh
mysql has one innodb file per default and this can become very huge, which can trigger various issues [1]. So in general it is recommended to set the innodb_file_per_table option [2]. [1] http://forums.mysql.com/read.php?35,121880,121886 [2] http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html
2012-01-16fix missing endMicah Anderson
2012-01-01Instead of doing an update table_priv, we need to do GRANT/REVOKE statementsMicah Anderson
When we are working with tables_priv we need to first get a downcased array of the currently set privileges, and a downcased array of the desired permissions. Then we make a list of the permissions to revoke by subtracting the requested permissions from the currently set ones. If the list of permissions to revoke is not empty, then we issue a REVOKE. Then we make a list of the permissions to add by subtracting the requested permissions from the current set (no need to add select again if it is already there). Then if the set of permissions to add is not empty, then we actually execute the statement.
2012-01-01table privileges need to be handled with GRANT/REVOKE statements instead of ↵Micah Anderson
inserts of Y/N values into the table. To handle this, this comment removes the create_row for table_privs, it also selects the actual value of the Table_priv so its value can be used instead of the method that is used for Y/N value settings