Solved

MySQL Cluster without Load Balancing

Posted on 2011-09-21
2
251 Views
Last Modified: 2012-05-12
Hi all,

My search around the net has so many ambigious articles it's hard to pick apart a good answer. Especially Google indexing them from 2005 is not helpful!

My host came back saying they don't do Load balancing at this time but I thought you can do this without a physical load balancer? They allow purchase of multiple dedicated servers and I was under the impression you can 'software' load balance.

My application will have very few JOIN queries but huge amount of primary key SELECT queries concurrently - hence I'm thinking cluster is best for this.

Any advice and words I can take back to the host is much appreciated as some people charge killing for LB when I don't think I need the hardware quite yet!

Cheers
David

0
Comment
Question by:dolythgoe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
woepwobin earned 500 total points
ID: 36575865
There are software solutions for vrrp or vrrp-like solutions. What OS will you be using?
0
 

Author Closing Comment

by:dolythgoe
ID: 36587352
Sorry, question quickly became out of date as a solution was found - I managed to get a load-balanced setup in the end WITH a load-balancer so apologies there isn't a direct answer to this that developed.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question