yes man try use Nagios or Cacti (put it on google)
there is many ways that you can monitor it .. :) i think that Nagios is the best one , you can install a daemon to collect information between the [mysql service] -> Nagios NRPE (Nagios Remote Plugin Executor) on local box -> Nagios box with web reports :) \m/ On 3/13/07, Bing Du <[EMAIL PROTECTED]> wrote:
> 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]
-- -------------------------------------------------- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --------------------------------------------------
