List:Internals« Previous MessageNext Message »
From:Stewart Smith Date:July 1 2006 7:00am
Subject:Re: MySQL / SNMP (revised)
View as plain text  
On Fri, 2006-06-30 at 15:53 +0200, Michel Stam wrote:
> Weekly status update;
> Still having some problems when the cluster management node goes down. 
> For some reason the agent doesn't properly respond anymore after this. 
>  From a few traces it seems that the agent fails to auto-reregister with 
> the snmpd daemon periodically (which it is supposed to do) and the snmpd 
> daemon gives up on it. At the very least, SNMP requests don't seem to be 
> forwarded. I need a little more time on that, perhaps I'll try with a 
> more recent net-snmp (I'm using 5.1.3.1).


> Other than that I've added SNMP traps, which are now sent whenever the 
> agent loses or regains connection with either the cluster or the mysqld 
> daemon itself. Also a simple trap is sent upon startup or shutdown. 
> Agent daemonizes too (or not, at the option of the admin).

great, this looks like a useful feature for people. with the
auto-reregister working this would mean that people can know when their
monitor can no longer talk to the cluster (or has crashed, caught on
fire etc).

> Code seems mostly clean (I am adding a couple of headers on functions so 
> they can be more easily reused), and a rudimentary Makefile is in place 
> (I haven't looked into autoconf/automake which would be fairly useless 
> if it will end up in the MySQL tree at some point in the future). No 
> testing as yet on any other version than 4.1.18.

great!

> Workarounds necessary:
> 
>     * Missing include files for mysql/ndb/mgmapi. It seems that at least
>       ndb_global.h and ndb_net.h are not installed in mysql/ndb when
>       executing 'make install'. See ndb/include/Makefile.am in the
>       source tree for 4.1. Unfortunately, mysql/ndb/ndb_types.h, which
>       is included by mysql/ndb/mgmapi/mgmapi.h #includes ndb_global.h,
>       which will cause compiles to fail. Any reason why
>       ndb/include/Makefile.am lists ndb_global.h and ndb_net.h under
>       noinst_HEADERS? A workaround is copying both from the sourcetree
>       (ndb/include) into INSTALLPATH/mysql/ndb
>     * mysql/ndb/mgmapi/mgmapi.h defines 2 const values, namely const
>       struct Ndb_Mgm_Error_Msg ndb_mgm_error_msgs[] and const int
>       ndb_mgm_noOfErrorMsgs. If mgmapi.h is included in 2 or more
>       sourcefiles in a project, it will cause the link stage to fail
>       with a multiple definition error unless -zmuldefs is specified at
>       linkstage
>     * In mysql/ndb/mgmapi/mgmapi.h ndb_mgm_event_category and
>       ndb_mgm_clusterlog_level are two enums. However; strict C checking
>       does not allow for these types to be used without the 'enum'
>       keyword prepended. A workaround is typedef-ing both to 'int' prior
>       to including the mgmapi.h

file bugs for these and we'll investigate.

> I can provide a beta (it is properly running on my system, though I'm 
> still testing it). Let me know where I should send it to.

great! just putting it up on the net somewhere is fine, i can pull it
from there.

if you'd prefer it privately, we can organise something for that (or
rather, I get to find out where the uploads to ftp.mysql.com or
somewhere go).

-- 
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Thread
MySQL / SNMPMichel Stam20 Jun
  • Re: MySQL / SNMPStewart Smith20 Jun
    • Re: MySQL / SNMPMichel Stam20 Jun
      • Re: MySQL / SNMPStewart Smith21 Jun
        • Re: MySQL / SNMPMichel Stam21 Jun
          • Re: MySQL / SNMPStewart Smith22 Jun
            • Guidelines for accepting contributions (Was: MySQL / SNMP)Marc Alff22 Jun
              • Re: Guidelines for accepting contributions (Was: MySQL / SNMP)Stewart Smith22 Jun
            • Re: MySQL / SNMPMichel Stam22 Jun
              • Re: MySQL / SNMPStewart Smith23 Jun
                • Re: MySQL / SNMPMichel Stam23 Jun
                • Re: MySQL / SNMP (revised)Michel Stam23 Jun
                  • Re: MySQL / SNMP (revised)Michel Stam30 Jun
                    • Re: MySQL / SNMP (revised)Stewart Smith1 Jul
                      • Re: MySQL / SNMP (revised)Michel Stam5 Jul
                        • Re: MySQL / SNMP (revised)Stewart Smith5 Jul
                          • Re: MySQL / SNMP (revised)Michel Stam5 Jul
                            • Re: MySQL / SNMP (revised)Stewart Smith6 Jul
                              • Re: MySQL / SNMP (revised)Michel Stam6 Jul
Re: MySQL / SNMP (revised)Stewart Smith7 Jul
  • Re: MySQL / SNMP (revised)Michel Stam7 Jul
    • Re: MySQL / SNMP (revised)Michel Stam10 Jul
      • Re: MySQL / SNMP (revised)Michel Stam25 Jul
        • Re: MySQL / SNMP (revised)Stewart Smith28 Jul
          • Re: MySQL / SNMP (revised)Michel Stam28 Jul
            • Re: MySQL / SNMP (revised)Michel Stam15 Aug
              • Re: MySQL / SNMP (revised)Stewart Smith16 Aug
                • Re: MySQL / SNMP (revised)Michel Stam16 Aug
                  • Re: MySQL / SNMP (revised)Stewart Smith16 Aug
                    • Re: MySQL / SNMP (revised)Michel Stam16 Aug