February 11, 2019 at 8:52 pm
For 2 node cluster setup, my understanding is the i need to configure two different servers as part of one cluster name. So the server name would be technically the cluster name right? It does need two physical IP address right?
Also, when i move the databases from standalone sql server to the 2 node cluster node, the name of the SQL server name would be cluster name right? Please advise?
Does Always on will come any closer to redundancy and load balancing, i know it's more of replacing the mirroring and better DR solution.
Thanks
February 12, 2019 at 1:34 am
There are two kinds of AlwaysOn technology. One is AlwaysOn FCIs, and one is AlwaysOn Availability Groups. The answer to your question largely depends on which one you mean. It sounds like you're referring to FCIs, but I can't be sure.
February 13, 2019 at 5:35 pm
Sorry i wasn't clear. I was referring to AlwaysOn FCIs.
February 17, 2019 at 11:56 pm
AlwaysOn FCI's isn't worth it with 2 node cluster...you're adding more complexity to deal with. I would suggest play simple with 2 standalone nodes clustered with AlwaysOn AG and you should be fine.
February 21, 2019 at 10:59 am
Typically, for an Always-On setup, you will need: 1) Cluster name + IP 2) Nodes with IPs 3) AG Names with IPs 4) Listener Names with IPs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply