l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2013 Mar 04 14:47

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Clusters, renderfarms and MySQL,LAN projects using more than one Linux at a time
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Clusters, renderfarms and MySQL,LAN projects using more than one Linux at a time

> Processing times can be improved with data structures. I'm not sure
> storing MySQL tables across
> multiple machines will speed this up. The data travels across your
> motherboard's bus
> much faster than it will travel across the network and then your
> motherboard's bus.
> But as you said, it's a excuse to try clustering.

Last I checked a mysql cluster has to fit in ram, but that may have
changed.  For better scaling I'd suggest NoSQL key/value stores if that
fits your need.  Lugod has a talk on RIAK not too long ago.  MongoDB is
also common.

> I've never implemented a cluster, however, because running MySQL on a
> single machine has always
> fulfilled my needs.

Certainly I'd recommend tuning mysql for a single machine before trying
to scale it larger.

> The only tweak I've needed is to store a 300 million
> record table
> on another machine through NFS. And short of a complete backup,

It's inherently unsafe to use mysql to access tables over NFS.  I guess
it could be ok if it's read only.

As for building your own cluster I'd suggest starting with any of the
popular cluster distributions, or if you want to do it yourself start
with your favorite linux distribution and then add cobbler and puppet.

I suggest slurm, if you want a batch queue to manage resources for you.

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!