summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2010-10-29fully 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-26fixed stray semicolonMicah Anderson
2010-10-26fix script_path_in parameterMicah Anderson
2010-10-26fix munin script pathMicah Anderson
2010-10-26move the mysql::server::munin::base class to its own fileMicah Anderson
2010-10-26fix incorrect munin graph namesMicah Anderson
2010-10-26add 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-18change the default $check_hostname variable to be the localhost interface. ↵Micah Anderson
This seems to make more sense than using $fqdn
2010-10-17add a README which describes all the functionality, how to use it, and the ↵Micah Anderson
pre-requisites necessary for the module
2010-10-17simplify 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-17add new version of check_mysql_health pluginMicah Anderson
2010-09-27add 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-22fixing merge error which removed a / -- round 2Micah Anderson
2010-09-22fixing merge error which removed a /Micah Anderson
2010-09-22fix pathing, its /usr not /userMicah Anderson
2010-09-22Merge remote branch 'remotes/immerda/master'Micah Anderson
Conflicts: manifests/server/base.pp
2010-09-22remove license reference from init.pp, as there is no LICENSE file to be ↵Micah Anderson
referenced
2010-09-22increase timeout before killing to account for slower startup speed of ↵Micah Anderson
larger databases
2010-09-22add copyright notice in headerMicah Anderson
2010-09-22allow for different my.cnf files according to the OS releaseMicah Anderson
2010-09-22require package mysql-server for service mysql instead of mysql-clientMicah Anderson
2010-08-11remove unnecessary fileserver variable (#2460) round IImh
2010-08-11get rid off expensive which callmh
2010-08-07remove unnecessary fileserver variable (#2460)mh
2010-07-21add define to manage a common db/user setupmh
a db and a corresponding user with all access to that database.
2010-07-21some minor updates to the providersmh
2010-07-01merge with lavamindmh
2010-05-10add mysql::client::ruby subclassJerome Charaoui
2010-05-10implement mysql::client subclassesJerome Charaoui
2010-05-07adapt to new common moduleJerome Charaoui
2010-04-22fix quotingmh
2010-04-04as we are in ruby we need to double escape thatmh
2010-04-04escape table and db namesmh
2010-04-02manage file before cron, but only when we actually manage the filemh
2010-04-02make backup dir management optionalmh
2010-04-02improve optimize script to work as well on weird named tablesmh
2010-04-02allow one to disable nagio smysql checksmh
2010-04-02move scripts to /usr/local/sbin, old scripts are getting removed by wiping ↵mh
the modules dir
2010-04-02no need to have an empty classmh
2010-04-02no need to set an empty source dirmh
2009-12-22adjust nagios mysql user to allow tcp connectionsJerome Charaoui
2009-12-11add 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-11manage mysql munin plugin per-OS, use debian.cnf on DebianJerome Charaoui
2009-12-11manage permissions on debian.cnfJerome Charaoui
2009-12-10make 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-10change mysql client alias and quote resource namesJerome Charaoui
2009-12-10run mysql_set_rootpw if $mysql_rootpw changesJerome Charaoui
2009-12-10add Debian supportJerome Charaoui
2009-11-19be nicer during mysql backupmh
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.