Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Has anyone ever used sqlite as the only database for their zabbix server?

I'll be monitoring a uplink ports on a couple hundred switches and a small number of other services such as radius or http servers.

This will be on an oldish opteron server with 2 cpus and 8gb of ram.

share|improve this question

3 Answers 3

up vote 2 down vote accepted

if you will only monitor single port on those switches, it might even work, especially if you won't be pulling data too often.

keep in mind that scaling up can be non-trivial, sqlite might be unable to handle something like monitoring all the ports on those switches.

cpu & ram specs should be more than enough, but make sure your disk subsystem is as fast as possible.

monitor your cache buffers in zabbix (see manual) and keep an eye on the queue - if it raises a lot, you might have to adjust your config (for example, increase polling intervals), or move to another db.

make sure to use latest stable zabbix version, it should be much better performance wise.

note that zabbix appliance has been released today (http://www.zabbix.com/download.php) - it provides operating system, database and zabbix server preconfigured - maybe that's an easier path for you (though that's just the initial appliance release, not suggested for production use yet). you could use hdd image & install it on your server, then see how it works/doesn't :)

share|improve this answer

I use sqlite for the zabbix proxy with very good results. For server, you absolute must use a PROPERLY TUNED mysql database.

share|improve this answer
    
Do you have any numbers on when SQLite is too slow for Zabbix server? I need to monitor around 10 services once every 5 minutes. I would like to avoid an SQL server for the reasons @chris give. –  Ole Tange Jul 21 at 16:34

Is there a particular reason you want to use sqlite? It's not known to scale very well and is not any faster than mysql or postgres. I just don't see a single reason for such a setup.

share|improve this answer
2  
It reduces dependencies on having properly configured postgres or mysql database + database user + database authentication. –  chris Apr 14 '10 at 17:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.