This message was deleted.
# citrix-vads
Slackbot
09/09/2022, 7:48 PMThis message was deleted.
h
Hal Lange
09/09/2022, 8:10 PMDepends on the sql cluster setup. There are sql clusters that will have a cluster name to use . Sql availabilty clusters will have a listener name while a sql cluster will just have a cluster/instance name
n
newbie1998
09/09/2022, 8:12 PMthey don't have a listener just a sql cluster name
h
Hal Lange
09/09/2022, 8:12 PMProbably not using a sql availabilty group then
Hal Lange
09/09/2022, 8:14 PMCould be setup as a sql cluster. Which would be cluster virtual name
Hal Lange
09/09/2022, 8:14 PMUsually with an instance, but not always
n
newbie1998
09/09/2022, 8:14 PMgot it...but will that will give them high availability ?
newbie1998
09/09/2022, 8:15 PMdon't they really need SQL Always on or SQL Mirroring?
newbie1998
09/09/2022, 8:15 PMI've never created the databases using the cluster virtual name
newbie1998
09/09/2022, 8:15 PMalways sql always on listener or the database server when a mirror is configured
h
Hal Lange
09/09/2022, 8:16 PMNo. Sql clustering has been around for years and predates mirroring and always on. Mirroring has been deprecated, and always on is the same as the availability group I mentioned above
Hal Lange
09/09/2022, 8:16 PMI haven't setup a sql cluster since always on became a thing, but I know it still exists
Hal Lange
09/09/2022, 8:17 PMSql cluster is a MS cluster high availability solution as well
n
newbie1998
09/09/2022, 8:18 PMokay
newbie1998
09/09/2022, 8:18 PMso you are saying
newbie1998
09/09/2022, 8:18 PMi can just do a sql cluster
h
Hal Lange
09/09/2022, 8:18 PMIt is supported
n
newbie1998
09/09/2022, 8:18 PMand specify the sql cluster name when creating the citrix dbs
newbie1998
09/09/2022, 8:18 PMand that is supported
newbie1998
09/09/2022, 8:19 PMand will give me high availability for the databases
h
Hal Lange
09/09/2022, 8:19 PMCorrect. I would check with their dba to make sure it is a sql cluster and using standard port or instance name
n
newbie1998
09/09/2022, 8:19 PMinteresting
h
Hal Lange
09/09/2022, 8:20 PMFind out if sql agent and sql browser are also clustered
n
newbie1998
09/09/2022, 8:20 PMthen why am i only doing sql always on for all of my clients...lol
h
Hal Lange
09/09/2022, 8:20 PMSql always on gives more flexibility, with the redundancy of a cluster and benefits of sql single instances
Hal Lange
09/09/2022, 8:22 PMSql cluster will use shared storage. Sql always on will not
n
newbie1998
09/09/2022, 8:23 PMoh gotcha
newbie1998
09/09/2022, 8:23 PMthanks so much for the clarification!
newbie1998
09/09/2022, 8:23 PMi really appreciate it!
h
Hal Lange
09/09/2022, 8:23 PMNp
Hal Lange
09/09/2022, 8:24 PMBoth have benefits and their own complexity. I prefer always on for many reasons, the main 2 listed above. Cluster will only manage a name and not have to worry about the storage
n
newbie1998
09/09/2022, 8:25 PMi see...so thats why i don't see sql clusters being used a lot anymore
h
Hal Lange
09/09/2022, 8:26 PMIt takes a very strong sql admin to manage a sql cluster. Easier/cheaper to manage the always on groups for most companies
🙌 1
Hal Lange
09/09/2022, 8:29 PMOne last point. With clustering, you don't need to manage accounts across all nodes, don't need to replicate DBs, and have only one sql instance to manage across multiple nodes
Hal Lange
09/09/2022, 8:29 PMBenefits to both.... But depends on what you know and can manage
n
newbie1998
09/09/2022, 8:36 PMall good points Mr Lange! keep them coming.
2 Views