Home › Forums › General Discussion

many website, one setup, many databases

Sat, 12/01/2007 - 21:39 — Anonymous

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?

‹ a8cjdbc - update verision 1.3 Why doesn't anyone use j2ee? ›
  • 880 reads
Sun, 12/02/2007 - 07:00 — Todd Hoff
Todd Hoff's picture

Re: many website, one setup, many databases

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

Mon, 12/03/2007 - 03:24 — atif.ghaffar
atif.ghaffar's picture

Re: many website, one setup, many databases

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.

Mon, 12/03/2007 - 03:27 — atif.ghaffar
atif.ghaffar's picture

Re: many website, one setup, many databases

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><div ?=?><p ?=?> <img ?=?><h1 ?=?><h2 ?=?><h3 ?=?>
  • Lines and paragraphs break automatically.
  • Glossary terms will be automatically marked with links to their descriptions
  • You may link to webpages through the weblinks registry

More information about formatting options

To combat spam, please enter the code in the image.