question

ShivkumarMallesappa-3997 avatar image
0 Votes"
ShivkumarMallesappa-3997 asked ShivkumarMallesappa-3997 commented

Always On Failover Cluster Instances (FCI) on existing SQL Server

I have launched three EC2 Windows_Server-2019_SQL_2019_Standard instances. How can I implement Always On Failover Cluster Instances (FCI) on these existing SQL Servers. I can only find details like when you install SQL first time that time only you can choose the Failover Clustering option.

sql-server-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered ShivkumarMallesappa-3997 commented

Hi ShivkumarMallesappa-3997,

For SQL Server standard Edition, there is limitation of 2 nodes within a single Always On failover cluster instance. Please check this doc.
And we cannot convert a standalone instance to a SQL Server FCI. We have to create a new SQL Server FCI, and run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance.
To install FCI, please refer to the tutorial part 1, part 2, part 3, part 4 which might be helpful.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

And we cannot convert a standalone instance to a SQL Server FCI. We have to create a new SQL Server FCI, and run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance.

Thank you, this helps.

0 Votes 0 ·
AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered

Hey,

You will need shared storage to deploy SQL FCI on 3 nodes. You can use either Azure Shared disks or S2D as a shared storage option. Check for more information.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-overview

As an alternative, StarWind VSAN can be used as a shared storage to provide replicated pool to a FCI Cluster. The following article covers the configuration process:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,
Alex Bykovskyi
StarWind Software
Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.