Timeline for Always on without Listener IP
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 20, 2016 at 18:10 | comment | added | Ali Razeghi - AWS | In that case you will want to use the listener if you have no FCI and also want HA. If you don't want HA you can directly connect to the server but the app will have no way of knowing if the server is down and now it should go to a different IP address/hostname to get the data. Another option is adding a mirroring server and a witness but that is not recommended by me in this scenario, you have AG's which are way better. | |
| Dec 20, 2016 at 16:45 | comment | added | buddinggeek | @SeanGallardy Can you please suggest what can be done in my scenario, as I mentioned these are independent local disks and not shared SAN. Thank you | |
| Dec 20, 2016 at 5:00 | comment | added | buddinggeek | Thank you for the responses. While I understand this would work where there is shared SAN and FCI with no listener, the setup which I mentioned has no shared SAN and disks are independent. Would this configuration still make sense? Kindly clarify. | |
| Dec 13, 2016 at 17:51 | comment | added | Ali Razeghi - AWS | Thanks @SeanGallardy, I was hoping you'd step in when I wrote my last line "We have some FCI/AG MCM's and experts here". The community is lucky to have everyone's expertise here like yours. Good insight, I didn't think of that. | |
| Dec 13, 2016 at 3:47 | comment | added | Sean Gallardy | Just to clear this up (for me), while AGs fail over databases in logical units of AGs - in 2014 there are no database level checks. A database could be offline and the AG will not fail. If you're using an FCI with an AG the unit of automatic failover will be the instance as the FCI takes precedence and AGs won't be able to auto failover. @user2923332 | |
| Dec 12, 2016 at 19:02 | comment | added | Ali Razeghi - AWS | heya updated the question. | |
| Dec 12, 2016 at 19:02 | history | edited | Ali Razeghi - AWS | CC BY-SA 3.0 |
added 536 characters in body
|
| Dec 12, 2016 at 18:58 | comment | added | buddinggeek | We actually had a production issue 2 days back when the log drive on the primary was filled and a fail over did not happen. I was thinking if adding a listener port would increase the HA options on this setup. Also, if there is no Listener doesnt the system perform an automatic failover because FCI is already present? Thanks for the followup! | |
| Dec 12, 2016 at 18:54 | history | answered | Ali Razeghi - AWS | CC BY-SA 3.0 |