Dropping mysql suport from an instalation

jeff vier jeff.vier at tradingtechnologies.com
Thu Sep 25 21:25:05 CEST 2003


I completely concur.

I'm just sad that it still takes even *some* upper-level config files
(like hosts.cfg and services.cfg - obviously SOME have to be files. 
Like "where-is-the-MySQL-server.cfg").

But, then, I have used and loved MySQL since (I realize now) it sucked.

On Thu, 2003-09-25 at 12:25, Mark Arnold wrote:
> 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?
> 
> 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



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





More information about the Users mailing list