Skip to main content

Q: Cluster: Two Win 2008 R2 Sys for files with single MS SQL 2008 Web Edition

I recently asked a question on the DNN forum and thought to share it here as well, it's not a blog entry but hopefully from here I might get some other comments which may or may not be available on DNN and it may help me in setting up other solutions besides DNN.


******************************************

Hi,

We have setup a environment for:
Two Windows 2008 R2 Server with 12 GB of memory and 2 CPU's
Single MS SQL Server 2008 Web Edition
Once the cluster sync is enabled the files from first server will be sync to the server two, but both servers web config sql connection string will  point to the single sql server.

The traffic to the servers is handle by least connection method and point the domain on the correct server.

We have already tested the solution and the server one and server two are both working good as well as the resolution of the domain is working out good, but what I want to know is have I made any mistake in setting up the environment in this way? Will there be any issue when it comes to cache files or system files or the GUID's that DNN creates?

The restrictions in place will be that only server one can be editable/updated and there will be a 20 or 30 or even 60 min delay in sync of the servers. The editors and admins will use the specialized sub domain of the server one to make there updates to the web site, and it will be there responsibility to make sure that they are not using the full domain path in linking or referencing a image, file or a page.

Is there any draw back from my setup? what will be the issues? Will I face any kind of setup issues besides the ones I mentioned above?

Any suggestions or thoughts are appreciated.
Even if you don't have a comment please post if you like this method or dislike it.

Thank you,
Wasay
******************************************

Comments

Popular posts from this blog

Completed UiPath - RPA Developer Advance Training

After a month of training, with late nights and weekends I have completed the UiPath RPA Developer Advance Training.

The Level 1 Foundation Training pretty much covered all the basics of Desktop studio and workflows, only draw back was I started with the default foundation course which was for 2016, and all document reference links where pointing to 2016 version. I didn't understand it during the foundation training and kept switching to 2018 version document/page.

Only after completing the Foundation course that I realized, I was suppose to have started with the 2018 version of Level 1 Foundation Training, but as it was optional I didn't have to retake the 2018 version, the 2016 was good enough for moving to level 2.

The Level 2 Orchestrator 2018.3 Training as good. It gave good understanding of Queue's, Jobs, and schedules and I was able to complete the level two much faster then the level 1.

The Level 3 UiPath Advanced Training was bit tough as it involved the assignme…

Working hours in six months to a year

I usually try to look for how many hours I have worked on a given project and what hours that I  spend on learning or network management tasks.

Below I have added some hours calculation, after finding the breakdown by months from Berkeley website.


Credit: http://controller.berkeley.edu/payroll/payroll-system-pps/pps-training-materials/number-working-hours-month

2017Working hours six months (Jan 1st - Jun 30th): 
130 days x 8 hours =  1040 hours


Working hours six months (Jul 1st - Dec 31th): 
130 days x 8 hours =  1040 hours

Working hours for the year:
1040 hours + 1040 hours = 2080 hours
MonthWorking Days in the monthMonthly Working Hrs1/2 of working hrsMidpoint of working days in the monthDates of HolidaysJanuary22176888 a.m. 1/172,16February20160808 a.m. 2/1520March2318492Noon 3/1631April20160808 a.m. 4/17May2318492Noon 5/1629June22176888 a.m. 6/16July2116884Noon 7/174August2318492Noon 8/16September2116884Noon 9/154October22176888 a.m. 10/17November22176888 a.m. 11/1610,23,24December21168…