How do you implement HA?

Question

Hi,

I'm currently working on HA server implementation on two sites, Location_A and Location_B  which are on a different location and subnets

The current status of implementation.

1. Primary server, APE and SQL located in Location_A

2. Secondary server or the HA is in Location_B, which is on a different subnets

3. There are no HA on APE and SQL server which are both in Location_A

Question.

1.Is this enough to only add the secondary server in location location_B? I wonder if there's a circuit outage and the primary servers only in location_A

2. Should I also considering to add HA for APE and SQL which is currently in Location_A?

3. Or with all budgetary consideration on the two items mention above, is it advisable to install a separate instance in Location_ B.

Thanks much,

lmantonio · Answer

Thanks it is well said.

lmantonio · Answer

Thanks and appreciate your insight.

dhinagar_j · Answer

1.Is this enough to only add the secondary server in location location_B? I wonder if there's a circuit outage and the primary servers only in location_A

Solarwinds Support HA Multi-subnet deployments - Install your backup server software on a server in location location_B , The HA software will ensure everything. For me it is wise decision to have secondary server in location_B

2. Should I also considering to add HA for APE and SQL which is currently in Location_A? .

In terms of Database High availability, Solarwinds suggest MS SQL always-on groups, the same can be achieved across location_A & location_B, but you require to setup a Windows failover cluster with node 1 from location_A & node 2 from location_B at first, The SQL software will ensure the High availability, once it is configured for Always on groups

3. Or with all budgetary consideration on the two items mention above, is it advisable to install a separate instance in Location_ B.

Separate Instance, is not a wise decision unless you dont have good network connectivity between these two location