...
In order to provide a fully automatic fail-over using Sql Server Mirroring, the following components are required:
Two instances of Connexion, running on two separate physical machines.
- An automatic fail-over deployment of SQL Server.
- A fail-over capable switch/router.
The simplest hot fail-over topology requires three physical machines. Two machines each have Connexion and SQL Server, and a third machine is required as a witness server for SQL Server replication. The witness role does not require any system resources, and so can be served by an existing server with a few spare cycles:
| Info |
|---|
More information on configuring Sql Server mirroring can be found on the Microsoft website here: Setting Up Database Mirroring (SQL Server). There is a good YouTube video with step-by-step instructions here YouTube Step-by-Step setup of Sql Server Mirroring. |
Creating a Cluster
Install Sql Server
...