AlwaysOn Availability Group and FCI using CSV

Question

AlwaysOn Availability Group and FCI using CSV

Lijun Zhang

Old Hand

Points: 337
More actions
December 26, 2016 at 9:24 am

#401269

Hi,
I am planning to install a 2 nodes FCI using CSV as the primary replica, and a separate standard alone instance as a secondary replica for reporting.
The official SQL 2014 document states you can setup FCI use CSV, but the following blog says CSV does not support AlwaysOn Group. Start from 0:43:45 in the video.
https://blogs.msdn.microsoft.com/clustering/2014/05/08/deploying-sql-server-2014-with-cluster-shared-volumes/
Has anyone successfully setup AlwaysOn Group with FCI use CSV. I want to know if this is possible, or is there any "gotcha".
Thanks,
Lijun

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 1

Heh... I can't help because I don't do these types of things but I think the use of the abbreviation of "CSV" is hilarious. Only Microsoft would name something other than Comma Separated Values as CSV.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

Lijun Zhang (12/26/2016)
Hi,
I am planning to install a 2 nodes FCI using CSV as the primary replica, and a separate standard alone instance as a secondary replica for reporting.
The official SQL 2014 document states you can setup FCI use CSV, but the following blog says CSV does not support AlwaysOn Group.

What is the issue that you are having? The AG will treat your FCI as one node, so shared storage relating to the FCI shouldn't be an issue.

Always On Availability Groups does not depend on any form of shared storage. However, if you use a SQL Server failover cluster instance (FCI) to host one or more availability replicas, each of those FCIs will require shared storage as per standard SQL Server failover cluster instance installation.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

Lijun Zhang (12/26/2016)
Hi,
I am planning to install a 2 nodes FCI using CSV as the primary replica, and a separate standard alone instance as a secondary replica for reporting.
The official SQL 2014 document states you can setup FCI use CSV, but the following blog says CSV does not support AlwaysOn Group. Start from 0:43:45 in the video.
https://blogs.msdn.microsoft.com/clustering/2014/05/08/deploying-sql-server-2014-with-cluster-shared-volumes/
Has anyone successfully setup AlwaysOn Group with FCI use CSV. I want to know if this is possible, or is there any "gotcha".
Thanks,
Lijun

CSV's are supported in sql 2014 onwards.

I can't think of any reason why they would not be supported at all with AGs.

Traditionally, Availability Group nodes would have local storage. If this is the case and they have no SAN storage presented then CSV's would not be available.

Each node would need the relevant hardware and software to have LUNs presented that are configured as CSV's within the cluster.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉