Active/Active Cluster.

Hi everyone,
We have the following setup:
Windows 2003 Server Enterprise edition Cluster with 2 nodes. SQL Server 2000
Enterprise edition Virtual Server1 - currently Active/Passive Cluster.
Shared storage and Quorum drive on SAN.
Database1 on Virtual Server1.
The goal is to set up a reports Database wich will server as a mirror(but
not exact mirror, because it will keep archive data as well) for Database1.
Currently we consider the following proposition:
We want to set up another database(Database2). Our Application will be
writing the same data to both Database1 and Database2(not necessarily at the
same time).
As data gets out of date it will be removed from Database1(but not from
Database2). Database2 is intended to be used for reports(intensive queries).
Would it be a good solution to set up an Active/Active Cluster(another
Virtual Server with the Active/Passive nodes swapped).
If yes, could you provide detailed information(or references/URLs to it)
regarding the implementation - what needs to be done and what are the steps
to follow.
If no, could you propose alternative solutions.
Best Regards.
Sezgin Rafed
I am not sure I have even to go on, no memory requirements, usage hours,
etc. You can indeed create another instance and run it on the current node
or the second node. You can also add a 3 node since you are running on
Windows Server 2003.
With that said, unless unavoidable, I like to stay away running instances on
each node. I like to have a spare at all times.
The setup steps are the same as the default node, except you have to name
the instance.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Sezgin Rafed" <anonymous@.anonymous.com> wrote in message
news:%23ia3zHl6EHA.1204@.TK2MSFTNGP10.phx.gbl...
> Hi everyone,
> We have the following setup:
> Windows 2003 Server Enterprise edition Cluster with 2 nodes. SQL Server
> 2000
> Enterprise edition Virtual Server1 - currently Active/Passive Cluster.
> Shared storage and Quorum drive on SAN.
> Database1 on Virtual Server1.
> The goal is to set up a reports Database wich will server as a mirror(but
> not exact mirror, because it will keep archive data as well) for
> Database1.
> Currently we consider the following proposition:
> We want to set up another database(Database2). Our Application will be
> writing the same data to both Database1 and Database2(not necessarily at
> the
> same time).
> As data gets out of date it will be removed from Database1(but not from
> Database2). Database2 is intended to be used for reports(intensive
> queries).
> Would it be a good solution to set up an Active/Active Cluster(another
> Virtual Server with the Active/Passive nodes swapped).
> If yes, could you provide detailed information(or references/URLs to it)
> regarding the implementation - what needs to be done and what are the
> steps
> to follow.
> If no, could you propose alternative solutions.
> Best Regards.
> Sezgin Rafed
>
sql