Dropping mysql suport from an instalation

[Mark Arnold]

I haven't really looked into this as I said - what kind of data is missing in the database-stored tables?
I'm hoping to get this installed over the weekend on my test system to see whats going on there.

When I went through the configuration files I saw some parameters to enable storing of the various statuses and other data in
db-tables. I don't remember which file that was in - I dont have access to the system right now...
I would guess that you can just uncomment those parameters to deactivate db-data storage and then you should be fine. Especially
since you said that "DB data is absolutely irrelevant".

I am hoping to get some more info on what data is stored in the database vs. what is stored in files only from the developers at
Nagios - any responses ?!?

Thanks,

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: Friday, September 26, 2003 5:11 AM
> To: Mark Arnold; nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] Dropping mysql suport from an instalation
>
>
> 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
>



-------------------------------------------------------
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