June 11, 2020 at 3:50 pm
The company I am working with is trying to decide whether to go with SE 2-node always on availability groups or just stick to stand alone servers for their MSSQL databases as they are migrated from earlier versions to 2017 version.
From an earlier thread I know now that if you are just going with one listener between the nodes, if you fail over 1 BAG from primary to secondary then the listener will now point at that node, and application connections to the BAG's on the primary node will no longer work, so all BAG's have to be failed over at the same time.
The developer has some applications that have the server and DB name in his connect strings & seems to think a listener will be needed for every BAG, and with them using SE, that could mean dozens of BAG'S on a single server.
Is it even possible with SqlServer SE to have a DB (BAG) failover from a primary to secondary without it affecting connected applications? How does this work when the connected application has both the server and db name in it's connect string?
Is AOAG is even practical in a Standard Edition environment where there are 20+ databases on a server, given the restrictions it has that EE doesn't have.
thanks in advance.
June 11, 2020 at 6:16 pm
Just my opinion - but I would not utilize an AOAG with Standard Edition for anything other than DR. For an HA solution I would stick with a standard FCI and shared storage across the nodes.
As to your other questions, if you implement an AOAG then the application *must* change its connection. The application either needs to reference the listener - or it needs to specify the partner name (the secondary instance - note: this is available because SE only allows a single secondary for BAG and therefore allows using a database mirroring connection string).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2020 at 2:32 pm
This was removed by the editor as SPAM
June 19, 2020 at 2:33 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply