Howto create SQL HA/DR

[Zahid_Haseeb]

Today we are going to configure a basic scenario the SQL HA/DR.  Veritas Cluster Server HA/DR provide failover of applications and databases within a data center or to remote data centers. In the below activity we try to show the database failover to remote data center.

Environment

SQL Server version = 2005

OS = windows 2003 with SP2

SFHA/DR version = 5.0

Both Clusters have individual ISCSI SANs

Prerequisites

"Two local clusters created"

First Cluster name = Cluster-pri

Second Cluster name = Cluster-sec

"Service Groups name"

SQL Service Group name = SQL

Replication Service Group name = REP

"Cluster-pri Nodes hostnames"

Node-1

Node-2

"Cluster-sec Node hostname"

Node-DR

"Global Cluster IP"

Global Cluster IP of Primary Site(Cluster-pri) = 192.168.253.111

Global Cluster IP of Secondary Site(Cluster-sec) = 192.168.253.222

"IP for Replication between Primary Site(Cluster-pri) and Secondary Site(Cluster-Sec)"

Replication IP of Primary Site(Cluster-pri) = 10.0.0.60

Replication IP of Secondary Site(Cluster-sec) = 10.0.0.59

"Replication Drive configuration"

Primary Site DATA Diskgroup (SAN Drive shared by both Nodes of Primary Site) name = SQL-DG

Primary Site DATA Drive(SAN Drive shared by both Nodes of Primary Site) name and size = SQL-DG-vol "800MB"

Primary Site SRL Drive(SAN Drive shared by both Nodes of Primary Site) name and size = SRL "500MB"

1.) Cluster Configuration Wizard

After installing the SFHA software run the Cluster Configuration Wizard on both Clusters(To create the Cluster) but at the end select the GCO option. See the first attachment for reference

2.) Create Replication Service Group and add IP and NIC resource

Create Replication Service Group and add IP and NIC resource. See second attachment for reference

3.) Create Replication

Create replication between Primary Cluster and Second Cluster using the VEA tool. See third attachment for reference

4.) Copy the VMDG resource to REP(Replication) Service Group

Copy the VMDG resource from SQL Service Group to the REP(Replication) Service Group and later/soon we will delete the VMDG resource from the SQL Service Group. See the fourth for reference

5.) Create vvrRVG resource for REP(Replication) Service Group

Create a resource name vvrRVG under the REP(Replication) Service Group. See the fifth attachment for reference

6.) Link the resources

Link the VMDG, vvrRVG, NIC, IP resource under the REP(Replication) Service Group. See the sixth attachment for reference

7.) Remove VMDG resource and add rvgPrimary

Remove the VMDG resource from the SQL Service Group and add the rvg Primary resource in SQL Service Group. See the seventh attachment for your reference

8.) Make dependency

Make dependency of SQL and REP(Replication) Service Group. See the eight attachment for reference.

9.) Test Local Cluster(Cluster-pri) switch over

Test the Local Cluster(Cluster-pri) switch over. See the ninth attachment for reference

10.) Add Remote Cluster

Add remote cluster so you will be able to switch over the Primary Site Clusters Service Group to the Secondary Site. See the tenth attachment for your reference

11.) Service Group Conversion

Convert the SQL Service Group to Global Service Group. The conversion of Service Group make the Service Group an ability to switch over Global means the SQL Service Group can be switch over from Cluster-pri to Cluster-sec. See the eleventh attachment for reference

12.) Test Remote Switch Over

Test the Remote/Global switch over. See the twelve attachment for your reference

13.) Configure Global HeartBeat

Now configure the Global HeartBeat so that both Clusters(Cluster-pri and Cluster-sec) know the state of each other. See the Thirteenth attachment for your reference 

Now we are able to switch over our SQL database within Primary Site and also to Remote Site.