Proxy for POST update requests

mike mike503 at
Sun Sep 7 23:15:29 MSD 2008

You can set include fastcgi_params on the global http {} level ;)

On Sun, Sep 7, 2008 at 11:35 AM, Chris Savery <chrissavery at> wrote:
> Well, I got this working and it's pretty nice too. I just wanted to post a
> couple notes here in the hope they may help someone else who needs to do
> this.
> relevant config looks like this,
>  location ~ \.php$ {
>             proxy_set_header WhatSlave $host;
>             if ($request_method = 'POST') {
>                 proxy_pass;
>             }
>         fastcgi_pass; include fastcgi_params;
>         }
> Notice I added a set header line. This was because in some cases the master
> server needs to know where the request was proxied from. In some cases it
> needs to do a redirect, eg. secure login. And that set header line causes a
> header to appear in the $_SERVER variable with the HTTP_ prefix. eg.
> HTTP_WHATSLAVE and has value of the host without http prefix.
> Of course, the master server is running mysql replication and the data saved
> during the POST comes back to the slave server pretty quickly. In this setup
> all the GET requests drop through to the fastcgi locally and access the data
> on the slave. The POST requests pas up to modify data on the master. Good
> idea: give the local mysql user only "select" privileges to make sure it
> doesn't nasty up the local data. If you allow altering data locally when
> doing replication you will create big headaches sooner or later.
> Chris :)

More information about the nginx mailing list