Page 1 of 1
Why both MySQL and PostgreSQL?
Posted: Tue Apr 02, 2013 4:08 pm
by bcolliver
Can anyone explain, in a nutshell, why NagiosXI uses both MySQL and PostgreSQL? It seems like it would be a lot easier to use a single database backend.
Re: Why both MySQL and PostgreSQL?
Posted: Tue Apr 02, 2013 4:16 pm
by abrist
MySQL stores the core config data (nagiosql) and the historical data (nagios) and is retained for ease of compatibility with ndo and nagiosql. The postgres nagiosxi database is for XI specific settings and data, and is more optimized in postgres.
Re: Why both MySQL and PostgreSQL?
Posted: Fri Jun 07, 2013 1:07 pm
by stevkato
Is it possible to just use MySQL for both?
Re: Why both MySQL and PostgreSQL?
Posted: Fri Jun 07, 2013 2:04 pm
by lmiltchev
Even if it were possible, it wouldn't be supported.