Hello sir, I set up Windows Failover Cluster and High Availability (HA) in accordance with your video. Everything is working as it should, but there is one problem: I configured three nodes for HA, two of which are in synchronous mode while the third is in an asynchronous mode. If I shut down the first two, Windows Cluster role will automatically stop functioning, and I won't be able to add the third server with listeners' IP. could assist me
@@TechBrothersIT ok I got it. But wouldn't the cluster's IP be the VIP(load balancer azure)? Another question.., there is some way to create the cluster without the "avaiblity set" ? I ask this because I have 1 sql enterprise out of the avaibility set.. And I would like to create the cluster now that my environment is already in production. Would it be possible ?
Sir, couple things to keep in mind, 1. Node has to be fully prepared to b added in cluster, which isn’t a big deal, however sql server has to installed in cluster mode if you talk about conventional cluster, for AG you can add any sql, any mode any time as long as it’s not already part of another cluster. So yea If you going with AG route, you can add your existing stand alone after you prepare that node for cluster, for conventional cluster(active passive) you have to install sql in cluster mode
PS C:\Windows\system32> import-module failoverclusters PS C:\Windows\system32> clear-clusternode Clear-ClusterNode Are you sure you want to forcefully clean up cluster node [NewServerName]? [Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): Y PS C:\Windows\system32> you can run above re-start it install
man, thank you for including your live troubleshooting, is a great video keep it up!
Hello sir, I set up Windows Failover Cluster and High Availability (HA) in accordance with your video. Everything is working as it should, but there is one problem: I configured three nodes for HA, two of which are in synchronous mode while the third is in an asynchronous mode. If I shut down the first two, Windows Cluster role will automatically stop functioning, and I won't be able to add the third server with listeners' IP. could assist me
How storage will be added on Azure.could please also explain that.
Really helpful.thankyou so much for the video
Hi.. 10.0.0.25 (Cluster IP) Where did you get that IP?
In azure portal, once you get your network, it gives you range of IP you can use.
@@TechBrothersIT ok I got it.
But wouldn't the cluster's IP be the VIP(load balancer azure)?
Another question.., there is some way to create the cluster without the "avaiblity set" ?
I ask this because I have 1 sql enterprise out of the avaibility set..
And I would like to create the cluster now that my environment is already in production.
Would it be possible ?
Sir, couple things to keep in mind, 1. Node has to be fully prepared to b added in cluster, which isn’t a big deal, however sql server has to installed in cluster mode if you talk about conventional cluster, for AG you can add any sql, any mode any time as long as it’s not already part of another cluster. So yea If you going with AG route, you can add your existing stand alone after you prepare that node for cluster, for conventional cluster(active passive) you have to install sql in cluster mode
AG listener IP needs to be load balanced, not cluster IP. It’s bit different in azure
Thank you
PS C:\Windows\system32> import-module failoverclusters
PS C:\Windows\system32> clear-clusternode
Clear-ClusterNode
Are you sure you want to forcefully clean up cluster node [NewServerName]?
[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): Y
PS C:\Windows\system32>
you can run above re-start it install