Friday, March 9, 2012

High Availability

Hi all,
Our production DB is around 4GB and peaks at around 8000
orders a day. We currently have a active/passive cluster
failover solution. During the holiday season, the quorum
disk for the cluster failed. It unfortunately took a long
time (7-10 hours) to recover. Now, someone is suggesting
that we set up an additional and separate active/passive
cluster, and set up log shipping between the existing
cluster (primary) and the new cluster (secondary).
My concern is that it may take too long to make the
secondary server ready for production. We have
replication running on the server, it could take time to
reconfigure the articles.
What are your concerns over this solution? How did you
set up your server?
http://www.microsoft.com/technet/treeview/default.asp?
url=/TechNet/prodtechnol/sql/reskit/sql2000/part4/c1561.asp
Thanks in advance,
AnnaHi, if you want a high availability solution, you need
spare disk in your storages, even with spare, your Quorum
disk must be in a RAID-1 array.
In your scenario, if your primary server failed, you just
have to change the IP of you secondary server to IP of
your primary server.
And you have to be a nice backup schema.
Cesar Kubo
>--Original Message--
>Hi all,
>Our production DB is around 4GB and peaks at around 8000
>orders a day. We currently have a active/passive cluster
>failover solution. During the holiday season, the quorum
>disk for the cluster failed. It unfortunately took a long
>time (7-10 hours) to recover. Now, someone is suggesting
>that we set up an additional and separate active/passive
>cluster, and set up log shipping between the existing
>cluster (primary) and the new cluster (secondary).
>My concern is that it may take too long to make the
>secondary server ready for production. We have
>replication running on the server, it could take time to
>reconfigure the articles.
>What are your concerns over this solution? How did you
>set up your server?
>
>http://www.microsoft.com/technet/treeview/default.asp?
>url=/TechNet/prodtechnol/sql/reskit/sql2000/part4/c1561.as
p
>Thanks in advance,
>Anna
>.
>

No comments:

Post a Comment