5.1 SR1 - NEC Cluster Installation Guide

8/13/2019 5.1 SR1 - NEC Cluster Installation Guide

1/36

Security Center 5.1

Installation Guide for NECCluster

Click herefor the most recent version of this document.
http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdf


2/36

ii genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version

EN.500.071-V5.1.C1(1)

Copyright notice 2011, 2012 Genetec Inc. All rights reserved.

Genetec Inc. distributes this document with software that includes an end-user license agreement and is

furnished under license and may be used only in accordance with the terms of the license agreement. Thecontents of this document are protected under copyright law.

The contents of this guide are furnished for informational use only and are subject to change without notice.Genetec Inc. assumes no responsibility or liability for any errors or inaccuracies that may appear in theinformational content contained in this guide.

This publication may not be copied, modified, or reproduced in any form or for any purpose, nor can anyderivative works be created therefrom without Genetec Inc.s prior written consent.

Genetec Inc. reserves the right to revise and improve its products as it sees fit. This document describes thestate of a product at the time of documents last revision, and may not reflect the product at all times in thefuture.

In no event shall Genetec Inc. be liable to any person or entity with respect to any loss or damage that isincidental to or consequential upon the instructions found in this document or the computer software andhardware products described herein. The use of this document is subject to the disclaimer of liability foundin the enduser license agreement.

"Genetec", "Omnicast", "Synergis", "Synergis Master Controller", "AutoVu", "Federation", the Genetecstylized "G" and the Omnicast, Synergis and AutoVu logos are trademarks of Genetec Inc., either registeredor pending registration in several jurisdictions.

"Security Center", "Security Center Mobile", "Plan Manager", and the Security Center logo are trademarks ofGenetec Inc.

Other trade names used in this document may be trademarks or registered trademarks of the manufacturersor vendors of the respective products.

All specifications are subject to change without notice.

Document informationDocument title: Security Center 5.1 Installation Guide for NEC Cluster

Document number: EN.500.071-V5.1.C1(1)

Document update date: February 24, 2012

You can send your comments, corrections, and suggestions about this guide [email protected] .
http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfmailto:[email protected]?subject=Genetec%20Security%20Center%20Documentation%20Feedback&body=DOC.%20TITLE:%0A%0ADOC.%20NO:%0A%0ACOMMENTS:%0A%0ASPECIFIC%20PROBLEMS:http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/mailto:[email protected]?subject=Genetec%20Security%20Center%20Documentation%20Feedback&body=DOC.%20TITLE:%0A%0ADOC.%20NO:%0A%0ACOMMENTS:%0A%0ASPECIFIC%20PROBLEMS:


3/36

genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version iii

EN.500.071-V5.1.C1(1)

Product documentationSecurity Center includes the following documentation:

Securit y Center Release Notes. Describes the release in detail, including new features, resolved issues,known issues, and limitations.

Securit y Center Installat ion and Upgrade Guide. Describes the prerequisites for installing SecurityCenter, and provides instructions for installing and upgrading Security Center on your system.

Securi ty Center Administrator Guide. Provides all the instructions and conceptual information youllneed to set up, configure, and administer your Security Center system.

Gett ing Started wit h Securit y Desk. A task-oriented introduction to Security Desk that uses real-worldscenarios (viewing a camera, searching/exporting video, and managing alarms) to show new users howto use the basic product features.

Genetec Securit y Desk User Guide. Provides the instructions and conceptual information you need toget started with Security Desk, to monitor and generate reports for AutoVu LPR, Omnicast videosurveillance, and Synergis access control systems.

Securi ty Center Video Unit Configurat ion Guide. Provides the pre-configuration instructions forintegrating video units into Security Center, and any configuration steps required for some video unitfeatures to work.

Securit y Center Port able Archive Player User Guide. Explains how to use the Portable Archive Player toview exported video files.

AutoVu Pat rol ler Release Notes. Describes the AutoVu Patroller release in detail, including newfeatures, resolved issues, known issues, and limitations. AutoVu Hardware Release Notes.Describes the AutoVu Hardware for this release in detail, including

new features, resolved issues, known issues, and limitations.

AutoVu Handbook. Provides AutoVu installers and administrators with a single source of informationabout installing and configuring AutoVu hardware and software.

AutoVu Patrol ler User Guides. Quick reference guides to using Patroller, AutoVus mobile LPR solution.There is a separate user guide for each Patroller installation type (Law Enforcement, City ParkingEnforcement, City Parking Enforcement with Wheel Imaging, University Parking Enforcement, andMobile License Plate Inventory).

AutoVu Connecting the Sharp Camera. Explains how to power up and connect your Sharp. A printedversion is provided in the Sharp box.

AutoVu Connect ing t he SharpX Camera. Explains how to power up and connect your SharpX. A printedversion is provided in the SharpX box.

Plugin User Guides. Introduces you to the plugin features and describes whats new in the currentrelease. It also explains how to install and configure the plugin in Security Center, and how to use it inSecurity Desk.

Where can I find the product documentation?

Product DVD. The documentation is available on the product DVD in the Documentationfolder. Releasenotes and installation guides include a direct link to the latest version of the document.

Genetec Technical Assistance Portal (GTAP). The latest version of the documentation is available fromGTAP.Note, youll need a username and password to log on to GTAP.

Online help. Security Center client applications include online help, which explain how the productworks and provide instructions on how to use the product features. Patroller and the Sharp portal also

include context-sensitive help for each screen. To access the online help, click Help, press F1, or tapthe ? (question mark) in the different client applications.
http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttps://gtap.genetec.com/login.aspxhttps://gtap.genetec.com/login.aspxhttps://gtap.genetec.com/login.aspxhttp://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/https://gtap.genetec.com/login.aspxhttps://gtap.genetec.com/login.aspx


4/36

iv genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version

EN.500.071-V5.1.C1(1)

Technical supportGenetec Technical Assistance Center (GTAC) is committed to providing its worldwide clientele with the besttechnical support services available. As a Genetec customer, you have access to the Genetec Technical

Assistance Portal (GTAP), where you can find information and search for answers to your product questions. Genetec Technical Assistance Portal (GTAP). GTAP is a support website that provides in-depth support

information, such as FAQs, knowledge base articles, user guides, supported device lists, training videos,product tools, and much more.

Prior to contacting GTAC or opening a support case, it is important to look at this website for potentialfixes, workarounds, or known issues. You can log in to GTAP or sign up at https://gtap.genetec.com .

Genetec Technical Assistance Center (GTAC). If you cannot find your answers on GTAP, you can open asupport case online at https://gtap.genetec.com . For GTAC's contact information in your region see theContact page at https://gtap.genetec.com .

NOTEBefore contacting GTAC, please have your System ID (available from the About button in your cli-ent application) and your SMA contract number (if applicable) ready.

Licensing. For license activations or resets, please contact GTAC at https://gtap.genetec.com .

For issues with license content or part numbers, or concerns about an order, please contact GenetecCustomer Service at [email protected] , or call 1-866-684-8006 (option #3).

If you require a demo license or have questions regarding pricing, please contact Genetec Sales [email protected], or call 1-866-684-8006 (option #2).

Additional resources

If you require additional resources other than the Genetec Technical Assistance Center, the following isavailable to you:

GTAP Forum. The Forum is an easy to use message board that allows clients and Genetec staff to com-municate with each other and discuss a variety of topics, ranging from technical questions to technologytips. You can log in or sign up at https://gtapforum.genetec.com .

Technical training. In a professional classroom environment or from the convenience of your own office,our qualified trainers can guide you through system design, installation, operation, and troubleshooting.

Technical training services are offered for all products and for customers with a varied level of technicalexperience, and can be customized to meet your specific needs and objectives. For more information, goto http://www.genetec.com/English/Support/Training .
http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttps://gtap.genetec.com/https://gtap.genetec.com/https://gtap.genetec.com/https://gtap.genetec.com/mailto:[email protected]?mailto:[email protected]?https://gtapforum.genetec.com/login.aspxhttp://www.genetec.com/English/Support/Training/Pages/default.aspxhttp://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/English/Support/Training/Pages/default.aspxhttps://gtapforum.genetec.com/login.aspxmailto:[email protected]?mailto:[email protected]?http://www.genetec.com/https://gtap.genetec.com/https://gtap.genetec.com/https://gtap.genetec.com/https://gtap.genetec.com/


5/36

genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version v

EN.500.071-V5.1.C1(1)

ContentsProduct documentation . . . . . . . . . . . . . . . . . . iii

Technical support . . . . . . . . . . . . . . . . . . . iv

About this guide . . . . . . . . . . . . . . . . . . . . vii

Chapter 1: Before you install

About NEC clustering for Security Center . . . . . . . . . . . . 2

What can fail over? . . . . . . . . . . . . . . . . . . 3

NEC ExpressCluster terminology. . . . . . . . . . . . . . . 3

Minimum server requirements . . . . . . . . . . . . . . . 4

Planning checklist. . . . . . . . . . . . . . . . . . . 5

Chapter 2: Installing Security Center in a NEC ExpressCluster environment

Prepare your servers for clustering . . . . . . . . . . . . . . 8

Install NEC ExpressCluster . . . . . . . . . . . . . . . . 10

Install Security Center server . . . . . . . . . . . . . . . . 11

Chapter 3: Configuring your Security Center NEC cluster

Configure Security Center Server for the cluster . . . . . . . . . . . 14

Configure SQL Server for the cluster . . . . . . . . . . . . . . 16

Configure NEC ExpressCluster X LAN edition . . . . . . . . . . . 21

Create the script files manually . . . . . . . . . . . . . . . 21Create the cluster . . . . . . . . . . . . . . . . . . 23

Testing your cluster . . . . . . . . . . . . . . . . . . 25
http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/


6/36


7/36

genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version vii

EN.500.071-V5.1.C1(1)

About this guideThis guide describes how to install and configure Security Center on a two node(twoservers) NEC mirrored cluster on a Windows Server 2008 operating system.

NOTE The procedures in this guide can be extended to additional nodes.

This guide is written for those responsible for installing Security Center. It assumes you are

familiar with the following concepts and systems:

Genetecs Security Center solution and its architecture

Windows system administration

The concept of clustering and how to install and configure the NEC ExpressCluster XLan Edition for Windows

SQL Server administration and Microsofts SQL Management Studio

This guide is organized into the following chapters:

Chapter 1,Before you installon page 1.

Chapter 2,Installing Security Center in a NEC ExpressCluster environmenton page7.

Chapter 3,Configuring your Security Center NEC clusteron page 13.


8/36


9/36

genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version 1

EN.500.071-V5.1.C1(1)

1Before you installThis section describes what you need to know and do before installing and configuring your

clustered Security Center system.

This section includes the following topics:

"About NEC clustering for Security Center"on page 2

"What can fail over?"on page 3

"NEC ExpressCluster terminology"on page 3

"Minimum server requirements"on page 4

"Planning checklist"on page 5


10/36

2 genetec.com| Security Center 5.1 Installation Guide for NEC Cluster | Download latest version

EN.500.071-V5.1.C1(1)

Before you install | About NEC clustering for Security Center

About NEC clustering for Security Center

Your NEC ExpressCluster X LAN Edition provides synchronous data mirroring betweentwo (or more) servers. Fast application recovery and data protection is ensured in case of asystem failure.

Clustering ensures that your Security Center servers configuration files and database filesfound on one server are mirrored on another server.

A virtual IP address is used to accept incoming client connections. The cluster thenmonitors the active servers hardware and software. If a failure is detected, the cluster

replaces the active server with the standby server so that the system remains online. Clientsdo not know whether the active server or the standby server is managing the system as theyare still connected to the same IP address.


11/36

Before you install | What can fail over?


EN.500.071-V5.1.C1(1)

What can fail over?

Security Center server roles supported for failover with NEC ExpressCluster

Directory role

Active Directory role

Access Manager role

Report Manager role

Archiver role

Zone Manager role

Intrusion Manager role

Omnicast federation role

NEC ExpressCluster terminology

This guide uses the following terms to describe the components of a NEC ExpressCluster:

Term Description

Public network The network hosting the Security Center server and clients.

Private networkAlso known as Interconnect network. The dedicated link connectingthe two clustered servers together.

Active node The clustered server actively managing Security Center.

Standby node The clustered server waiting on standby.

HeartbeatA signal that servers in a cluster send to each other to detecta failure in the cluster.


12/36


EN.500.071-V5.1.C1(1)

Before you install | Minimum server requirements

Minimum server requirements

Your servers should be identical in terms of hardware, operating system, and software.NEC ExpressCluster, SQL server, and Security Center each have their own set of minimumrequirements. This table lists the minimum requirements as a combination of all three:

Component Requirements

CPU and memory Refer to Server hardware requirements in the Security CenterInstallation and Upgrade Guide.

Operating system Refer to the NEC ExpressCluster system requirements located at:http://support.necam.com/EnterpriseSW/EC/XR3/Windows/#LAN.

Disk partitions Each server will need two identically configured disk partitions(apart from your C:\). One for the cluster partition(64 MB RAW) andone for the mirrored partition(40 GB or more NTFS). Thesepartitions should not be on the same physical disk as the operatingsystem and software, so two physical hard drives are required.

IMPORTANT For systems with more than 1,000 entities (cameras,doors, cardholders, etc) three physical hard drives are required for

performance reasons.

Network cards Each server will need two network cards. One to accept externalclient connections and the other for the clusters interconnection.1Gb/s cards are recommended.

NEC Client workstation A workstation needs to be identified as the NEC Client workstation.It will be used for configuration and administration of the cluster.

SQL Server SQL Server 2008 R2 Express is bundled on the Security Center DVD.But for installations where the database size will grow over 10 GB(very rare), two copies of SQL Standard or Enterprise will be needed.

Database management

tool

SQL Management Studio needs to be installed on both servers. Seehttp://www.microsoft.com/download/en/details.aspx?id=22985.
http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://support.necam.com/EnterpriseSW/EC/XR3/Windows/#LANhttp://www.microsoft.com/download/en/details.aspx?id=22985http://www.microsoft.com/download/en/details.aspx?id=22985http://support.necam.com/EnterpriseSW/EC/XR3/Windows/#LANhttp://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/


13/36

Before you install | Planning checklist


EN.500.071-V5.1.C1(1)

Planning checklist

You will need to know the following information before starting your cluster installation.

Cluster component Description Your system

Cluster name Name of the cluster configuration.

Failover group name Name of the failover group

Failover floating IP Static IP address used by clients to access Security Centerservices within the cluster.

Management floating IP Static IP used to access cluster management services.

Virtual computer name Name to be used to access the server (Active or Standby)currently hosting the Security Center services.

Active Node name Name of the active server used in cluster configurations.

Active Node Public IP address Static IP address used in the public IP network.

Active Node Public Subnetmask

Subnet mask used in the public IP network.

Active Node Public Default

Gateway

Default Gateway used in the public IP network.

Active Node Public PreferredDNS server address

Static IP address of the Preferred DNS server in the publicIP network.

Active Node Private IP Static IP address used in the interconnect IP network.

Active Node Private Subnet

mask

Subnet mask used in the interconnect IP network.

Standby Node Name Name used for identification in the cluster configuration.

Standby Node Public IP Static IP address used in the public IP network.

Standby Node Public Subnet

mask

Subnet mask used in the public IP network.

Standby Node Public DefaultGateway

Default Gateway used in the public IP network.

Standby Node Public

preferred DNS server

Static IP address used in the interconnect IP network.

Standby Node Private IP Static IP address used in the interconnect IP network.

Standby Node Private Subnetmask

Subnet mask used in the interconnect IP network.


14/36


15/36


EN.500.071-V5.1.C1(1)

2Installing Security Center in a NECExpressCluster environment

This section explains how to install Security Center in a NEC ExpressCluster environment.


"Prepare your servers for clustering"on page 8

"Install NEC ExpressCluster"on page 10

"Install Security Center server"on page 11


16/36


EN.500.071-V5.1.C1(1)

Installing Security Center in a NEC ExpressCluster environment | Prepare your servers for clustering

Prepare your servers for clustering

Before you begin: Before installing the NEC ExpressCluster software, follow these steps to

prepare the servers.

1 Make sure that each server has two network cards and two physical hard disks.

2 Configure your first hard disk with one partition only. It will be used for your operatingsystem and software.

3 Configure your second hard disk with two partitions. One is called the cluster partition(64 MB raw) and the other is called the data partition (40 GB or more, NTFS). The datapartition will contain Security Centers SQL database files as well as the servers config-uration files. This data will be mirrored between the two servers.

IMPORTANT Not only must the partitions be identical on both servers, but the driveletters assigned must also be identical.

4 Create two folders on the data partition for mirroring:

N:\Genetec Security Center 5.1 ConfigurationFiles

N:\MSSQL\DATA

NOTE In this example N: is the drive letter assigned to our mirrored data partition.

5 If your system has more than 1,000 entities, or requires extensive reporting, a third diskshould be configured with another cluster partition and data partition. SQLs *.ldf fileswill be clustered from one disk and SQLs *.mdf files will be clustered from anotherphysical disk. This step is added for performance stability in larger systems.

6 Install the same operating system on both servers. (See "Operating system"on page 4).

7 In Windows, rename the first network card as Public. This is the network interface

that will accept incoming client connections. Repeat on the second server.8 Rename the second network card as Private or Interconnect. This is for the dedi-

cated interconnection between the two clustered servers. Repeat on the second server.

IMPORTANT The order of the network cards as seen by Windows is significant. The firstnetwork card is assigned to the public network and the second network card to theprivate interconnect.

9 On each server, configure the Publicnetwork card to use the same IP subnet.

10 On each server, configure Privatenetwork card to use the same IP subnet.


17/36

Installing Security Center in a NEC ExpressCluster environment | Prepare your servers for clustering


EN.500.071-V5.1.C1(1)

11 Disable all network card features of the PrivateNIC except TCP/IP version 4 (and, if itappears in the list, the driver).

12 From the command line, test whether the two servers nodes can pingeach other overtheir public interface and over their private interface.


18/36

Installing Security Center in a NEC ExpressCluster environment | Install Security Center server


19/36

Installing Security Center in a NEC ExpressCluster environment | Install Security Center server


EN.500.071-V5.1.C1(1)

Install Security Center server

Before you begin: A Security Center license will be needed for each main server.

After the NEC ExpressCluster software has been installed, you will need to install SecurityCenter Server and SQL Server, first on your active server, then on your standby server.

1 If Security Center will federate with earlier Omnicast video systems, you will need toinstall the appropriate compatibility packs. For more information, see Install Omni-cast compatibility packs in the Security Center Installation and Upgrade Guide.

2 Install Security Center Server and SQL Server. For more information, see Install Secu-

rity Center on a main server the Security Center Installation and Upgrade Guide.3 Launch the Server Admin application and do the following:

a If the server is a Security Center Main Server (hosting the Directory role), apply theSecurity Center license in the Server Admin. For more information, see Activateyour license in the Security Center Installation and Upgrade Guide.

NOTE Two Security Center server licenses will be needed. One for each server.

b In the Server Admin, make sure that the network card binding for the Genetec

Serveris set to Any.c Close the Server Admin and reboot the server.

4 Repeat Step 1to Step 3on the standby server.

5 Using your Config Tool application, login to the active Security Center server to ensurethat the roles you need have been successfully created. For more information, see theSecurity Center Administrator Guide.


20/36


21/36


EN.500.071-V5.1.C1(1)

3Configuring your Security Center NECcluster

This section explains how to configure Security Center once the cluster software, SecurityCenter Server, and SQL Server have been installed.


"Configure Security Center Server for the cluster"on page 14

"Configure SQL Server for the cluster"on page 16

"Configure NEC ExpressCluster X LAN edition"on page 21 "Testing your cluster"on page 25

Configuring your Security Center NEC cluster | Configure Security Center Server for the cluster


22/36


EN.500.071-V5.1.C1(1)

g g y y | g y

Configure Security Center Server for the cluster

You will need to make some changes to Security Center Server for it to be protected with

failover by the cluster. The servers license file must be moved to a non-mirrored folder, andthe configuration files must be moved to a mirrored disk. The Genetec Watchdog servicemust also be modified so that it doesnt try to restart the Genetec Server service.

To move your Security Center servers license file and configuration files for a clustered

environment:

1 On both servers, stop the Genetec Watchdog service and the Genetec Server service.

a Click Start> Control Panel> Administrative Tools> Servicesb Select the Genetec Watchdog service and click Stop Serviceon the toolbar at the top

of the page.

c Select the Genetec Serverservice and click Stop Serviceon the toolbar at the top ofthe page.

d Minimize, but dont close the Serviceswindow.

2 Move the Genetec Servers license file (license.gconfig) from C:\Program Files\Genetec

Security Center 5.1\ConfigurationFilesto the Security Center root folder (C:\ProgramFiles\Genetec Security Center 5.1).

3 Using Notepad, paste the following text into an empty text file:

This file contains four lines. It will point to your mirrored data drive (N: is used in theexample) as the location of your configuration files and your local root folder as thelocation of your license file. If your mirrored data drive is configured differently, adjustthe file with your mirrored drive path.

4 Save the text file with the name ConfigurationPath.gconfigin your Security Center rootfolder (C:\Program Files\Genetec Security Center 5.1)

5 Repeat steps 1-4 on your standby server.

You have just created a supplementary server configuration file called configuration-Path.gconfig. This file tells the server to look in an alternative path for your configurationfiles (the mirrored data drive) and an alternative path for the server license.

The NEC Cluster will monitor and control the Genetec Server service, so you do not wantthe Genetec Watchdog service trying to start or stop the server anymore.

Configuring your Security Center NEC cluster | Configure Security Center Server for the cluster


23/36


EN.500.071-V5.1.C1(1)

To stop the Genetec Watchdog service from controlling the Genetec Server service:

1 Use Notepad to open the file GenetecWatchdog.gconfigfound in the patch C:\ProgramFiles\Genetec Security Center 5.1\ConfigurationFiles

2 Edit the file to include the string:preventServiceRestart="true"

The third line should now read (without any hyphen at the line break):

3 On the active server, move the configuration files from their default path to the newconfiguration folder on your mirrored data partition. See "Create two folders on the

data partition for mirroring:"on page 8.

4 Repeat Step 1to Step 4on your standby server.

5 Start the Genetec Server service on both servers.

Configuring your Security Center NEC cluster | Configure SQL Server for the cluster


24/36


EN.500.071-V5.1.C1(1)

Configure SQL Server for the cluster

To configure your SQL database server for a clustered environment, you must move the

database to your mirrored data partition so that the contents of the database are identicalon the active server and the standby server.

1 On both servers, stop the Genetec Watchdog service and the Genetec Server service.

a Click Start> Control Panel> Administrative Tools> Services

b Select the Genetec Watchdog service and click Stop Serviceon the toolbar at the topof the page.

c Double-click the Genetec Watchdog service and set the Startup Typeto Manual

d Select the Genetec Serverservice and click Stop Serviceon the toolbar at the top ofthe page.

e Double-click the Genetec Server service and set the Startup Typeto Manual

2 In SQL Management Studio, you will need detach all Security Center databases beforethe database files can be moved to your mirrored data partition. Detaching a databaseremoves it from the instance of the Microsoft SQL Server but leaves intact the database,with its data files and transaction log files.

a Open SQL Management Studio and connect to the Security Center databaseinstance (by default the instance name is SQLEXPRESS)



25/36


EN.500.071-V5.1.C1(1)

b Right click on each one of the Security Center databases and select Task > Detach.

3 Move the Security Center *.MDF and *.LDF database files from their default folder(C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA)to the SQL folder on the mirror partition created earlier (N:\MSSQL\DATA).

4 Stop the SQL service on both servers.

5 Using SQL Server Configuration Manager, modify the SQL startup parameters for themaster database on both servers.

a Open your SQL Server Configuration Manager.

b Select SQL Server Servicesin the pane on the left.



26/36


EN.500.071-V5.1.C1(1)

c Right-click on SQL Server (SQLEXPRESS)and select Properties..

d Select the Advancedtab in the SQL Server (SQLEXPRESS) Propertieswindow.

e Modify the field Startup Parametersto point to the new master database path.

In this example we have modified the startup parameters to:

-dN:\MSSQL\Data\master.mdf;-eN:\MSSQL\Data\Log\ERRORLOG;-

lN:\MSSQL\mastlog.ldf

Whereby the field points to the new (mirrored) drive and folder path of our masterdatabase (N:\MSSQL\Data).



27/36


EN.500.071-V5.1.C1(1)

6 Move the master database (master.mdf and master.ldf) for the active server to the SQLfolder on the mirror partition created earlier (N:\MSSQL\DATA). Delete the masterdatabase (master.mdf and master.ldf) on the standby server (it will be replicated fromthe active server).

7 Restart SQL service on both servers.

8 Reconnect SQL Management studio to SQL server for the active server.

9 Re-attach the Security Center databases.



28/36


EN.500.071-V5.1.C1(1)

10 When prompted to point to the database to be attached, use the Addbutton to browseto the new path of your (moved) master database.

IMPORTANT This step needs to be performed on the standby server as well but it is notpossible at this point. Once the cluster configuration has been completed, you will need toforce a failover to the standby server, then connect SQL Management Studio to its SQLserver to re-attach the same databases.

Configuring your Security Center NEC cluster | Configure NEC ExpressCluster X LAN edition


29/36


EN.500.071-V5.1.C1(1)

Configure NEC ExpressCluster X LAN edition

Before the NEC cluster can offer failover protection, you must create two script files, and

use the NEC WebManager to configure the cluster:

"Create the script files manually"on page 21

"Create the cluster"on page 23

NOTE The required script files are called Start.batand Stop.bat. They can be found in the\Toolsfolder of your Security Center installation disk or, downloaded from http://GTPA.genetec.com.

Create the script files manually

1 To prepare your start.bat script, open Notepadand paste the following lines of code:

rem ***************************************

rem * start.bat *

rem ***************************************

IF "%CLP_EVENT%" == "START" GOTO GEN_PROCIF "%CLP_EVENT%" == "FAILOVER" GOTO GEN_PROC

IF "%CLP_EVENT%" == "RECOVER" GOTO EXIT

rem CLUSTERPRO Server is not started

ARMBCAST /MSG "CLUSTERPRO Server is offline" /A

GOTO EXIT

rem ***************************************rem Normal Startup process

rem ***************************************

:GEN_PROC

rem Check Disk

IF "%CLP_DISK%" == "FAILURE" GOTO ERROR_DISK

rem Clear VertX case and remove VertX temp filesIF EXIST "C:\Program Files (x86)\Genetec Security Center 5.1\VertXFileCache"

rmdir /S /Q "C:\Program Files (x86)\Genetec Security Center

5.1\VertXFileCache"

IF EXIST "C:\Program Files (x86)\Genetec Security Center 5.1\VertXTempFiles"

rmdir /S /Q "C:\Program Files (x86)\Genetec Security Center

5.1\VertXTempFiles"

rem Start servicesarmload MSSQL /s /a /r 3 /fov /WAIT 30 MSSQL$SQLEXPRESS

http://www.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://gtpa.genetec.com/http://gtpa.genetec.com/http://gtpa.genetec.com/http://gtpa.genetec.com/http://downloads.genetec.com/SecurityCenter/5.1/SR1/Tools/NECClustering/EN.Security%20Center%20Installation%20on%20NECCluster%205.1%20SR1.pdfhttp://www.genetec.com/


30/36


EN.500.071-V5.1.C1(1)

armload GenetecServer /s /a /r 3 /fov GenetecServer

armload GenetecWatchdog /s /a /r 3 /fov GenetecWatchdog

GOTO EXIT

rem ***************************************

rem Irregular process

rem ***************************************

rem Process for disk errors

:ERROR_DISK

ARMBCAST /MSG "Failed to connect the switched disk partition" /A

GOTO EXIT

:EXIT

2 Save the file in a temporary location like your Windows desktop with the nameStart.bat.

3 To prepare your Stop.bat script, open Notepad and paste the following lines of code:

rem ***************************************

rem * stop.bat *rem ***************************************

IF "%CLP_EVENT%" == "START" GOTO GEN_PROC

IF "%CLP_EVENT%" == "FAILOVER" GOTO GEN_PROC

rem CLUSTERPRO Server is not started

ARMBCAST /MSG "CLUSTERPRO Server is offline" /A

GOTO EXIT

:GEN_PROC

rem Check Disk

IF "%CLP_DISK%" == "FAILURE" GOTO ERROR_DISK

rem ** Stop the Genetech Services **

armkill GenetecWatchdog

armkill GenetecServer

armkill MSSQL

GOTO EXIT

rem ***************************************

rem Irregular processrem ***************************************



31/36


EN.500.071-V5.1.C1(1)

rem Process for disk errors

:ERROR_DISK

ARMBCAST /MSG "Failed to connect the switched disk partition" /A

:EXIT

4 Save the file in a temporary location like your Windows desktop with the nameStop.bat.

After you are done: Keep the two script files aside for the moment. They will be applied tothe cluster later.

You will now need to create the cluster itself with the NEC WebManagerapplication.

Create the cluster

1 Open the NEC WebManageron your cluster management workstation.

2 From the Filemenu, select Cluster Generation Wizard

3 Refer to the planning checklist above ("Planning checklist"on page 5) to configure yournew cluster through the wizard.

To finalize the cluster configuration:

1 Use the NEC ClusterManagerapplication on the workstation used for cluster manage-ment to add the Start scriptand Stop script batch files.

2 Change the Cluster Managers view from Operation modeto Configuration mode.

3 Right-click the failover group and select Add Resource.

The Resource Definition of Group (failover)wizard opens.

4 Select Type: script resource, and click Next.

5 Accept the defaults for dependencies,and click Next.



32/36


EN.500.071-V5.1.C1(1)

6 Accept the defaults for Recovery operations,and click Next.

7 On the Scriptspage, click Addand select your Start.batscript file.

8 On the Scriptspage, click Addand select your Stop.batscript file.

9 Click Finish.10 Right-click Monitors,and select Add Monitor Resource.

11 Add the following Monitors:

IP monitorfor your network gateway.

Mirror connect monitorfor your clustered mirror disk.

Mirror disk monitorfor your clustered mirror disk.

NIC Link Up/Down monitorfor your active server and standby servers public net-work interface.

Service monitor for the Microsoft SQL Server.

Configuring your Security Center NEC cluster | Testing your cluster


33/36


EN.500.071-V5.1.C1(1)

Testing your cluster

To test your Security Center cluster configuration, try the following four failover tests.

Description of task Data transition time

Failover Test #1 - NEC moveoperation

Using the NEC ClusterManager, perform a move operation to switchactive to standby and standby to active. The standby server shouldbecome active and the active should become standby.

10 minutes

Let the servers operate for a period of 30 minutes. n/a

Using the NEC ClusterManager, perform a move operation to revert tothe original configuration.

10 minutes

Failover Test #2 - Windows OS shutdown of Security Center and active server

Perform a standard Windows shutdown of the Security Center andOmnicast Primary servers, failover to Secondary Security Center andOmnicast servers.

5 minutes

Let the Secondary failover servers operate for a period of 30 minutes. n/a

After 30 minutes, bring up the Primary Security Center and Omnicastservers and switch operation back to these servers from the Secondaryservers

5 minutes

Failover Test #3 - Disconnect the Public NIC on the Security Center active server

Disconnect the Public NIC on the Security Center active server.Operations should automatically switch over to the standby server. 5 minutes

Let the secondary failover server operate for a period of 30 minutes. n/a

Reconnect the Public NIC on Security Centers primary server. 5 minutes

Failover Test #4 - Disconnect the Interconnect NIC on Security Center active server used torelay the heartbeat of primary server to secondary (failover) server

Disconnect the network cable on the Security Center primary server usedto relay the heartbeat of the server to the secondary (failover) server;operations should continue to be maintained by the primary server.

n/a

Keep the network cable disconnected for a period of 30 minutes. n/a

Reconnect the network cable on the Security Center primary server; waitfor the SQL database on the secondary (failover) server to get updated.

5 minutes


34/36


35/36


EN.500.071-V5.1.C1(1)

IndexCclustering

NEC clustering, 2configuring

NEC ExpressCluster X LAN edition, 21Security Center for NEC clustering, 14SQL server for NEC clustering, 16

contacting technical support, iv

Ddemo license, acquiring, ivdocument information, ii

documentationSee production documentation

Iinstalling

NEC ExpressCluster, 10

NNEC clustering

about, 2configuring

NEC ExpressCluster X LAN edition, 21Security Center server, 14SQL server, 16

installingNEC ExpressCluster, 10

prerequisitesplanning checklist, 5server requirements, 4

supported roles, 3terminology, 3testing, 25

Pproduct documentation

about, iiiwhere to find, iii

Sserver requirements

NEC clustering, 4

T

technical support, contacting, ivtestingNEC clustering, 25


36/36

Documents

5.1 SR1 - NEC Cluster Installation Guide