[ale] Source for Inexpensive, Quiet, Low-Power, rackmount server?

Ron Frazier (ALE) atllinuxenthinfo at techstarship.com
Tue Oct 16 16:10:43 EDT 2012


Derek,

This is not specific to your query, but you might want to check 

twit.tv/twich - This week in computer hardware podcast - a great source for hardware info

and

pcper.com - Pc Perspectives - another great source for hardware info, often quoted on twich.  Check out their leaderboard for ideas on system building at different price levels.

Sincerely,

Ron


Derek Atkins <derek at ihtfp.com> wrote:

>JD,
>
>Before I respond inline I want to point out that I think you missed the
>point of my request, and definitely missed all the details.  I am
>trying
>to build a rackmount MySQL server, so all my requests are based on that
>point.  You seemed to latch on to the fact that I mentioned MythTV, but
>you missed the part where I said that I want to offload MySQL *from*
>MythTV..  Which is surprising since it was the first sentence I wrote.
>
>To be more clear:  I am looking to build a rackmount, low-power,
>low-noise
>MySQL server that will serve many other services located on other boxes
>on
>my network.
>
>More inline..
>
>On Tue, October 16, 2012 2:19 pm, JD wrote:
>> On 10/16/2012 11:52 AM, Derek Atkins wrote:
>>> Hi,
>>>
>>> I'm looking to offload my MySQL server off my MythTV hardware and
>onto
>>> its own server box.  This instance of MySQL handles not only MythTV
>data
>>> but also my Maia Mailguard, Zarafa, Gallery, and possibly other
>>> services.
>>
>> No. Recording TV takes more CPU that you'd expect. If you add in
>> transcoding,
>> you'll need at least a Core2Duo CPU.
>>
>> If you remove the TV recording and transcoding, then an Atom-level
>box
>> would be
>> fine.
>
>While irrelevant to the question at hand, my MythTV data sources are
>all
>HD-Homerun boxes, and I do not perform any transcoding.  But that is
>irrelevant to MySQL.   Myth uses MySQL for lots of things, including
>jump
>tables, schedules, etc.  I want to move it to separate hardware to
>"spread
>the load".
>
>>> I'd like something relatively quiet because it's living in my house,
>not
>>> in some rackspace machine room. I'd prefer to have 8GB of ram but
>all
>>> the Atom boxes I've found seem to max out at 4 (although I can
>aquire
>>> one for about $450 with an D2500HN Atom Dual Core 1.86GHz/4GB/160GB
>>> 5400RPM).
>>
>> You can build an Atom-base (or AMD E-something) for less than $200
>with
>> 4GB of
>> RAM and a picoPSU (100% silent PSU). There is no need for even 4GB of
>RAM
>> to run
>> all those things, including Zarafa.  Running the enterprise email
>process
>> on
>> there makes 1-2GB needed, but everything else will fit in 512MB. If
>you
>> use
>> straight postfix and dovecot, the email part will easily fit in 384MB
>-
>> easily.
>>  This assumes no more than 10 email users.  4G is fine.  Don't know
>> anything
>> about mailguard requirements.
>
>Again, I'm only asking about running MySQL.  All these services already
>have homes, but they use a single MySQL database server that happens to
>currently live on my MythTV server.  Again, I want to separate MySQL
>out
>to its own box, leaving the services running where they are.
>
>Could you give me pointers to where I can get the appropriate mobo,
>cpu,
>ram, and rackmount case for less than $200!?!  NewEgg URLS are great. 
>Personally I haven't found any rackmount solutions for $200.
>
>>> Has anyone found any good sources for inexpensive servers?
>>
>> When they call something a "server", add $200-$5000 to the real
>price.
>
>Sure, but it's hard to search on "rackmount".  Preferably I'd like a 1U
>or
>2U box.  I did find a 1/2 2U box for about $450 shipped.  But it only
>supports 4GB RAM.  Maybe that would be enough, but RAM is king for
>databases, right?
>
>> I've
>> found some newegg APU + steel case bundles for Atom-class systems and
>> cases for
>> $100. $30 for 4GB of RAM and $50 for the picoPSU, reuse an old HDD
>and you
>> are
>> golden for $180.  No transcoding or TV tuner.  For the TV tuners, I
>love
>> the
>> network-baed HDHR models.  Then it doesn't matter where the recording
>> happens on
>> your network.  I record using a virtual machine.
>
>Again, I'm building a MySQL box, not MythTV.  Could you point me to the
>NewEgg URLs for these deals?  My searching hasn't resulted in anything
>useful.
>
>>> I was also considering an SSD for this application.  Do you experts
>feel
>>> that would help my application speeds?
>>
>> No, not at all, but others will have a completely different take. 
>Video
>> streaming does not demand the costs that an SSD requires. A large HDD
>is
>> more
>> important, it doesn't need to be fast.
>
>When does MySQL perform video streaming?  I was thinking that MySQL
>would
>benefit from the speed of reads from the disk.  But I don't know if
>MySQL
>is generally I/O bound, memory bound, or CPU bound.
>
>> If you want a TV tuner and transcoding, you can find used (off lease)
>C2D
>> boxes
>> for about $200, but the PSU will probably be too noisy for a living
>room
>> environment.
>
>Thanks, but irrelevant.
>
>> I'd avoid the entire "server" line, unless you are just trying to get
>> something
>> that looks cool and different for the house.
>
>I want something I can mount in my rack.
>
>Thanks,
>
>-derek


--

Sent from my Android Acer A500 tablet with bluetooth keyboard and K-9 Mail.
Please excuse my potential brevity.

(To whom it may concern.  My email address has changed.  Replying to former
messages prior to 03/31/12 with my personal address will go to the wrong
address.  Please send all personal correspondence to the new address.)

(PS - If you email me and don't get a quick response, you might want to
call on the phone.  I get about 300 emails per day from alternate energy
mailing lists and such.  I don't always see new email messages very quickly.)

Ron Frazier
770-205-9422 (O)   Leave a message.
linuxdude AT techstarship.com




More information about the Ale mailing list