Redundant SQL Servers Without Clustering
Is there a way to keep two IIS/SQL servers in synch without clustering?
Have a request to set up two servers in a live server, backup server type of situation. Servers will be Windows 2012 R2 running SQL (not sure of which version) and IIS. I expect they will be running in a VMware environment. At least that would be the preference.
As I said, a cluster is not required. Only requirement from the user is that the data synch every five minutes at most. The switchover to the second server does not even have to be automatic. They are fine with just having two icons, one for the app on each server.
Is there a way to do all of this without a cluster? Or are we just reinventing the wheel? I see there is a MS synch framework, but can it be done more simply than this?
Have a request to set up two servers in a live server, backup server type of situation. Servers will be Windows 2012 R2 running SQL (not sure of which version) and IIS. I expect they will be running in a VMware environment. At least that would be the preference.
As I said, a cluster is not required. Only requirement from the user is that the data synch every five minutes at most. The switchover to the second server does not even have to be automatic. They are fine with just having two icons, one for the app on each server.
Is there a way to do all of this without a cluster? Or are we just reinventing the wheel? I see there is a MS synch framework, but can it be done more simply than this?
bbao
ate the two IIS/SQL servers located at the same site or apart on the Internet? this would determine which approach to go for sync and failover.
ASKER
Same site. Most likely the same server room.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mirroring or Log shipping can be a good solution if the replica doesn't need to be accessed.
If you need to access the replica database, would be for read only or do you also need write access on it?
If you need to access the replica database, would be for read only or do you also need write access on it?
ASKER
Thanks for the replies. The second server needs to be able to take over the full functions of the application. So that would include writing. Whatever solution we use needs to synch both ways, so if the primary servers goes offline for whatever reason and we switch to the secondary, it would have to synch back to the primary.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the information. This will get me started on the solution.