Using UNICOM Intelligence Interviewer with a SQL Server cluster
UNICOM Intelligence Interviewer can be used with an active-passive SQL Server cluster configuration. This is an SQL Server cluster in which only one instance of SQL Server is running on one of the physical servers in the cluster. The other physical servers do nothing apart from waiting to take over should the primary node fail.
Active-passive SQL Server cluster configuration
UNICOM Intelligence Interviewer cannot be used with an active-active SQL Server cluster configuration (that is, where SQL Server is running on both nodes of a two-way cluster, with each copy of SQL Server acting independently).
Each SQL Server in the cluster has its own virtual name and virtual TCP/IP address. The name and address is shared by both servers in the cluster, so when UNICOM Intelligence Interviewer is configured to write to a clustered SQL Server it uses the virtual name as the SQL Server name. If the primary server fails, a failover procedure is initiated which transfers control to the secondary SQL Server. The effect on respondents is as follows:
▪Interviews running when failover occurs continue as normal. Respondents should not be aware of the failover. Data for these respondents continues to be written to the interview cache file in the shared cache directory. The data in the cache file is written to the database when the connection to SQL Server is restored.
▪Respondents who try to start a new interview receive an error message: “Unable to service request”.
When the failover procedure finishes and the server connections are re‑established, new interviews can start, and data is written directly to the project’s database on the second SQL Server computer.
The failover procedure might last several minutes (the exact amount of time depends on the number and sizes of the databases on SQL Server, and how active they are); during this time clients and applications cannot access the SQL Server, so there might be a short downtime.
See also
