it might be a good abstraction layer. Not sure how DB-specific table
maintenance tasks would be handled (e.g. vacuuming Postgres tables after
a large # of deletes).
I also wonder about performance hits. The decision between using MyISAM
or InnoDB tables might be more of a non-issue if an abstraction layer is
used.
Comments/ideas?
Sébastien Barbereau wrote:
> Just adding my two cents here:
> The question of wether to use InnoDB or MyISAM, or MYSQL rather than
> PGSQL comes down IMHO to the question of your DB admin. I had mixed
> reports on performance with InnoDB and/or PGSQL, and I feel more
> comfortable with MySQL as I never had problems with it. On the other
> hand, InnoDB foreign key support is really nice considering the ndodb
> table structure.
>
> What would maybe be more interresting (for the community) is rather than
> stick to a specific database kind, use an abstraction layer in the ndo
> module. Therefore one could use whatever database you wish : mysql,
> pgsql and why not oracle or sybase? I don't think it really mathers to
> Nagios what kind of DB we are using (it should not).
>
> This could have a course some "performance" drawbacks in terms of query
> optimization ...
>
> Seb.
>
> On 8/20/07, *Hendrik Bäcker* > wrote:
>
> Hi Kevin,
>
> Kevin Menard wrote:
> >
> > I'd highly recommend using InnoDB. Actually, I'd recommend using
> > PostgreSQL, but it's not my intention to start a flame
> war. Given the
> > critical nature of the data being logged, I'd ensure data
> consistency with
> > InnoDB tables.
> >
>
> Looking at my MySQL based NDO DB with 7000+ Service Checks I can see
> tons of inserts every second.
>
> I've only heard that PostgreSQL might be better in performance and for
> this huge amount of data.
>
> I also do not want a flame war too, but I would just like to know what
> other people are thinking in the manner MySQL vs. PostgresQL.
>
> Up to now I can say that the MySQL Process on my nagios server is eating
> up the cpu's and I am thinking about to test it with a postgresql.
>
> I am not a DB engenieer so please don't ask about my config params like
> different kind of tunings
>
> Regards
> Hendrik
>
Ethan Galstad,
Nagios Developer
---
Email: [email protected]
Website: http://www.nagios.org
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]