Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AlwaysOn Availability Groups Read-Only Routing Expand / Collapse
Author
Message
Posted Sunday, March 17, 2013 4:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 49, Visits: 178
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
Post #1432040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse