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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Server ReplicationSQL Server Replication
Previous
 
Next
New Post
9/19/2006 2:13 PM
 

My corporation wants to have two web servers on opposite coasts. We would like the east coast to use the east.orgname.com and the west coast to use the west.orgname.com. Since it is a corporate extranet, both servers will have to be synchronized all the time. I would like to use SQL Server data replication. Is there any documentation on doing anything like this for DNN?

John


Cheers!
John Valentine
http://www.webinnovationsystems.com
 
New Post
9/22/2006 1:11 PM
 

Bueler... Bueler... Bueler...


Cheers!
John Valentine
http://www.webinnovationsystems.com
 
New Post
9/26/2006 10:42 AM
 
HisKid wrote

My corporation wants to have two web servers on opposite coasts. We would like the east coast to use the east.orgname.com and the west coast to use the west.orgname.com. Since it is a corporate extranet, both servers will have to be synchronized all the time. I would like to use SQL Server data replication. Is there any documentation on doing anything like this for DNN?

John

Bueler... Bueler ... Bueler...


Cheers!
John Valentine
http://www.webinnovationsystems.com
 
New Post
9/26/2006 11:10 AM
 

No there isn't any documentation on this except for the web farm document which only partially addresses your scenario.

What you are asking for is pretty complex and has a lot of conditions that need to be weighed and considered before implementation.
A lot of companies pay big money to get consulting done in this area so you may be expecting more then you can get from this forum.

In other words, even though you are involving DotNetNuke in your equation, what you really need is help with SQL Server Replication, Auto-Failover, and Load Balancing.

That being said, I can offer a little advise at a very high level.
The first thing I would consider in your scenario is breaking down DNN into three environments.  One environment does the administration and any new publication activities which can be performed at either end with the opposite end reaching over the WAN.  Then you could use replication to publish this master DB to the other two subscriber environements (one on each end).  The two subscriber environments would be used for read only and could be load balanced any number of ways.  If the environement with the Master DB fails, then you could allow it to stay down for a period of time and only lose administration. 

Of course this is only at a high level, and I am sure it provokes a lot more questions. Unfortunately I do not have a lot of free time, but maybe this will help get you started.

 

 


DotNetNuke Modules from Snapsis.com
 
New Post
9/28/2006 9:24 AM
 

Hey thanks John. Let me start by stating that I appreciate your response and as always you have given solid advice. I do have an extensive plan that involves transactional data replication because both sites need to be able to manage content. My only real concern is that the DNN application uses the portal alias table, and the portal alias table will be overwritten during replication. Also, I am a little concerned that I will not be able to use the DNS server to redirect the users to the proper local instance regardless of which site they happen to be at. For example, if I live on the east coast, but I am visiting the west coast, I want to hit the west coast server; and visa versa. The other begging questions ask: How scalable is this DNS solution? How many web servers can I add as DNS entries? and so on...

My solution also involves clustering at every end-point. So each web server and database are in a high-availability environment.

Finally, I really have no need for load balancing. It is a fairly light application, with limited user access, and bandwidth to spare since all the users will be hitting their local instance.

I also agree with you that the web farm document does contain some of the info I need, but that said, I could not find any information about using transactional data replication with the DNN database device.

I think that I am going to have to set up a lab to test my possible issues and address my concerns. If I am able to address these concerns, I will likely have to create a document that outlines my findings. I will try and post it to the community if/when I finish.

Thanks again,

John


Cheers!
John Valentine
http://www.webinnovationsystems.com
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Server ReplicationSQL Server Replication


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