We help IT Professionals succeed at work.

Database Level Load Balancing

523 Views
Last Modified: 2008-03-03
Hi, I work for a SaaS vendor with a great problem to have... lots of growth.  We are currently in the planning phase of our Generation 3 high availability infrastructure.  Currently, we use a combination of MS clustering and redundant equipment in aa active production site with a passive warm DR site receiving data in near real-time using WANSync.  One thing we really want to do is deploy load balancing at the database level.  This(along with other changes) would allow us to have Active/Active production sites rather than Active/Passive, with the expensive DR equipment collecting dust unless we fail over.  Im not talking about Multi-instance or Active/Active SQL clustering, were looking to actually distribute database transactions the same way you might load balance a website.

 So my questions is wed rather buy than build, but there seem to be few or no products on the market which can do this for MS SQL.  GIRDSCALE seems to have the right feature set, but no SQL support.  Any suggestions?
Comment
Watch Question

Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009

Commented:
Oracle.

Microsoft SQL does not support load balanced clusters.  I wanted this feature for an internal farm and I had to go with an Active/Active cluster.
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist
CERTIFIED EXPERT

Commented:
<<So my questions is wed rather buy than build, but there seem to be few or no products on the market which can do this for MS SQL.  GIRDSCALE seems to have the right feature set, but no SQL support.  Any suggestions?>>
There is no such thing as load balancing in SQL Server because it does not have an  separate listenner.  If you want load balancing and databases, use ORACLE...
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist
CERTIFIED EXPERT

Commented:
Oh yeah and do not thrust products which promess load balancing (distributors), they usually are not very reliable products...(tried one once and last..)

Author

Commented:
Finally came acrss this http://www.resonate.com/prod_db_disp.html.  Anyone have any experience with it?

Author

Commented:
Also, I heard back from GridScale, they are working on SQL and ASP.Net support for Q2 next year.
Senior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
I have been attempting to get the Resonate product ordered but they never return any calls so I don't know how reliable they are going to be.

Author

Commented:
Chris, I had the same experience.  It took about 10 days to get a call returned.  Sales guys were a mess, and we never got the follow up they promised.  I crossed the product off our list.  

GridScale is still a distance away from a MS SQL version of the product, but I was able to speak to the CTO, and it sounds like they are on the right path.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.