Zabbix proxy minimal to zero writes

[greavette]

Hello Forum,

I'm looking at a way to drop Zabbix proxy servers in some smaller satellite office locations running off a raspberry Pi where I don't need to use a database on the Pi to run Zabbix proxy. I'm hoping to limit the writes that would occur on my Pi if possible.

Any suggestions on where I can start would be greatly appreciated. Thank you.

[SBO]

Hi,

There is a raspbian depot for Zabbix :

http://archive.raspbian.org/raspbian/pool/main/z/zabbix/

You can install a zabbix proxu with sqlite db, that should fit your needs.

[greavette]

Hello SBO and thank you for this reply.

I've been looking at using sqlite for my proxy Zabbix server. And in an effort to further reduce writes I wonder if using an in memory database would work for me? I'm thinking any type of database running on a Pi would greatly reduce the life of my SD card. I'm not an expert so I'm only guessing this is a true statement.

https://www.sqlite.org/inmemorydb.html

I've only just discovered in memory databases so I have no idea how to setup a Zabbix database that would have the necessary bits to be my Zabbix Proxy server every time the Pi was restarted.

Has anyone tried using in memory databases with a Zabbix Proxy server?

[JMAIV]

hi,

I'm happy to read your post. I'm working on the exact same thing as you are. Yet i've already burned about 20 SD-cards on aprox 15 Pi3's with zabbix proxy on it... and i'm convinsed my current 15 cars will burn up in about a month time....

So to save you from doing the same thing: don't buy cheep sd-cards (<5 euro) and don't run mysql as default config....

My plan for now:
- Buying wear-leveling sd-cards (will be shipped to me tomorrow)
More info: http://reprage.com/post/what-are-the...a-raspberry-pi
- move all /var/log and /tmp to a tpmfs (ramdrive)
More info: http://raspberrypi.stackexchange.com...-of-my-sd-card


I was searching for the same awenser as you are... what type of database and what kind of config?

Right now I'm considering PSQL for my proxy and then load the database in the ramdrive fully. Every time my (Pi3) proxy's starts it wil retrive it's client-info and stuff from my zabbix server... there fore an 'empty' databse at every boot won't really hurt me... i think! (I hope!)

It shoud be possible to schedule a cron-job to stop psql, copy the database file and start psql every day or so....

[greavette]

Hello Forum,

I think it would be very beneficial if Zabbix Proxy could run without a database somehow so that remote monitoring using a Raspberry Pi could be used.

If this is not possible, then I've been looking to implement an add on board to my Pi with mSata on it like this one:

http://www.pi2design.com/store/p1/50...ve_Shield.html.

I would then boot from the SSD and install Zabbix Proxy on it to help with the corruption issues.

Any other ideas, I'd very much like to hear them!

Thank you.

[JMAIV]

hi Guys,

I can confirm, the easiest way is to use SQLite and put the database in a tmpfs drive every time you boot. (/tmp for example)

Then , whenever the proxy comes online (even tough wit an empty database) it will populate with content from the zabbix server.

This saves the SD-card massively. Don't forget to disable the swap file to

We have about 30 PI's running now without a problem!

[kloczek]

Whatever you will choose as Linux distribution on you RPi it needs to be running on kernel 4.10 because only in this kernel many things has been changed which makes now Linux stable. Next part of those fixes are fixes related to handle sd card interface which makes whole enough fast in case applications storage interaction.
Now on RPi 3 is possible even use MySQL as db backend an I'm running now on RPi3 3 zabbix proxy which probably would be able to handle to 100 nvps or more.

In case rpm based Linux you can use Fedora rawhide.