AlwaysOn Availability Groups Read-Only Routing

• Ratheesh4sql

  SSCommitted

  Points: 1811

  More actions

  March 17, 2013 at 4:16 pm

  #275299

  I have setup Always on with four server

  Server Role AvilabilityMode Failover Mode ReadabilityMode

  Server1 - Primary Syncranized Automatic Failover Yes

  Server2 - Secondary Server Syncranized Automatic Failover ReadOnly Intent

  Server2 - Secondary Server Syncranized Manual ReadOnly Intent

  Server2 - Secondary Server Asynchranized Manual No

  I have given two connection string in application one for Readwirte and other for Readonly access and the same is validating

  connectionString="Data Source=192.168.1.1\SQL;Initial

  Catalog=DBNAME;User

  ID=XXXX;Password=XXXX;" providerName="System.Data.SqlClient"

  connectionString="Data Source=192.168.1.1\SQL;Initial

  Catalog=DBNAME;User

  ID=XXXX;Password=XXXX;" providerName="System.Data.SqlClient"

  Aplication Inetent=Readonly

  Here i have two doubts.

  1. Using second connection string which server wil be active for read only ( server2 or server3 ? or Both)

  2. If anything happend in my second server inbetween the trasaction what wil happend ?

  3. If failover comes to second server is it first server will automatically will readyonly load ?

  Thanks in advance