How can i use two different php-fpm pools depending on url

Question

I would also like to use 2 php-fpm pools.

My directory structure looks like this:

/home/test/index.php
/home/test/contact.php
/home/test/stats.php

document root is:

root /home/test;

When I call the stats.php the pool with the fastcgi_pass 127.0.0.1:9001; should be taken, but all other PHP's (index.php, contatct.php) should use the pool with the fastcgi_pass 127.0.0.1:9000; should be taken.

If I insert this location block every PHP uses the fastcgi_pass 127.0.0.1:9001

location = /stats.php {
       include fastcgi_params;
       fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; 
       fastcgi_pass 127.0.0.1:9001;
}

No matter if I insert it before or after this block

location ~ \.php$ {
    include snippets/fastcgi-php.conf;
    include /etc/nginx/fastcgi_params;
    fastcgi_pass 127.0.0.1:9000;
}

Thanks

Update 12.06.2020:

i have the following in the /etc/nginx/nginx.conf:

map $request_uri $pool {
    "/stats.php" 127.0.0.1:9001;
    default 127.0.0.1:9000;
}

and in the /etc/nginx/sites-enabled/default:

location \.php$ {
    try_files $uri =404;
    include /etc/nginx/fastcgi_params;
    fastcgi_pass $pool;     
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
}

nevertheless all PHP's only use the fastcgi_pass 127.0.0.1:9000

The tip with the map function comes from here: Nginx: How to use a different php-fpm pool depending on url

How must the map function looks like when i want to use stats.php with params? e.g.

stats.php?time=123456&id=1754852

It looks like it doesn't work like this

map $request_uri$is_args$args $pool {
    "/stats.php" 127.0.0.1:9001;
    default 127.0.0.1:9000;
}

Answer 1

A location with a regex needs "~" or "~*", as in

location ~ \.php$ {
  fastcgi_pass $pool;
}

For the map request to work when there are request parameters, one should use the $uri iso. the $request_uri.

map $uri $pool {
  "/stats.php" 127.0.0.1:9001;
  default 127.0.0.1:9000;
}

Alternative would be to use $request_uri and a regex iso. "/stats.php".