How to monitor FDB . I read the document which says lot of metrics available in log files or fdbcli -exec ‘status json’ but not clear what and how to parse stats easily every 5 sec. and create dashboard if possible.
Do we have any readymade tools for monitoring FDB. Any easy way to parse the log files or json and send stats to tools like newrelic/graphana?
I am also not clear when reading “monitor metric” in the document which says for example we monitor " Database Availability Percentage" .Where is this stats reported as I checked in json status and also all .xml files under logdir but did not find any such stats.
I read this "what do you monitor " and “monitor metrics” from FDB documentation but I don’ want to spend time in writing python/golang program to parse the json status output , capture these stats every 5 sec and then send it to time series DB or tools like newrelic and then write queries in those tools to draw graphs etc. What i am looking for an easy solution/tool to montior the FDB in production with the metrics suggested to monitor.
Do you have any code/tool to share written in python or golang as a sample ?
Here you go, because I promised Alex privately that I’ll share this. This is what we use in our deployment (which is quite small). No warranty, YMMV, etc. fdb_prometheus_proxy.py · GitHub
This runs as a server that Prometheus can poll, which works for us, but you can adapt to your heart’s content.
thanks very much for sharing this program. I will refer to this and the FDB document to come up with some solution
It actually did roll out recently: Monitored Metrics — FoundationDB 7.1
yes i did read 7.1 document on monitored metrics … i was looking for readymade solution but looks like there is none . The python program provided is a good start to refer so thanks all for the help .