Solved

MySQL Cluster without Load Balancing

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Creating and Managing Databases with phpMyAdmin in cPanel.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

820 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