You can use this architecture of Genetec Mission Control™ deployment when you have a dedicated SQL server or SQL cluster.
Deployment architecture: Running SQL on separate server
To distribute the Incident Manager role and SQL load between two servers, deploy Genetec Mission
Control™ as follows:
- Server 1: Security Center Directory and Genetec Mission Control™
- Expansion server: Incident Manager role, RabbitMQ
- Server 3: SQL
For information on SQL server permissions, see Assigning SQL permissions on remote SQL server
The SQL Server Express edition included with Genetec Mission Control™ does not support SQL clustering. However, failover clustering for SQL server high availability can be configured with SQL Server Standard or Enterprise editions.