External rewrite engine with mysql

[webbee]

Hi,
I am having domain name and username associated to them in mysql DB, i want to write an external rewrite mapping which will get domain name as the input and give the folder name (or the username ) which is stored in mysql database. I can create the script in PERL but do modrewrite support this, i mean everytime a domain name is called like
http://mydomain1.com is called then mysql will tell it has username abcd1 so it is pointed to http://basedomain.com/abcd1/

similarly for http://mydomain2.com to http://basedomain.com/abcd2/
and so on.
I mean this should occur everytime dynamically and not at the restart of apache and mapping be stored in mysql. Also pl, suggest will this be scalable.
Pl. reply i shall be very grateful.
Thanks,
Abhishek jain

[richardk]

can create the script in PERL but do modrewrite support this

You can use a RewriteMap (the External Rewriting Program bit) if you have access to the httpd.conf file.

Also pl, suggest will this be scalable.

Connecting to the database server each request would probably be slow. Caching the list and using a text map should be quicker.

You may also want to look at mod_vhost_alias.