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: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** 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:[EMAIL PROTECTED] Sent: Wednesday, 14 March 2007 6:31 AM To: mysql@lists.mysql.com Subject: Re: monitor multiple mysql servers with no 3306 access > On 3/13/07, Bing Du <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] >> >> > 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: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
