Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Separate database for each portal?Separate database for each portal?
Previous
 
Next
New Post
4/28/2008 11:47 AM
 

I wondered if it's possible to have a separate database for each portal in DNN?

If I was going to create 3 different websites, I would probably want to create 3 different databases - one for each site.

I'm new to DNN and apologies if this has been asked and answered many times before.

 
New Post
4/28/2008 12:21 PM
 

That is possible, but it requires running 3 different instances of DNN, meaning you have 3 different directories of files, one for each instance.

I generally recommend going that route if you are setting up portals for different clients.


Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
4/28/2008 2:43 PM
 

Technically they're not portals with separate databases, they're completely separate DNN installations.  And many clients will want this rather than a database shared with others.

Jeff

 
New Post
4/29/2008 4:54 AM
 

Jeff Cochran wrote

Technically they're not portals with separate databases, they're completely separate DNN installations.  And many clients will want this rather than a database shared with others.

Jeff

Yes, I imagine that they will.

What, then is the real point of the ability to create multiple portals, if they all reside within the same database?

I initially saw the multiple portals as a great way to create multiple websites, each mapping onto a different portal. Each with its own domain name, skin and representing a unique business idea. But perhaps that is not the intention?

I can't help feeling it would have been a nice move to separate the host (SuperUser) and admin (for each portal) at the database level. So the main database you create when you install DNN becomes a host database containing perhaps a list of portals each of which has a separate database with its own customers. I imagine that the project has progressed too far for this to be possible now.

I'm new to DNN and don't intend to be too critical of it, since I'm still learning how it works. It's a remarkable peice of work and hats off to Shaun Walker and his team for their achievement. It's just that I'm a little uneasy about combining customers for different businesses in the same database (and the same tables, presumably). How would one move a site to another hosting company, for example - or to a dedicated server if the site became popular - if it was inextricably mixed up with all the other sites, being one of several portals in a single DNN installation?

I take your point that it's possible to install separate DNN's for each site, but then the advantage of being able to create and manage multiple portals looks more like unecessary overhead rather than a big advantage.

 
New Post
4/29/2008 8:38 AM
 

Having multiple portals in one IIS website and DB is fine for non-business/hobby/personal/family websites, or for a case when you want to create a website that does seperation by portal for a single client.
So there are some benefits to having the ability to create multiple portals, but that doesn't mean it is the best thing to do.

You mention moving the different portals to different Databases, but also consider that if your different portals share the same codebase and application space that it is just as "bad" of a sharing scenario as sharing the database. IMO it is actually worse to have them sharing the same application space.  There are many reasons for this:

  • They will not be sand-boxed at the physical file system so access to the file system through FTP can not be granted.
  • They will share the same scheduler background threads which cause redundant processes and lockups.
  • They will share the same IIS configuration which is important for SSL, and many other low level settings that are usually needed to be set differently (IIS7 does make this better).
  • They share the same caching space (both physical and memory).
  • Upgrades will affect all portals at the same time (this could be a good thing, but it is usually bad).
  • One bad module or mis-configuration can bring down all your portals.

Those are just a few but serious issues that I can think of off the top of my head.  So in short having multiple portals can be very nice for a single client, but it is probably best to completely seperate any business clients.


DotNetNuke Modules from Snapsis.com
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Separate database for each portal?Separate database for each portal?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out