Hello, we currently use a homegrown apache module, which maps urls to new domains and urls. For this we use a mysql-lookup. There are O (10000) entries in this table. Now we want to replace Apache with nginx (which is currently used as a load balancing proxy to a big zope cluster f?r 400+ Sites).

What would be the best way to achieve the same effect with nginx? We can live with a solution, where the mysql-table is exported once a night, a new nginx include is written and nginx is reloaded. I think it would be bad to port the apache module to nginx, as a mysql-lookup for each request reduces the benefits of nginx.

The lookup can be exact, so we do not need thousands of rewrites via regex.