Hi
Is it possible in SQLServer to setup an Active/Active cluster between two servers and access the same database
Like Oracle's Real Application Clusters, can this be achieved in sql may be using Federation

On a high level, i would have two sqlservers clustered, and i would federate the database horizontally and share my data across tw
servers different databases. I will have Distributed Partitioned Views which will have a Union ALL of both data and reside on both databases
The application will be smart enough to split the users across the servers and users will hit the servers concerned depending upon wher
the data is

Is this possible or only two different application can work on an Active\Active configuration

thanks a bunc
Marx

Not possible with Microsoft Cluster Server, which follows a shared-nothing
model, meaning that the 'shared' disk is never accessed by more than one
node at any given time.

--
Linchi Shea
linchi_shea (AT) NOSPAMml (DOT) com


"Marx" <marx.subramanian (AT) corporate (DOT) ge.com> wrote

You can create 2 SQL Instances. Each partitioned table will reside in a database in each SQL Instance. The distributed view will read/write data to the correct SQL Instance. If SQLInstance1 is on Node1 and SQLInstance2 is on Node2 you will achieve a degree of load balancing via the distributed views. However, if Node1 fails SQLInstance1 will failover to Node2 and you will now have degraded performance. If you wish to maintain this high availability AND high performance scenario then you need 2 x 2-node clusters. Then if any node fails in either cluster you will maintain the same level of performance even though you now have a reduced level of redundancy. Of course this solution costs a whole lot more..

When ever you design a clustered solution you need to ask your clients if they are prepared to take a reduced level of service (in this case performance) when you loose some of your redundancy (due to a hardware or software failure).

That will work. Managing the DPV is challenging to say the least, but it is
possible.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com