Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Chat About It!  Separate database for each portal?
Previous Previous
 
Next Next
New Post 4/28/2008 8:47 AM
Unresolved
User is offline Steve Taylor
23 posts
10th Ranked


Separate database for each portal? 

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 9:21 AM
Online now... Chris Hammond
2793 posts
engagesoftware.com
5th Ranked








Re: Separate database for each portal? 

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
Engage Software
St. Louis, MO
314.966.4000


The leading provider of DotNetNuke skinning, training and custom module development.
Official DotNetNuke® Training Provider
 
New Post 4/28/2008 11:43 AM
User is offline Jeff Cochran
1372 posts
6th Ranked


Re: Separate database for each portal? 

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 1:54 AM
User is offline Steve Taylor
23 posts
10th Ranked


Re: Separate database for each portal? 

 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 5:38 AM
User is offline John Mitchell
3854 posts
www.snapsis.com
4th Ranked




Re: Separate database for each portal? 

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.


 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Chat About It!  Separate database for each portal?
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Need Help with your DotNetNuke website?
Jango Studios offers exclusive DotNetNuke Skin Design, Module Development, Web Marketing and Web Hosting.
www.jangostudios.net
Where Every Home is an Investment
Where Every Home is an Investment
www.nestbrokers.com
Faculty of Graduate and Postdoctoral Studies
At the graduate level, the University of Ottawa offers more than 180 graduate certificates, master's degrees and PhDs, as well as interdisciplinary programs such as Women's Studies and Canadian Studies. Many postdoctoral opportunities are available in both the sciences and the humanities. For further information, please consult the site of the Faculty of Graduate and Postdoctoral Studies.
www.grad.uottawa.ca

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP