Share via

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,364 questions
0 comments
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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,136 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