[SQL 2012] AlwaysOn Availability Groups Read-Only Routing |
| AlwaysOn Availability Groups Read-Only Routing Posted: 17 Mar 2013 09:16 AM PDT I have setup Always on with four serverServer Role AvilabilityMode Failover Mode ReadabilityModeServer1 - Primary Syncranized Automatic Failover YesServer2 - Secondary Server Syncranized Automatic Failover ReadOnly IntentServer2 - Secondary Server Syncranized Manual ReadOnly IntentServer2 - Secondary Server Asynchranized Manual NoI have given two connection string in application one for Readwirte and other for Readonly access and the same is validatingconnectionString="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=ReadonlyHere 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 |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment