Post reply

SQL 2012 Clusertring AlwaysOn- Primary and Secondary Replica

  • April 11, 2014 at 12:26 am

    #285561

    Dear Team,

    I will really appreciate if you could share the role/requirement of primary and secondary replica under SQL Server 2012 AlwaysOn.

    Thanks.

  • April 11, 2014 at 1:21 am

    #1705120

    Refer following link:

    http://www.sqlservercentral.com/articles/FCI/92196/

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 11, 2014 at 1:41 am

    #1705133

    free_mascot (4/11/2014)

    Refer following link:

    http://www.sqlservercentral.com/articles/FCI/92196/

    In addition to Free_Moscot

    there the three part series from Perry Whittle

    SQL Server 2012 AlwaysOn Groups and FCIs Part 1[/url]

    SQL Server 2012 AlwaysOn Groups and FCIs Part 2[/url]

    SQL Server 2012 AlwaysOn Groups and FCIs Part 3[/url]

    Hope it helps

  • April 11, 2014 at 1:57 am

    #1705138

    Dear Team,

    I thank you for sharing a master piece of information. Moreover, i need to differentiate the Role of Primary replica and Secondary replica under SQL 2012 Server alwaysOn.

    Sheeraz

  • April 11, 2014 at 6:13 am

    #1705221

    sheeraz.khan (4/11/2014)

    Dear Team,

    I will really appreciate if you could share the role/requirement of primary and secondary replica under SQL Server 2012 AlwaysOn.

    Thanks.

    Simple really, for each replica you specify the connectivity mode when in the Primary Role and in the Secondary Role.

    When a replica is in the Secondary Role you have the following options

    Readable Secondary = No (no connections allowed)

    Readable Secondary = Yes (all read connections from all client versions)

    Readable Secondary = Read-intent only (only read-intent from later clients)

    When a replica is in the Primary Role you have the following options available. Connections in Primary Role = allow read\write (only read\write, no read only)

    Connections in Primary Role = Allow all connections (all connections)

    These options define how the read only routing will work so need to be configured carefully.

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

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

Viewing 5 posts - 1 through 5 (of 5 total)

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