Permalink
Switch branches/tags
Nothing to show
Commits on May 8, 2012
  1. add empty rspec tests

    brettporter committed May 8, 2012
Commits on May 12, 2011
  1. fix grant on newer mysql version

    MySQL introduced some new privileges in Versions > 5.1.6, add them
    to our set, so puppet still knows what :all is.
    duritong committed May 12, 2011
Commits on Apr 3, 2011
Commits on Feb 25, 2011
Commits on Feb 14, 2011
Commits on Dec 21, 2010
  1. add some other mysql plugins

    duritong committed Dec 21, 2010
Commits on Dec 18, 2010
  1. Avoid root password leak to process list

    The current procedure of setting the root MySQL password leaks the root
    password by giving it to the setmysqlpass.sh script on the command line.
    This means that during the couple of seconds that the script is
    executing, the password is visible in the process list!
    
    Since we're already writing the password in the /root/.my.cnf file, make
    the setmysqlpass.sh script parse this file to retrieve the password
    instead of receiving it from a command line argument.
    
    Also, in some shells the 'echo' command might appear in the process
    list. Use a heredoc notation to create the output without using a
    command.
    
    Signed-off-by: Gabriel Filion <lelutin@gmail.com>
    lelutin committed with duritong Dec 14, 2010
Commits on Oct 19, 2010
  1. . remove the check_mysql_health script from the mysql module, instead…

    … it 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
    micah committed Oct 19, 2010
Commits on Oct 18, 2010
  1. change the default $check_hostname variable to be the localhost inter…

    …face. This seems to make more sense than using $fqdn
    micah committed Oct 18, 2010
Commits on Oct 17, 2010
  1. add a README which describes all the functionality, how to use it, an…

    …d the pre-requisites necessary for the module
    micah committed Oct 17, 2010
  2. simplify the nagios check_mysql_health plugin process:

    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
    micah committed Oct 17, 2010
Commits on Sep 27, 2010
  1. add a more advanced mysql health check plugin:

     * 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],
          }
        }
      }
    }
    micah committed Sep 27, 2010
Commits on Sep 22, 2010
  1. fix pathing, its /usr not /user

    micah committed Sep 22, 2010
  2. Merge remote branch 'remotes/immerda/master'

    Conflicts:
    	manifests/server/base.pp
    micah committed Sep 22, 2010
  3. increase timeout before killing to account for slower startup speed o…

    …f larger databases
    micah committed Sep 22, 2010
  4. add copyright notice in header

    micah committed Sep 22, 2010
Commits on Aug 11, 2010
Commits on Aug 7, 2010
Commits on Jul 21, 2010
  1. add define to manage a common db/user setup

    a db and a corresponding user with all access to that database.
    duritong committed Jul 21, 2010
Commits on Jul 1, 2010
  1. merge with lavamind

    duritong committed Jul 1, 2010
Commits on May 10, 2010
Commits on May 7, 2010
  1. adapt to new common module

    jcharaoui committed May 7, 2010
Commits on Apr 22, 2010
  1. fix quoting

    duritong committed Apr 22, 2010
Commits on Apr 4, 2010
  1. escape table and db names

    duritong committed Apr 4, 2010
Commits on Apr 2, 2010