Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HA options


HA options

Author
Message
The_SQL_DBA
The_SQL_DBA
SSC Eights!
SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)

Group: General Forum Members
Points: 808 Visits: 935
Hello Guys,

We are discussing the implementation of HA for a software that runs on SQL 2008 R2. Our preferred HA option is Database Mirroring but, unfortunately the vendor currently does not support automatic redirect of the application to a new host name so mirroring may not work. The vendors preferred HA option is Clustering but, we are not a cluster shop. We want this db server to be physical only and the max size would be around 250 GB and is a mission critical system.

Can you guys please suggest any other alternatives to clustering? If not, what are the questions I need to ask the vendor so we come up with the best configuration for this HA setup. Really not against Clusters so if we have to we will go for it, but not without checking our options.

Thanks a lot for your help in advance.

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
george sibbald
george sibbald
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6352 Visits: 13687
does the vendor support using a DNS alias in the connection string? If so and automatic failover is not vital to you you can still use mirroring in high performance mode or high safety without automatic failover

---------------------------------------------------------------------
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24255 Visits: 37978
You can't can't specify the failover partner in the connection string? That's how we did it for the PeopleSoft HR and Finance systems at a previous employer.

No changes to the actual application.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
The_SQL_DBA
The_SQL_DBA
SSC Eights!
SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)

Group: General Forum Members
Points: 808 Visits: 935
Thanks for the replies folks.

@George - I am not sure if they support DNS alias, but if they do it will be awesome as Mirroring is our go to HA option.

@Lynn - The last conversation I had with the vendor of this finance software, I was told there is no support for failover partners, so they recommend clustering because it uses a single virtual cluster name. Now, the OS team is not really impressed with having forced to go to clusters (VM being not an option). So, I am out here looking for suggestions before we purchase the hardware.

Anything new in SQL 2012/Windows 2012 that may help here?

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24255 Visits: 37978
The_SQL_DBA (2/20/2013)
Thanks for the replies folks.

@George - I am not sure if they support DNS alias, but if they do it will be awesome as Mirroring is our go to HA option.

@Lynn - The last conversation I had with the vendor of this finance software, I was told there is no support for failover partners, so they recommend clustering because it uses a single virtual cluster name. Now, the OS team is not really impressed with having forced to go to clusters (VM being not an option). So, I am out here looking for suggestions before we purchase the hardware.

Anything new in SQL 2012/Windows 2012 that may help here?


That's just it, the connection string for the SQL Native Client handles the connections to the principal and failover systems, not the application. When we did it for PeopleSoft, there were NO CHANGES to the application itself.

Check out this page: http://msdn.microsoft.com/en-us/library/ms130822(v=sql.100).aspx

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
The_SQL_DBA
The_SQL_DBA
SSC Eights!
SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)

Group: General Forum Members
Points: 808 Visits: 935
Lynn - Thanks for the quick link. I will get with the vendor just so they don't say we don't support it later on, as that would not go well with the management. But, for now I have a good feeling this would be something we can implement along with DB Mirroring. Keep you posted.

Thanks again guys.

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search