All files from this thread

File Name	File Size		Posted by	Date
nginx.conf	1.9 KB	open | download	awani227	07/20/2021	Read message

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