December 30, 2015 at 6:17 am
Hi All
Is it possible to implement load balancing for Active/Active SQL Server 2008 Clustering environment?
Regards,
Nikhil P Desai
December 30, 2015 at 6:22 am
No.
Active-active is a not the same instance and same databases on both nodes. It should be called 'multi-instance clustering', and it's when you have Instance1 with DatabaseA, DatabaseB on node 1 and Instance2 with DatabaseC, DatabaseD and DatabaseE on node 2.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 8, 2016 at 8:09 am
As GilaMonster has already answered no its not possible, what is possible though and whilst its not true load balancing is to mirror \ log ship \ replicate from one instance in one active node to the other instance in the other active node giving you a readable secondary copy of the databases \ tables.
Both of those solutions have their own restrictions which are too lengthy to cover in a forum post, you would also have to consider how would you load balance the applications connecting to perform read \ write actions on the write enabled source databases and read on the other active instance.
Always on Availability Groups in SQL Server 2012 is similar to this approach.
MCITP SQL 2005, MCSA SQL 2012
March 29, 2016 at 12:04 pm
As Gail mentioned, there is no concept of active/active nodes for database(transactional in nature, not static). One node is always a 'Master' or 'Primary' at a time to capture all the transactions. There can be any slaves/secondary that replicates load.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply