Why both MySQL and PostgreSQL?
Why both MySQL and PostgreSQL?
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?
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.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Re: Why both MySQL and PostgreSQL?
Is it possible to just use MySQL for both?
Re: Why both MySQL and PostgreSQL?
Even if it were possible, it wouldn't be supported.
Be sure to check out our Knowledgebase for helpful articles and solutions!