2

Is it possible to setup always on QL Server 2016/2017 without windows clustering and domain?

My intention of implementing always-on and secondary replica is offloading the select query from the primary database server. I'm not expert at windows clustering, so I'm looking for an easy solution to implement always-on as I don't need automatic failover.

  • Have a look at log shipping instead of AG's – Greg Mar 19 '18 at 2:05
3

Is it possible to setup always on QL Server 2016/2017 without windows clustering and domain? My intention of implementing always-on and secondary replica is offloading the select query from the primary database server.

Yes, it is possible but will require SQL Server 2017 (I'd also apply the latest CU, which at time of posting is CU4).

Please note that without a domain, SQL Authentication is the only available authentication type and there is also the additional endpoint setup of using certificates.

If you'd like to read more about read-scale availability groups (Not for HA or DR) the Docs articles are a good start. I've also blogged about it when it comes to things like read only routing.

I'm not expert at windows clustering [...]

You really don't have to be since you're not looking for HA or DR. That's my opinion, though, and won't translate well everywhere depending on the resources and familiarity with Windows Server.

  • You can do basic AG groups without a domain on 2016 can't you? – Greg Mar 18 '18 at 21:14
  • @Greg Yes, however basic AGs can't have readable secondary replicas, are only allowed one other replica, and still require clustering, which doesn't meet the OP's requirements. – Sean Gallardy Mar 18 '18 at 22:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.