How to use two servers for wildcard subdomain?

When different subdomains are hosted in different servers

[ebloggy]

I have set up my DNS, such that *.mydomain.com points to my server. When users on my site signs up for an account, they get username.mydomain.com

From my server, a .htaccess file would redirect the username.mydomain.com to www.mydomain.com/username/

However, when the time comes that I start running out of disk space on one server, I would add another server (perhaps for load balancing to). How should I go about configuring my DNS/.htaccess so that when a subdomain is typed in, Apache knows which server to retrieve the user's files from?

Thanks in advance.

[edited by: ebloggy at 5:05 am (utc) on Oct. 12, 2004]

[jdMorgan]

Apache mod_proxy could be used to let another server handle some of those requests.

Jim