• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

Database Level Load Balancing

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?
0
Satuittech
Asked:
Satuittech
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
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.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Oh yeah and do not thrust products which promess load balancing (distributors), they usually are not very reliable products...(tried one once and last..)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SatuittechAuthor Commented:
Finally came acrss this http://www.resonate.com/prod_db_disp.html.  Anyone have any experience with it?
0
 
SatuittechAuthor Commented:
Also, I heard back from GridScale, they are working on SQL and ASP.Net support for Q2 next year.
0
 
Ted BouskillSenior Software DeveloperCommented:
The lack of load balancing for SQL is actually a source of pain for Microsoft.  It hurts them in Enterprise sales.  If there was a quick easy solution they would jump on it.  Sadly the best they could come up with was Active/Passive instance pairs or mirroring (IMHO I think was meant to replace the dangerous and frustrating Replication!).
0
 
ChrisMorelandCommented:
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.
0
 
SatuittechAuthor 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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now