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 07 13:44

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

> -------- Original Message --------
> Subject: [vox-tech] Clusters, renderfarms and MySQL, LAN projects using
> more than one Linux at a time
> From: pksky@finestplanet.com
> Date: Sat, March 02, 2013 9:35 am
> To: vox-tech@lists.lugod.org
> Hello:
> For a while, I've been looking for an excuse to use my LAN for implementing clusters of one kind or another.  First, I've got some MySQL projects that are taking a lot of time to work.  They are huge matrix problems and so far, have been incomplete even after 12 hours of processing.

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.

>  I know that MySQL can be distributed across several different computers (asymmetric replication?) and so there is one project.  But also it might be possible to distribute MySQL across several Linux machines in a Linus cluster and maybe both at the same time.

Check out the book titled, "MySQL Clustering" by Alex Davies and
Harrison Fisk.
It goes through the setup steps in nice detail.

I've never implemented a cluster, however, because running MySQL on a
single machine has always
fulfilled my needs. 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,
processes accessing
it take at most 15 minutes.

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!