asp.net - Configuring a failover partner for Sitecore -
I'm currently experiencing a really weird (at least for me) problem in a configurator of Fellowserver in Sitkor about.
Environment:
- .NET Framework 3.5
- Windows Server 2008 R2
- IIS 7.5
This is one of my connection string:
& lt; Add name = "master" connectionString = "user id = user; password = password; data source = PRIMARY_SERVER \ INSTANCE, 60000; failure partner = FAILOVER_SERVER \ INSTANCE, 60000; database = sitecoremer" />As you can see, I have configured a failover partner, which accepts the certificate similar to the primary database server.
If I stop the primary database during operation, I'll get a SqlException that says:
The login user has failed for the 'user'Any other request will show the same exception, until AppPool is recycled now the application point for the failover database ...
Do not switch the application itself to the database needed?
The only idea I had something like that, but it sounds great, very dirty and I have not even tested it:
public class failure SQL Database Provider: SqlServerDataProvider {Public FailoverSqlDataProvider (String Connection String): Support (connectionString) {} Secure Override LanguageCollection LoadLanguages () {try {return base.LoadLanguages (); } (Formerly SqlException) {Trace TraceError ("(FailoverSqlDataProvider) An error occurred: {0}", ex.ToString ()); HttpRuntime.UnloadAppDomain (); } Select new language (); }}}} If you are using SQL Server with mirroring, Failover will be automatically if you are using a server server, otherwise you have to switch manually.
You can use a SQL Server Express as a witness server, and there is no one else, then it can run from the webserver the server is available.
Comments
Post a Comment