[Hidden-tech] Looking for MySQL cluster guru, low cost 1 or 2 U Linux servers, short term (1 month) server rental

[Michael Giles]

Andy,

I think that's the right mindset to approach this (i.e. a sandbox).  
Obviously it isn't going to be identical to having completely dedicated 
machines, but Amazon is pretty clear about the specs of the various 
offerings, all the way up to 15G of RAM and 4 virtual cores (for only 
$0.8/hr).  And when you are talking about experimenting with up to 24 
machines, the cost savings should be large (compared to buying the boxes 
or a traditional dedicated server lease).  I think issues like IP 
addresses and hostnames will be more of a configuration task than a 
roadblock (i.e. once you start up an instance, it's IP and hostname 
remain constant and you can use various dynamic DNS solutions if you 
want to get fancier with it).  There are a few different places where 
such things are discussed in relation to clusters and EC2 (e.g. 
http://blog.dbadojo.com/2007/08/mysql-51-ndb-cluster-on-ec2.html).

-Mike

Andy Klapper wrote:
> Rich,
>
> When I saw that it was virtual I had some worries on the issues you
> expressed below.  If I cannot setup what I need, that is one thing, on the
> other hand it is so cheap vs. buying ($2k per box vs. $70 per month of
> usage), that it at least seems like a good sandbox to play in.  If nothing
> else I should be able to get "proof of concept" and a general range of
> needed hardware for a lot less up front money.  Right now I'm all about
> reducing up front money.
>
>
> Andy.
>
>
> -----Original Message-----
> From: Rich [mailto:rich at on-the-net.com] 
> Sent: Monday, February 04, 2008 11:17 AM
> To: Michael Giles
> Cc: Andy Klapper; Hidden-discuss at lists.hidden-tech.net
> Subject: Re: [Hidden-tech] Looking for MySQL cluster guru, low cost 1 or 2 U
> Linux servers, short term (1 month) server rental
>
> We have started using EC2 for prototype systems work - and have done a 
> fair bit of Mysql Clustering work - using various setups.
> And I really don't see how EC2 can be used for realistic prototype/bench 
> mark as described in #3.
>
> Two main reasons occur to me:
> 1) Ec2 is not a real machine - it is a virtual machine and I don't see 
> how it can be compared with a similar setup of physical boxes,
> if fact, how can you even determine what is similar
>
> 2) Depending on the exact Mysql clustering method you use (there are a 
> number of alterative methods - note I use lower case cluster,
> not any specific Mysql offering) - there are specific IP and hostname 
> requirements for various load-balancing methods. Again
> EC2 does not have this kind of 'hardware' or system control between 
> machine 'instances'
>
> In short to do a proper benchmark, there needs to be some measure of 
> comparing apples to apples and ec2 to hardware boxes
> is like apples to ducks - not even the same type of creature - IMHO
>
> In my quick opinion anyway,
> Rich
>
> Michael Giles wrote:
>   
>>  Andy,
>>
>> #3 seems like a perfect use of Amazon's EC2 service 
>> (http://www.amazon.com/gp/browse.html?node=201590011).  Essentially, 
>> you get as many dedicated servers as you want and you only pay for the 
>> time that you use them (10 cents/hour).  If you use a server for a 
>> whole month, I believe it works out to about $70.  But if you only use 
>> it for an hour, or a day, you just pay for that fraction.  It is great 
>> for just this type of work (where you want a relatively large number 
>> of machines for a short amount of time).
>>
>> -Mike
>>
>> Andy Klapper wrote:
>>     
>>>   I am looking for help finding:
>>>
>>> 1)  A MySQL cluster guru that I can talk to for an hour or two about 
>>> MySQL
>>> clustering configurations for performance, and redundancy.  Somebody 
>>> with
>>> actual experience with at least five clustered machines only.
>>>
>>> 2)  Recommendations for vendors selling low cost 1 or 2 U Linux servers.
>>>
>>> 3)  I am looking for a low cost way of using 16 to 24 Linux servers 
>>> using
>>> MySQL clustering and custom software for a performance 
>>> test/verification of
>>> concept test.  I doubt that this exists, but I'd like to rent the 
>>> machines
>>> for as little as two weeks to a month.
>>>
>>>
>>> Thanks in advance for any help with any of this questions!
>>>
>>>
>>> Andy.
>>>
>>>
>>> _______________________________________________
>>> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
>>> Hidden-discuss at lists.hidden-tech.net
>>>
>>> You are receiving this because you are on the Hidden-Tech Discussion 
>>> list.
>>> If you would like to change your list preferences, Go to the 
>>> Members   page on the Hidden Tech Web site.
>>> http://www.hidden-tech.net/members
>>>
>>>
>>>
>>>   
>>>       
>> _______________________________________________
>> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
>> Hidden-discuss at lists.hidden-tech.net
>>
>> You are receiving this because you are on the Hidden-Tech Discussion 
>> list.
>> If you would like to change your list preferences, Go to the Members   
>> page on the Hidden Tech Web site.
>> http://www.hidden-tech.net/members
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20080204/015393f6/attachment-0005.html