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

[timriley at appahost.com]

> -------- Original Message --------
> Subject: [vox-tech] Clusters, renderfarms and MySQL, LAN projects using
> more than one Linux at a time
> From: pksky at finestplanet.com
> Date: Sat, March 02, 2013 9:35 am
> To: vox-tech at 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.
http://www.amazon.com/MySQL-Clustering-Alex-Davies/dp/0672328550
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.

<snip>