Hi,
I'm using 'nginx/1.21.1' for load balancing TCP connection for DBs like Teradata, Netezza, Oracle and MySQL. I'm using stream directive for it as per the guidance 'https://docs.nginx.com/nginx/admin-guide/load-balancer/tcp-udp-load-balancer/' .
Following is my stream configuration (/etc/nginx/nginx.conf)
stream {
log_format timed_combined '$remote_addr - [$time_local] $session_time $msec $status $protocol ua="$upstream_addr" "$upstream_connect_time" "$upstream_response_time"';
access_log /var/log/nginx/access.log timed_combined;
upstream stream_backend_mysql {
hash $remote_addr;
server 192.168.122.251:3306;
server 192.168.122.252:3306;
}
server {
listen 3306;
proxy_pass stream_backend_mysql;
proxy_connect_timeout 1s;
}
}
I'm able to establish connection for mysql in this setup, but when I'm adding the log_format directive nginx is giving following error,
'nginx: [emerg] unknown "upstream_response_time" variable'
My motive is to get metrics for this nginx tcp loadbalancer (like requests per seconds, number of active connections).
Please guide me on this as I'm a newbie in this field.
I'm attaching my nginx.conf for your reference with this mail.
Looking forward for your response.
Thank you in anticipation!
Regards,
Akki_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx