List:Internals« Previous MessageNext Message »
From:Michel Stam Date:July 7 2006 7:44am
Subject:Re: MySQL / SNMP (revised)
View as plain text  
Hey Stewart,

>Great - this is probably best. It is highly unlikely that anybody is
>going to deploy 4.1 Cluster at this stage (5.0 at least). However, some
>may want to add this on... but I would say most people these days are
>going with 5.0 or plan to upgrade soon.

True enough. Comments have been added to the INSTRUCTIONS file. As before;
http://www.reverze.net/mysql_snmp.tar.gz

>Have a look at the (recently uploaded) NDB API docs in the MGM API.
>
>http://dev.mysql.com/doc/ndbapi/en/struct-ndb-logevent.html
>
>Each event has different information, but most have all that you would
>need.

This was what I was looking for :)
I'll see if I can code this in; Unfortunately we don't have anything else than 4.1 cluster
here, so I don't know if I can test it properly. I haven't seen those functions in 4.1.
Shouldn't be too difficult, I think.

(I know, we should really upgrade our MySQL cluster - This will probably happen if/when
the agent is in the MySQL code, be it version 5.0.x or later)

Another thing; I send an email to mr. Paley regarding the SNMP OID (to check he's not
using it for anything). No response so far, I assume he still works for MySQL, Inc.

And last, but not least - Have a great holiday next week!

Cheers,

Michel

Stewart Smith wrote:
> On Thu, 2006-07-06 at 10:28 +0200, Michel Stam wrote:
>   
>> Ok, in that case I'll refrain from posting the bugs so as not to
>> needlessly bother the mysql developers. I can work around the problem
>> easily enough, anyway.
>>
>> I'll make a couple of additions to the INSTRUCTIONS file with these
>> issues, so that people running 4.1 wanting to compile this don't have
>> to figure it out for themselves.
>>     
>
> Great - this is probably best. It is highly unlikely that anybody is
> going to deploy 4.1 Cluster at this stage (5.0 at least). However, some
> may want to add this on... but I would say most people these days are
> going with 5.0 or plan to upgrade soon.
>
>   
>> Another thing that came to mind yesterdaynight;
>> I know that its possible to get events from the NDB cluster. However,
>> as far as I know this is only in the form of a character string. Is it
>> possible to read these events out in more detail (perhaps a structure
>> with information pertaining to the node(s) involved)?
>>
>> Given that, it might be an idea to send out SNMP traps for these too?
>> That way you can see when for instance a disk node dies, or perhaps
>> when a backup is started / completed.
>>     
>
> Have a look at the (recently uploaded) NDB API docs in the MGM API.
>
> http://dev.mysql.com/doc/ndbapi/en/struct-ndb-logevent.html
>
> Each event has different information, but most have all that you would
> need.
>   
>>   
>>   
>>     

-- 
Michel Stam ing.

Software Development Engineer

michel@stripped <mailto:michel@stripped>

Houtweg 29
1251 CS Laren
The Netherlands

t:  	+31 (0)35 548 98 58
f:  	+31 (0)35 531 65 61

www.teleconcept.nl <http://www.teleconcept.nl>

	  	 

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