January 21, 2012 at 8:41 am
Ive read several posts on this here, and am wondering how you can use sql server cluster as active/active to achieve load balancing. Is this possible? Most posts I'm seeing indicate cluster is only used for Hi-Av.
My company's goal is to have 2 database servers (vm nodes) that can feed into one database to manage the large number of front end instances, volume of processes and transactions, etc. Is this possible with SQL Server (cluster)? How would you configure it if this is possible? If not, what would you suggest for architecture? They prefer to use SQL Server (as opposed to ORacle Rac) due to it's better integration with security and lower cost.
Jamie
January 21, 2012 at 8:59 am
No, clustering for SQL is high availability only. What people mean when they say active-active is two different instances with two different sets of database one running on each cluster node.
It's possible to 'scale-out' with peer-to-peer replication, but that's mostly for read-heavy systems or the cost of the replication overwhelms the system.
What kind of volume of transactions are you talking about anyway?
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 21, 2012 at 9:09 am
20+ front ends, 25+ million users
January 21, 2012 at 9:21 am
Running facebook or something?
Something at that scale is going to take some really good architectural design (not just database design) for not only the scalability but also maintenance, recoverability and all that king of thing. Not going to be easy to do, regardless of database system used.
Do you have someone there with experience of running systems (database and app) at that scale?
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 30, 2012 at 3:18 pm
Jamie,
as Gail mentioned clustering for HA only....pear 2 pear has its own complexity and for such a volume might not be the best bet...
Your best bet would to wait for sql 2012 as it comes with read only mirrors which can help do good amount of load balancing, explore that area if it meets ur req...
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply