AlwaysOn Availability Groups Read-Only Routing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » AlwaysOn Availability Groups Read-Only...

AlwaysOn Availability Groups Read-Only Routing

Rate Topic

Display Mode

Topic Options

Author

Message

ratheesh4sql

Posted Sunday, March 17, 2013 4:16 PM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, March 31, 2013 10:32 AM
Points: 48, Visits: 148

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 »

Permissions