Dropping mysql suport from an instalation

[Luis-Alberto Garcia]

El Jue 25 Sep 2003 19:25, Mark Arnold escribió:
> Sorry, no advice but rather a question:
> Why do you want to switch "back" to rather "unintelligent" files
> instead of having a high-level data storage like a database? Did you
> encounter any problems with storing the data in the database?
>

DB support sounds good, but unfortunately only a few tables are 
maintained (actually 12 and even less in Nagios 2.0) and without 
historical records!

I am concerned about generating pretty "services availability reports" 
and, for that purpose, the relevant data is NOT in the DB but in 
"nagios.log" flat file (with daily rotation). From this point of view, 
DB data is absolutely irrelevant and do not justified the effort of 
maintaining mysql. Actually I'll not be the Nagios system manager and I 
should keep things as simple as possible. No way I could "sell" MySQL 
support. 

Make sense? If so, how could I get rid of mysql support efficiently and 
with no data lost? I might well try a reinstallation of Nagios without 
mysql support and add then the config and log files previously saved. 
It does not sound very clever, but being new to mysql that's all I can 
thing of, apart from asking for advice to this list.

> I am planning to set up Nagios for our network within the next weeks
> ( if time permits :( ) and I am planning on using database support
> rather than just flat files. It seems that there are many advantages
> to a database: - better performance
> - better scalability
> - easier to use the data independently from nagios in you own scripts
> if necessary (just some SQL-queries rather than having to write a
> full parser)
>
> The only reason I could think of that could be held against going the
> database way is that using the file system might seem a little more
> stable since you have less components that might cause problems
> compared to the db-way (here you have the sockets, db server process,
> maybe even networking issues if the db is on a remote host). But I
> think as long as you keep nagios and the db on the same physical
> server so that network problems will not be an issue, you should be
> really safe. We have been working with mysql for years and never had
> one single problem that was really caused by the database system
> itself as far as I remember. If we had problems at all, it was in a
> remote db-server environment caused by networking issues (DNS
> changes, network down, firewall, etc) or the harddisk crashing - but
> that will kill you anyway, no matter what route you go...
>
> So without having practical nagios experience yet, I would say keep
> the db - move it to the same server you are running the nagios
> process on if it is not there yet).
>
> MARK
>
> > -----Original Message-----
> > From: nagios-users-admin at lists.sourceforge.net
> > [mailto:nagios-users-admin at lists.sourceforge.net]On Behalf Of
> > Luis-Alberto Garcia
> > Sent: Wednesday, September 24, 2003 2:53 AM
> > To: nagios-users at lists.sourceforge.net
> > Subject: [Nagios-users] Dropping mysql suport from an instalation
> >
> >
> > I've decided to drop mysql support from my running nagios
> > installation. Am I right? Hope so.
> > How could I do it efficiently and with no data lost?
> > Where can I get a script to dump the db data into the corresponding
> > template-based files?
> > Any advice? Thanks.
> > --
> > Luis-Alberto García Lucía
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Nagios-users mailing list
> > Nagios-users at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/nagios-users
> >
> > ::: Please include Nagios version, plugin version (-v) and OS when
> > ::: reporting any issue. Messages without supporting info will risk
> > ::: being sent to /dev/null
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
>
> ::: Please include Nagios version, plugin version (-v) and OS when
> ::: reporting any issue. Messages without supporting info will risk
> ::: being sent to /dev/null

-- 
Luis-Alberto García Lucía
Grupo Ingeniería de Software
Tecnologías de la Información
Universidad Autónoma de Madrid
Telf.- 34-912073352 / Fax.- 34-913973914
luis.alberto at uam.es
http://rincon.uam.es/dir?cw=787332153320312

      Nadie tiene libertad para ser libre, sino que,
      al no ser libre lucha por conseguir su libertad. Paulo Freire.

		¡NO A LA GUERRA!


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null