Print Page - Which database backend?

Title: Which database backend?
Post by: mmorsiani on March 27, 2014, 01:01:17 PM

Hello all,

I'm evaluating NetXMS since version 1.2.11 to substitute our current NMS (Xymon) with NetXMS.

Now I'm ready for the jump to production, but I have a big doubt about what DB backend to use.
In other words when do you suggest to use SQLite? And when do you suggest to NOT use SQLite?
Thanks in advance for your help.

Regards.
Massimo

Title: Re: Which database backend?
Post by: Alex Kirhenshtein on March 27, 2014, 01:54:11 PM

SQLite is mostly for development or really small installations.
All other DB engines are production ready. In most installations we use PostgreSQL, with proper tuning it works pretty good — but decision is usually based on existing infrastructure or DBA experience.
Currently we fully support DB2, Informix, MSSQL, MySQL, Oracle, and PostgreSQL.

Title: Re: Which database backend?
Post by: mmorsiani on March 27, 2014, 02:35:53 PM

Hello Alex,

thank you for your prompt reply.

No doubts now.
I will use PostgreSQL (last release 9.3.4).

Any suggested proper specific tuning for it?

Title: Re: Which database backend?
Post by: Alex Kirhenshtein on March 27, 2014, 03:29:27 PM

Check this presentation: http://www.slideshare.net/xzilla/the-essentialpostgresconf

NetXMS Support Forum

English Support => General Support => Topic started by: mmorsiani on March 27, 2014, 01:01:17 PM