After two weeks of brainstorming, we have finally migrated:
- 7 #postgresql databases
- with #timescale hypertables
- used by #zabbix
- 1.8TiB
- 5 minutes of downtime
Some databases didn't have hypertables on the source but we needed them on destination.
The workload is now manageable for those databases 🎉
Don't forget to enable and configure Timescale from day 1 if you setup Zabbix running on PostgreSQL. That will be way easier than doing afterwards 👍🏻
https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb
#postgresql #timescale #zabbix
"Your max frequency for CPU 0 is 4KMHz"
Thanks #Zabbix.... thanks for reminding me that I never remember that you try to be more clever than I think you are.
Guess I need a post-processing script or something, that or change up the script which retrieves that value, which I really don't want to have to do.
Recently, we have discovered that some #zabbix databases running on #postgresql were maxing i/o capacity.
We have found out that the housekeeping job, responsible of removing old metrics, was responsible of thousand of DELETE queries. Enabling and configuring #timescale (via Zabbix config) drastically reduced the pressure.
How? By dropping chunks (partitions) instead of deleting rows one by one.
https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb
#zabbix #postgresql #timescale
I wrote a post about troubleshooting #Zabbix agent in @wireshark:
https://majornetwork.net/2023/08/troubleshooting-zabbix-agent-with-wireshark/
My little #homelab is doing great so far 😎
Three systems running currently:
- NUC (Debian): Docker and DNS
- PC (FreeBSD): NAS
- SFF ThinkCentre: Windows Server 2022: HyperV and AD DS
At 45W currently - which is ok.
Quite pleased with it at the moment.
Still have some systems here that I could potentialy run... but the energy cost would go up for sure.
So, for now, this will be it 😉
Also, just set up #Zabbix in vm (HyperV).
#homelab fun! :freebsd: :windows8: :linux:
My last short article "UPS control with NUT, PFSense+ and Zabbix" is online at https://e-mc2.net/blog/ups-nut-pfsense-zabbix/
A new Zabbix template for UPS-NUT monitoring is included/available. #computing #monitoring #pfsense #zabbix #UPS #homelab #sysadmin #hardware
#computing #monitoring #pfsense #zabbix #ups #homelab #sysadmin #hardware
For you #Zabbix and #Wireshark users out there:
The latest Wireshark development snapshots (4.1.0rc0-3242 and newer) have my new Zabbix protocol dissector built-in. Try it out!
nice monitoring #prorail !
“a device did not tell monitoring that it failed so the switch to the backup device did not take place”.
That kind of monitoring is failed by itself. If availability is important, setup a nodata trigger like #zabbix #monitoring does. Every device should at least have a heartbeat. If the heartbeat does not arrive, there probably is an issue and maybe a reason to perform a swith/fail over.
#ProRail #zabbix #monitoring #treinstoring
Issue 75: Teamwork is available now! Order your copy from us to get it faster and get the best price https://www.admin-magazine.com/Archive/2023/75 #sysadmin #MicrosoftTeams #ExchangeServer #Matrix #security #Sandstorm #productivity #cloud #Azure #IoT #phishing #Zabbix #monitoring #OpenCanary
#sysadmin #microsoftteams #ExchangeServer #matrix #security #sandstorm #productivity #cloud #azure #iot #phishing #zabbix #monitoring #opencanary
@Viss I use two tools: Zabbix and Grafana. I use both of these at work and in personal projects alike. Can recommend 👍 #zabbix #grafana #observability
#zabbix #grafana #observability
There I made a #thing! Be gentle please. @nlnetlabs #Unbound Stats in #zabbix and #grafana without any third party tools. 🥳
#thing #unbound #zabbix #grafana #selfhosting #monitoring #statistics
Well, this is pretty cool! So, #zabbix, let's analyze the #unbound #log, too. :allthethings:
This little second-hand 10 bucks #fujitsu machine I've bought a little while ago is running perfectly smooth and has so much more potential.
#zabbix #unbound #log #fujitsu #homelab #selfhosting #monitoring
@augustine I've frankensteined my healthcheck to trigger unbound-control every minute to write the stats to a file which I process using a #zabbix active agent. I created some (nah, many 😹) dependent items which are preprocessing the log lines via #regex to get the values proper for #grafana. The dashboard is completely created by myself but really nothing special at all. It shows everything I need to know and I just ❤️ it.
I just left it as it is, it's working great so far. I'll may tackle promtail again some day.
There are #unbound #statistics now!
#unbound #statistics #homelab #grafana #zabbix