Rewrite lookup via MySQL table
mike503 at gmail.com
Tue Aug 24 04:25:28 MSD 2010
you could cron a dump of the database into nginx rewrite rules, and
then reload nginx...
otherwise, mysql lookups will block, and most nginx modules are
designed with non-blocking in mind
On Mon, Aug 23, 2010 at 5:22 PM, btafoya <nginx-forum at nginx.us> wrote:
> Any chance I can use a MySQL database table to do a lookup to return the
> url to rewrite to?
> Let me explain the situation first...
> Magento utilizes rewrite rules heavily but does the majority of the
> rewrite within the Front controller. The problem is that it is VERY
> in-efficient and a store with more than 10,000 products is severely
> delay. But, all information is referenced in a table 'core_url_rewrite'
> so my though it so do the lookup first in Nginx and hand off to Magento
> with the non-seo url.
> Any idea/though would be GREATLY appreciated.
> Brian Tafoya
> Prema Solutions
> Current environment:
> Two dedicated servers, one web, one db, both with ridiculous amounts of
> memory and high speed drives.
> php 5.3.3
> Posted at Nginx Forum: http://forum.nginx.org/read.php?2,122977,122977#msg-122977
> nginx mailing list
> nginx at nginx.org
More information about the nginx