Age | Commit message (Collapse) | Author | |
---|---|---|---|
2010-10-29 | fully qualify the path to mysqladmin, without it, you will get this error: | Micah Anderson | |
Parameter unless failed: 'mysqladmin -uroot status > /dev/null' is both unqualifed and specified no search path at /etc/puppet/modules/mysql/manifests/server/base.pp:62 unless you have set globally: Exec { path => "/usr/bin:/usr/sbin/:/bin:/sbin:/usr/local/bin:/usr/local/sbin" } | |||
2010-10-26 | fixed stray semicolon | Micah Anderson | |
2010-10-26 | fix script_path_in parameter | Micah Anderson | |
2010-10-26 | fix munin script path | Micah Anderson | |
2010-10-26 | move the mysql::server::munin::base class to its own file | Micah Anderson | |
2010-10-26 | fix incorrect munin graph names | Micah Anderson | |
2010-10-26 | add the mysql munin graphs: | Micah Anderson | |
. mysql_connections . mysql_qcache . mysql_qcache_mem . mysql_size_all | |||
2010-10-18 | . remove the check_mysql_health script from the mysql module, instead it ↵ | Micah Anderson | |
belongs in the nagios module . change the default nagios::service::mysql check to use the check_mysql_health 'connection-time' check mode, which is identical to the original check, with some additional information . stop using nagios::plugin::deploy because this doesn't work when more than one node attempts to realize this class . stop exporting the nagios_command because this doesn't work when more than one node attempts to realize this class . remove the check_health define, instead this be how it was before, as the previous nagios::service::mysql define | |||
2010-10-18 | change the default $check_hostname variable to be the localhost interface. ↵ | Micah Anderson | |
This seems to make more sense than using $fqdn | |||
2010-10-17 | add a README which describes all the functionality, how to use it, and the ↵ | Micah Anderson | |
pre-requisites necessary for the module | |||
2010-10-17 | simplify the nagios check_mysql_health plugin process: | Micah Anderson | |
1. use the new plugin deploy feature in nagios (nagios::plugin::deploy) 2. remove unnecessary classes and inheritance - this plugin seems reasonable to install by default, and in fact it could be argued that the other 'check_mysql' plugin that still remains can be removed, as its functionality is vastly overshadowed by this one 3. add the 'repl_client_priv' mysql grant privs to the nagios user. these are needed for the check_mysql_health plugin slave replication modes. According to http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html#priv_replication-client - The REPLICATION CLIENT privilege enables the use of SHOW MASTER STATUS and SHOW SLAVE STATUS. These privileges are not too much to provide to the nagios user, as they are only informational 4. setup the define "check_health" so it can be used easily | |||
2010-10-17 | add new version of check_mysql_health plugin | Micah Anderson | |
2010-09-27 | add a more advanced mysql health check plugin: | Micah Anderson | |
* create a mysql::server::nagios::base class with the common parts needed for the basic plugin, and the health plugin * make mysql::server:nagios inherit mysql::server:nagios::base * create a new class mysql::server::nagios::check_health inheriting ::base the nagios module has also received a new define to setup the different nagios::service pieces for the different health check modes that might be desired its assumed you would setup the different health check modes in site-mysql/init.pp as different hosts will require different modes and/or parameters, for example: class site-mysql::server { include mysql::server::nagios::check_health nagios::service::mysql_health { [ 'connection-time', 'uptime', 'threads-connected', 'threadcache-hitrate' ]: require => Mysql_grant[$nagios_mysql_user], } case $hostname { "eider": { nagios::service::mysql_health { [ 'slave-io-running', 'slave-sql-running', 'slave-lag' ]: require => Mysql_grant[$nagios_mysql_user], } } } } | |||
2010-09-22 | fixing merge error which removed a / -- round 2 | Micah Anderson | |
2010-09-22 | fixing merge error which removed a / | Micah Anderson | |
2010-09-22 | fix pathing, its /usr not /user | Micah Anderson | |
2010-09-22 | Merge remote branch 'remotes/immerda/master' | Micah Anderson | |
Conflicts: manifests/server/base.pp | |||
2010-09-22 | remove license reference from init.pp, as there is no LICENSE file to be ↵ | Micah Anderson | |
referenced | |||
2010-09-22 | increase timeout before killing to account for slower startup speed of ↵ | Micah Anderson | |
larger databases | |||
2010-09-22 | add copyright notice in header | Micah Anderson | |
2010-09-22 | allow for different my.cnf files according to the OS release | Micah Anderson | |
2010-09-22 | require package mysql-server for service mysql instead of mysql-client | Micah Anderson | |
2010-08-11 | remove unnecessary fileserver variable (#2460) round II | mh | |
2010-08-11 | get rid off expensive which call | mh | |
2010-08-07 | remove unnecessary fileserver variable (#2460) | mh | |
2010-07-21 | add define to manage a common db/user setup | mh | |
a db and a corresponding user with all access to that database. | |||
2010-07-21 | some minor updates to the providers | mh | |
2010-07-01 | merge with lavamind | mh | |
2010-05-10 | add mysql::client::ruby subclass | Jerome Charaoui | |
2010-05-10 | implement mysql::client subclasses | Jerome Charaoui | |
2010-05-07 | adapt to new common module | Jerome Charaoui | |
2010-04-22 | fix quoting | mh | |
2010-04-04 | as we are in ruby we need to double escape that | mh | |
2010-04-04 | escape table and db names | mh | |
2010-04-02 | manage file before cron, but only when we actually manage the file | mh | |
2010-04-02 | make backup dir management optional | mh | |
2010-04-02 | improve optimize script to work as well on weird named tables | mh | |
2010-04-02 | allow one to disable nagio smysql checks | mh | |
2010-04-02 | move scripts to /usr/local/sbin, old scripts are getting removed by wiping ↵ | mh | |
the modules dir | |||
2010-04-02 | no need to have an empty class | mh | |
2010-04-02 | no need to set an empty source dir | mh | |
2009-12-22 | adjust nagios mysql user to allow tcp connections | Jerome Charaoui | |
2009-12-11 | add nagios class to create mysql user and grant for nagios, with option to ↵ | Jerome Charaoui | |
skip nagios service registration if check is done through check_ssh or check_nrpe for example | |||
2009-12-11 | manage mysql munin plugin per-OS, use debian.cnf on Debian | Jerome Charaoui | |
2009-12-11 | manage permissions on debian.cnf | Jerome Charaoui | |
2009-12-10 | make backup and optimize cron jobs optional; introduce $mysql_backup_cron, ↵ | Jerome Charaoui | |
$mysql_backup_dir and$mysql_optimize_cron; use a module_dir for scripts | |||
2009-12-10 | change mysql client alias and quote resource names | Jerome Charaoui | |
2009-12-10 | run mysql_set_rootpw if $mysql_rootpw changes | Jerome Charaoui | |
2009-12-10 | add Debian support | Jerome Charaoui | |
2009-11-19 | be nicer during mysql backup | mh | |
sometimes it can happen that by locking all tables we run into error 24, which means to many open files. According to http://rackerhacker.com/2007/08/19/mysql-errcode-24-when-using-lock-tables/ we can use single-transaction to be nicer during backups. |