« nginx: high performance smpt/pop/imap proxy | Main | Strategy: Efficiently Geo-referencing IPs »
Saturday
Dec012007

many website, one setup, many databases

Hi,

I will need to host abound 500-1000 websites, all of them use drupal,
What I thought was, to make all of these websites point to a single setup of drupal and make them run from there.

I thought of using different databases for each website..

Do you think it'll work? Is there a better way to go about it?

Reader Comments (3)

There's quite a bit of multisite setup discussion at http://drupal.org/search/node/multisite.

December 31, 1999 | Unregistered CommenterTodd Hoff

Create central database that keeps data about which site points to which host.

For example:
site-a.com -> server1
site-b.com -> server2
site-c.com -> server2
site-d.com -> server1

perhaps in the beginning it might seem like over-kill but it will pay off when you want to move your sites databases from other server to another.

December 31, 1999 | Unregistered Commenteratif.ghaffar

PS: And store that information on cache instead of hitting the central meta-db each time.

December 31, 1999 | Unregistered Commenteratif.ghaffar

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>