High Availability

#1

Does anyone have a good starting point for creating a "high availabilty"
solution. I'm working on designing a solution that will allow for us to have
a primary site in Orlando and a secondary site in another state. The system
needs to have data moving in almost real time between the master and
secondary site. I've looked into the sql "active-passive" setup as well as
CA's HA solution, but would like input from someone whose accomplished
something similar.

Thanks,
GTM.

#2

Have you looked at this white paper yet?

http://www.microsoft.com/windowsserv...lustergeo.mspx

--
Cheers,

Rod

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

"Greg" <yaya (AT) yaya (DOT) com> wrote

Quote:

Does anyone have a good starting point for creating a "high availabilty"
solution. I'm working on designing a solution that will allow for us to
have
a primary site in Orlando and a secondary site in another state. The
system
needs to have data moving in almost real time between the master and
secondary site. I've looked into the sql "active-passive" setup as well as
CA's HA solution, but would like input from someone whose accomplished
something similar.

Thanks,
GTM.

#3

another option would be to use an asynchronous replication software that
also does failover.

Async replication is real-time, as opposed to the scheduled Log Shipping
function, which reduces the latency of the data.

And for availability, you can failover similar to a cluster (assuming a
server name, IP and starting services) without the distance limitation.

Check out Double-Take by NSI Software - here is a link to their SQL
whitepaper.
http://www.nsisoftware.com/pro/white/

jason

"Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote

Quote:

Note that one of the considerations for the active/passive GEO Cluster is
that the network connections must be able to provide a maximum guaranteed

round trip latency between nodes of no more than 500

Quote:

milliseconds. The cluster uses heartbeat to detect whether a node is alive
or not responding. These heartbeats are sent out on a periodic basis (every

1.2 seconds). If a node takes too long to respond to

Quote:

heartbeat packets, MSCS starts a heavy-weight protocol to figure out which
nodes are really still alive and which ones are dead; this is known as a

cluster re-group. The heartbeat interval is not a configurable

Quote:

parameter for the cluster service (there are many reasons for this, but
the bottom line is that changing this parameter can have a significant

impact on the stability of the cluster and the failover time). . 500 ms
round-

Quote:

trip is significantly below any threshold to ensure that artificial
re-group operations are not triggered

You may want to research SQL Server Replication/ Log Shipping if you can
have some latency (few secs).

Addtional Information:
=====================

http://www.microsoft.com/technet/pro...n/default.mspx

SQL Server 2000 High Availability Series
Plan and deploy a highly available data center that uses SQL Server 2000.
This guide covers procedures to help you increase availability of your

servers, recover from catastrophic disasters, and prevent and

Quote:

minimize downtime.

SQL Server 2000 Failover Clustering
Understand how failover clustering works and how to implement, administer,
and troubleshoot a failover cluster. Also included: worksheets and

checklists to assist you during installation.

Quote:

Log Shipping in SQL Server 2000 - Part 1
Increase your SQL Server availability by setting up, reconfiguring, and
monitoring log shipping, which is supported in both SQL Server 2000

Enterprise Edition and SQL Server 2000 Developer Edition.

Quote:

Log Shipping in SQL Server 2000 - Part 2
Find out how to change the roles of the primary and secondary servers, how
to fully reverse their roles, and where to place the monitor server for the

most effective monitoring.

Quote:

Replication Overview

http://msdn.microsoft.com/library/de...lover_694n.asp

Typical Uses of Replication

http://msdn.microsoft.com/library/de...intro_6trn.asp

How Replication Works

http://msdn.microsoft.com/library/de...intro_6trn.asp

Planning for Each Type of Replication

http://msdn.microsoft.com/library/de...lplan_82zy.asp

Transactional Replication and Log Shipping

http://msdn.microsoft.com/library/de...ackup_3js7.asp

Microsoft SQL Server 2000: The Types of Replication and When to Implement
Each
http://support.microsoft.com/default...b;EN-US;818714

Introducing New Features in Microsoft SQL Server 2000 Transactional
Replication
http://support.microsoft.com/default...b;en-us;324966

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no
rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit

http://www.microsoft.com/security.

Quote:

Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security

vulnerabilities. The easiest way to do this is to visit the following
websites:

Quote:

http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

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

High Availability

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

High Availability - 06-21-2004 , 02:05 AM

Re: High Availability - 06-21-2004 , 08:37 PM

Re: High Availability - 07-28-2004 , 12:57 AM