Solved

MySQL Cluster without Load Balancing

Posted on 2011-09-21
2
247 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now