How To Analyze HaProxy Logs

HALog adalah tool simple namun powerful untuk menganalisa HaProxy log. yuk lets try…

1. Instalasi

   cd /usr/src
   wget http://haproxy.1wt.eu/download/1.5/src/devel/haproxy-1.5-dev11.tar.gz
   tar xzf haproxy-1.5-dev11.tar.gz
   cd haproxy-1.5-dev11/contrib/halog
   make
   cp halog /usr/bin/

2. Get number of requests treated by the server (columns “tot_req”)

   cat /var/log/haproxy.log | halog -srv -H -q |awk 'NR==1; NR > 1 {print $0 | "sort -n -r -k 9"}' |column -t

3. List servers by response time in milisecond (columns “avg_rt”)

   cat /var/log/haproxy.log | halog -srv -H -q |awk 'NR==1; NR > 1 {print $0 | "sort -n -r -k 12"}' |column -t
   

4. List servers by application errors: HTTP status code 5xx (column “5xx”)

   cat /var/log/haproxy.log |halog -srv -H -q | awk 'NR==1; NR > 1 {print $0 | "sort -n -r -k 6"}' | column -t
   

5. List servers errors related by application (prefixed by the backend name)

   cat /var/log/haproxy.log |halog -srv -H -q | awk 'NR==1; NR > 1 {print $0 | "sort -n -r -k 5"}' | column -t
   

6. List URLs by server computation time in milliseconds (column “okavg”)

   cat /var/log/haproxy.log | halog -ut -H -q | column -t
   

7. List URLs by errors (column “err”)

   cat /var/log/haproxy.log | halog -ue -H -q | column -t
   

8. List URLs by missing files: HTTP status code 404 (column “req”)

   cat /var/log/haproxy.log | halog -u -H -q -hs 404 | column -t
   

9. List URLs by number of request(column “req”)

   cat /var/log/haproxy.log | halog -u -H -q | awk 'NR==1; NR > 1 {print $0 | "sort -n -r -k 1"}' | column -t
   

Jangan lupa sesuaikan path log haproxy nya.
untuk cara install dan setting haproxy sendiri ada disini

referensi : https://haproxy-log-analyzer.readthedocs.io/

Jangan diklik!!