OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: monitor multiple mysql servers with no 3306 access

From: Logan, David (SST - Adelaide) (David.Loganhp.com)
Date: Tue Mar 13 2007 - 15:07:53 CDT


Hi,

Try MRTG, there are a couple of very good scripts available for monitoring
mysql, it can monitor locally for you without requiring TCP access to the
DB. This allows you to monitor (not on a real time basis though) multiple
databases and provide some nice pictures to spot errors quickly. There are
many options available.

Regards

http://www.google.com.au/search?hl=en&q=%2Bmrtg+%2Bmysql&btnG=Google+Search&
meta=

---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.loganhp.com
**** _/ _/ _/ _/ **** Desk: +61 8 8408 4273
**** _/ _/ _/_/_/ **** Mobile: +61 417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
                                      Australia
i n v e n t
---------------------------------------------------------------

-----Original Message-----
From: Bing Du [mailto:bduiastate.edu]
Sent: Wednesday, 14 March 2007 6:31 AM
To: mysqllists.mysql.com
Subject: Re: monitor multiple mysql servers with no 3306 access

> On 3/13/07, Bing Du <bduiastate.edu> wrote:
>>
>> Hi,
>>
>> Seems like there are quite many MySQL monitoring tools on the Internet.
>> The one I tried today was MONyog http://www.webyog.com/en/. I've also
>> tried a couple of others before, including phpmysqladmin as I was
>> suggested. They require you provide mysql server name and port number.
>> In our situation, we have three or four separate MySQL servers running.
>> Each has 'skip-networking' configured. So mysql don't accept requests
>> coming from outside via network. Each mysql server also runs as web
>> server. 'Localhost' is used for communication between web applications
>> and database server. In this case, how should I monitor our multiple
>> mysql servers remotely? Would anybody advise?
>>
>> Thanks in advance,
>>
>> Bing
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=thiago.lpsgmail.com
>>
>>
> Probably you cant access it from network (remote access), but if you do
> some
> script do interconnect them.. maybe you can get this working :D
>
> Or if you prefer you can enable the tcp/ip socket on a diferent port for
> each instances of mysql running in your box..
>
> :)
>
>
>
>
>
>
>
>
>
> --
> --------------------------------------------------
> Thiago LPS
> C.E.S.A.R - Administrador de Sistemas
> msn: thiago.lpsgmail.com
> 0xx 81 8735 2591
> --------------------------------------------------

Thanks for the reply. I don't think we want to open any port for MySQL
connections. Is it possible to install some local stats collector on each
MySQL server and my central monitor polls each stats collector? So I
don't need to directly connect to mysql. The goal is make minimum impact
on database services. That's just my rough idea. Before I delve into
writing home grown scripts, anybody aware of any such server-client based
monitoring tools or have a better idea?

Thanks,

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=david.loganhp.com


  • application/x-pkcs7-signature attachment: smime.p7s