SQL Server Configuration Considerations

Before you install and configure your clusters, it is important to understand the concepts of Active/Standby configuration, and how multiple instances can be set up in a SQL configuration.

SQL Configuration

A configuration is Active/Standby when there is only one master database for each SQL Server, and it is located on a shared or replicated volume. The services run on only one system at a time. The servers are assigned priorities within SIOS Protection Suite which determine the order of failover for a particular hierarchy.

The figure below depicts a single SQL instance installed on a pair of servers. The instance contains two databases, databaseK and databaseX residing on separate volumes. Note that there is a single master database which resides on shared volume X.

When you create the SQL hierarchy within SIOS Protection Suite, you are asked to specify the SQL instance to be protected, and the IP resource that will be used to connect to the database. SIOS Protection Suite then reads the configuration data for that instance and pulls the associated volumes into the hierarchy.

Once the hierarchy is created, it will appear as follows in the LifeKeeper GUI.

Failover

In the event of failure, SIOS Protection Suite brings the SQL Server hierarchy In Service on the backup Server. SQL Server is started on the backup server and it takes over protection of all defined databases as depicted in the figure below.

Multiple SQL Instances

SQL Server can be installed multiple times, which creates multiple SQL instances. SIOS Protection Suite can protect multiple instances of SQL Server. SIOS Protection Suite identifies each instance by the unique name given during SQL installation.

One SQL instance may contain multiple SQL databases. Each instance is protected in a single SIOS Protection Suite hierarchy. Thus, if the SQL instance contains two databases, the corresponding SIOS Protection Suite hierarchy will protect two databases (along with the associated IP and volume resources).

The figure below depicts three SQL instances: SQLServer (the default instance), SQL2, and SQL3. These are installed on a pair of servers, MILES and DAVIS.