Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 28, 2003

QUASSI Active/Active Cluster Server

By DatabaseJournal.com Staff

MAK (Muthusamy Anantha Kumar)

It is a fact, that once we setup an Active/Passive cluster and install SQL server on a cluster server, the passive nodes will never be used unless it fails over. The main objective here is to try to make use of the unused resource and equipment, without spoiling the failover concept.


The objective in simple words is to make an Active/Passive SQL Cluster to a Quassi Active/Active SQL Cluster.


Physical Servers SQLBOX1 [], SQLBOX2 []

Virtual Servers VIRTUALBOX1[],


VIRTUALBOX1 has SQLBOX1 as primary node and SQLBOX2 as secondary node.


We assume that an active/passive cluster [VIRTUALBOX1] has already been setup between the physical servers SQLBOX1 and SQLBOX2, and SQL Server has been running smoothly on the VIRTUALBOX1 cluster.


  • Get a new IP address for the VIRTUALBOX2.
  • Get new drives from the SAN for SQLBOX2.
  • Install SQL server on SQLBOX2 as the primary node. Give the virtual IP address for the virtual server.
  • SQL installation will ask for an instance name. Call it SQL1. This will install SQL server instance VIRTUALBOX2/SQL1 on that box.

SQL Server Access:

Now you can access the SQL servers on VIRTUALBOX1 as VIRTUALBOX1 and VIRTUALBOX2 as VIRTUALBOX2/SQL1


Click for larger image

When SQLBOX1 fails over to SQLBOX2, there will be no changes in Virtualbox2, since SQLBOX2 is the active node for it.

When SQLBOX2 fails over to SQLBOX1 there will be no changes in VIRTUALBOX1 since SQLBOX1 is the active node for it.

Hence by creating an Quassi Active/Active cluster server we will be using all of the nodes and its resources. In addition, we will get two failover clustered sql server servers instead of one.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM