Always On without read only replica

Veena Srinivas 251 Reputation points
2021-02-15T23:55:39.37+00:00

Hello,

If I set up this kind of configuration, does it serve the purpose of HA ?

I have 2 node WSFC, no shared storage.
I have installed SQL 2017 Enterprise on each node.

Node 1 - Primary Server - Read Write.

Node 2 - Secondary Replica - No Read

Synchronous Commit, Automatic Failover.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,136 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee
    2021-02-16T00:14:26.39+00:00

    If I set up this kind of configuration, does it serve the purpose of HA ?

    and

    Synchronous Commit, Automatic Failover.

    Yes, it serves the purpose. Whether or not the cluster can maintain quorum in the event of a node loss is another story. Make sure there is a cluster witness resource.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2021-02-16T02:06:26.757+00:00

    Hi @Veena Srinivas ,

    >If I set up this kind of configuration, does it serve the purpose of HA ?

    Yes, it serves the purpose of HA.

    Readable secondary: No Read – It does not allow any user connections for the secondary replica. It is the default configuration.

    SQL server always on is built upon the Windows Failover Cluster, but we do not require the shared storage between the failover cluster nodes. Each replica maintains its own storage.


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments No comments