November 5, 2015 at 11:25 am
Hi All,
We are trying to find best HA/DR solution for our (SQL Sever 2008R2 STD )PRD server.We were thinking to go with Database Mirroring or Failover Clustering.But since Mirroring is not available in newer versions we decided to upgrade to 2014 and go with Always On. We are looking for ALMOST 0 downtime.Any suggestions?
thank you
November 5, 2015 at 4:22 pm
Does SQL Server HA has 0 down solution?
Even in SQL Server 2014 AlwaysON, then failover to secondary node, the application side need to reconnect.
November 6, 2015 at 2:26 am
If you setup always on with a listener you will have a small amount of downtime (milliseconds) when the secondary becomes primary. Most of the time it's not even noticeable.
November 6, 2015 at 5:33 am
Barcelona10 (11/5/2015)
Hi All,We are trying to find best HA/DR solution for our (SQL Sever 2008R2 STD )PRD server.We were thinking to go with Database Mirroring or Failover Clustering.But since Mirroring is not available in newer versions we decided to upgrade to 2014 and go with Always On. We are looking for ALMOST 0 downtime.Any suggestions?
thank you
mirroring is still there in 2014.
you're looking at mirroring, FCIs and AGs. What is it you are trying to mitigate, as they all do something different
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 9, 2015 at 5:55 am
daniel.hughes 66721 (11/6/2015)
If you setup always on with a listener you will have a small amount of downtime (milliseconds) when the secondary becomes primary. Most of the time it's not even noticeable.
The failover from a SQL perspective will barely be noticeable, but all applications with open transactions will return errors and will need to re-establish their sessions.
November 10, 2015 at 4:15 am
Mirroring still exists. Also, MS cannot remove mirroring unless they have a version of HA which will replace Mirroring.
So Mirroring will always be there, albeit, as a poor man's DR solution.
Windows failover provides high availability but not Fault tolerance.
So the question is, what are your requirements? HA or High fault tolerance?
November 10, 2015 at 4:29 pm
MadAdmin (11/10/2015)
MS cannot remove mirroring unless they have a version of HA which will replace Mirroring.
Yep, it's called Basic Availability groups in SQL Server 2016
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply