Dynamicweb Globalsettings.aspx and 2 SQL Servers

Posted on 17/08/2010 08:07:05

I have seen that you can configure 2 Databases in /Files/GlobalSettings.aspx file, but what is the other database settings for.
It does not fail-over on the other one if I take the first database offline.

Is it somehow possible to make it failover?

Replies

Nicolai Høeg Pedersen

Posted on 20/08/2010 08:49:45

That setting is made for a 2 datacenter production environment. Meaning 2 sets of webserver/sql-server on 2 different locations with some synchronisation on SQL-Server level and file level. When on webserver 1 in datacenter 1, it uses one SQL-Server setting based on local machines IP, and on webserver 2 in datacenter 2 the other one is used. Banks and insurance companies uses this.

Failover to other SQL-Server should be handled by setting up SQL-Server for it.

It could be possible to build failover into dynamicweb database connection. If there is no connection to the 1st server, change to second server and watch for 1st server to get back online...

Let me know.

Posted on 20/08/2010 11:41:06

So something like this would only be possible with the SQL Server in a Cluster configuration like this?
http://www.flickr.com/photos/48722739@N05/4909980664/

With the same settings like this:

IIS 1 GlobalSettings.aspx Database:

<Password>--password--</Password>

<Type>ms_sqlserver</Type>

<UserName>--username--</UserName>

<Database>--dbname--</Database>

<SQLServer>virtualClusterName\Instance</SQLServer>

IIS 2 GlobalSettings.aspx Database: