Hardware & Software advice for my situation.

[Eddriks]

Hello everybody, first of all, sorry for my "bad" english, I'm french, I hope you'll understand my request .

I'm a trainee in a french web-hosting society, and I'll install Zabbix to monitor the entire infrastructure of the society.

I'm testing Zabbix 1.8.1/2 since 15 days ago in Virtual environment, and I'm glad about all my test i've done.

The infrastructure of the society is about 140 hosts (Unix/Linux in 95%), and 40 to 60 Items per hosts (~7000 items in total).

I've one Dell poweredge 860 with 4go Ram & Intel Xeon (dual core) @ 2.40GHz, this is the server who will handle Zabbix + SGBD.



-- My first question is :

if this server will "hold the load" of Zabbix + SGBD for this infrastructure ?

-- Second :

What's the better choice for the SGBD for Zabbix ? Mysql or Postgres 8.X ?

Thank you very much for any reply provided.

best regards,

Ps: hope that my english was not so bad .

[simonc]

-- Second :
What's the better choice for the SGBD for Zabbix ? Mysql or Postgres 8.X ?

MySQL is better

[Eddriks]

MySQL is better

Thanks Simonc for your reply!
any argument for this advice ?

Mysql have a better support of big DB than postgres ?

thanks

[simonc]

MySQL avec innodb est parfait pour Zabbix. Tu pourras customisé la conf facilement pour avoir de très bonnes perfs.
Mysql permet également les dumps à chaud pour les sauvegardes.
Je n'ai personnellement jamais testé zabbix avec un postgres mais j'avais lu par-ci par-là (notamment ce post : http://www.zabbix.com/forum/showthre...ly+inefficient) qu'il fallait faire souvent des vacuum & cie... donc pas très pratique.

Sinon pour ton serveur, il tiendra la charge sans problème. Depuis la version 1.8, les perfs ont nettement été améliorées.
J'ai à peu près le même matos que toi avec moins de RAM et mon serveur passe son temps à ne rien faire

[Eddriks]

Thx simonc !

any another opinion ?

[Eddriks]

little up !

[alixen]

Hi,

I agree with simonc.

This is our Zabbix setup :
Number of hosts : 115
Number of items : 5165
Number of triggers : 2374
Required server performance, new values per second : 20.2273

It is happily running in a VM with 1Gb RAM and 1 allocated CPU (2.8 GHz).
We use Mysql with InnoDB. Its setup needs a little bit of tuning (as any heavy duty database) but it has excellent performance.

Bon courage
Alixen

[Eddriks]

Thanks for your advice .

so, i'll install my zabbix in prod' on my server .


Eddriks.