Need Advice: Multinode Cluster w/ SQL2K on 4 Nodes and SAN

#21

Ok, now that you understand SQL clustering better, to use my example of an
Historical instance and a current instance - you will need the clients to
connect to two different server (as far as they can tell). Two ODBC
connections per client, but that should not be a big deal.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Johann C" <jcastueras_at_gmail.com> wrote

Quote:

We percieved that the active/active SQL cluster is doing some sort of
load balancing (two database server, one database). But after exploring
the documentation and newgroups, we now know that it can not do that.

The main use for the databases is to load share the back-end processing.
If we would like to implement this, I would think that the two SQL
instances should be able to handle SELECT, INSERT, UPDATE and DELETE
statements to the databases.

Therefore, we would like the two instances to be identical at all times.

Your comment of having a historical (and up-to-date) "server" and a
transactional "server" sounds nice and less complicated.

Any comments on what we are trying to achieved and suggestion on what is
the easiest way to achieving them. Take note that we currently have an
Active/Passive configuration.

Thanks heaps.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Need Advice: Multinode Cluster w/ SQL2K on 4 Nodes and SAN

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Need Advice: Multinode Cluster w/ SQL2K on 4 Nodes and SAN - 02-17-2005 , 05:32 PM