20 messages in com.mysql.lists.clusterRE: MySQL Cluster HA Setup
FromSent OnAttachments
Marco Wertejuk19 Jan 2005 16:38 
Ted Schundler21 Jan 2005 11:54 
Marco Wertejuk21 Jan 2005 13:43 
Mikael Ronström21 Jan 2005 14:46 
Marco Wertejuk21 Jan 2005 15:55 
Casto, Robert21 Jan 2005 16:33 
Alex Davies22 Jan 2005 00:06 
Stewart Smith23 Jan 2005 16:47 
Jesse Erlbaum23 Jan 2005 18:00 
Casto, Robert24 Jan 2005 08:23 
Stewart Smith24 Jan 2005 16:59 
pek...@mysql.com25 Jan 2005 11:45 
Jesse Erlbaum25 Jan 2005 13:59 
Stewart Smith26 Jan 2005 15:37 
pek...@mysql.com27 Jan 2005 00:53 
Per Andreas Buer02 Feb 2005 12:43 
Stewart Smith02 Feb 2005 18:07 
Per Buer03 Feb 2005 00:31 
Eugen Leitl03 Feb 2005 02:40 
Robert Heinzmann03 Feb 2005 10:52 
Subject:RE: MySQL Cluster HA Setup
From:Jesse Erlbaum (jes@erlbaum.net)
Date:01/23/2005 06:00:18 PM
List:com.mysql.lists.cluster

Hi Stewart --

This is easy - as surely you have more than two PCs around. Anyway, a new PC is so cheap these days that in the hours you spend fiddling around trying to get 2 nodes going instead of 3, you could have bought a third machine and be in the "good zone".[2]

[2] The best illustration of this I heard recently was how much it would cost to get online filesystem shrinking of XFS volumes implemented. At the current cost of storage and experienced XFS developers - it would take a couple of months at 120 gigabytes per hour. That's a lot of storage. When trying to save money on hardware, have a good look at this form of argument. Hardware is cheaper than people.

I want to add a factor which is not present in your model, but is definitely in mine: Hosting and maintenance.

I'm working on a system which cannot ever go down. (I imagine that most people considering MySQL clustering are in a similar boat.) As a result, I am using bullet-proof, fully managed hosting. In my case, Rackspace. Each server is costing me roughly between $600 and $900 (USD) per month. At that cost, adding a third server is not a minor factor -- it is a potential deal buster.

Warmest regards,

-Jesse-