Web Wiz Support and Community Forums : Forum on server cluster https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 19:12:42 +0000 Sun, 22 Oct 2006 09:31:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21672 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Forum on server cluster : As far as load balancing SQL server...]]> https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115963.html#115963 Author: WebWiz-Bruce
Subject: 21672
Posted: 22 October 2006 at 9:31am

As far as load balancing SQL server or setting it up as a cluster you would need to consult your SQL Server documentation to see if this can be done as I have never done this.

Instead I run a batch files which creates a backup of the SQL server and then FTP's it to a remote location every few hours, so if the server goes down it can be up and running again as fast as attaching the backup to another instance of SQL Server.

Moving from Access to SQL Server is no easy task, infact it is a right pain, and so far there seems to be no procedure that seems to work in a generic or global way. Every user seems to find a different way, and what seems to work for one doesn't work for another.

I've done this a few times myself and everytime it's taken 2 or 3 hours of trial and error to find a solution that works in each different case.

It seems that moving from Access to mySQL is much easier with allot of people reporting good success with the Access to mySQL database  migration tools available from mySQL.
]]> Sun, 22 Oct 2006 09:31:10 +0000 https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115963.html#115963 <![CDATA[Forum on server cluster : Thank you so much for the quick...]]> https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115955.html#115955 Author: takeos
Subject: 21672
Posted: 22 October 2006 at 2:50am

Thank you so much for the quick reply. I appreciate the tips concerning configuration, but I may need some more advice with respect to avoiding the single point of failure that this approach would introduce. The reason for having more than one server is more one of reliability and easier maintenance (you can do major updates while the other servers run) than of load balancing.
 
Having one main instance of SQL Server is fine. But, is there a way to have a local copy, something like a cache of the main data set, on the web server? Is there a common configuration whereby you use SQL Server Express for this? Something like the forum could use SQL Server Express on the local machine, and SQL Server Express synchronizes with the main server, but if that one is unreachable, things still work (with some acceptable desynchronization during the outage).
 
Also, I saw in other posts that there is no detailed or supported procedure to convert aWeb Wiz Forums Access database to SQL Server format. I'd find one useful, too.
 
Thanks again.
 
]]> Sun, 22 Oct 2006 02:50:55 +0000 https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115955.html#115955 <![CDATA[Forum on server cluster : What you would do in this case...]]> https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115913.html#115913 Author: WebWiz-Bruce
Subject: 21672
Posted: 21 October 2006 at 8:07am

What you would do in this case is have one server that has SQL Server installed. SQL Server 2005 would be fine for this.

Then each of your servers use this one SQL Server database as the backend database.

You would also need to edit the file functions/functions_session_data.asp in Web Wiz Forums and tell the forum engine to use the database to store the forums session data so that the user can be tracked between the load balanced servers.
]]> Sat, 21 Oct 2006 08:07:23 +0000 https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115913.html#115913 <![CDATA[Forum on server cluster : I am a satisfied user of this...]]> https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115909.html#115909 Author: takeos
Subject: 21672
Posted: 21 October 2006 at 3:27am

I am a satisfied user of this software using the Access database option on a single server. I now need to set up a new forum on a site which resides on a cluster of independent servers. For the user it is one host on one and the same IP, but behind the scenes every HTTP access goes to the server that is best at the moment. This means that if I have a database on each server, each forum will be different...
 
I am no Microsoft SQL expert, but I guess it should be possible to deploy a local copy of the data with SQL Express, and have this synchronized with a backend server? So, desynchronization would only occur in case of serious problems on the backend host, but even in that case the froums would still work.
 
Does anybody have experience with such a scenario? Recommended alternatives?
 
Thanks!
 
]]> Sat, 21 Oct 2006 03:27:57 +0000 https://forums.webwiz.net/forum-on-server-cluster_topic21672_post115909.html#115909