<font face="arial" size="2"><p style="margin:0;padding:0;">Thanks for the tip, I'll keep an eye on the book.</p>
<p style="margin:0;padding:0;"> </p>
<p style="margin:0;padding:0;">Paul</p>
<p style="margin:0;padding:0;"> </p>
<p style="margin:0;padding:0;">-----Original Message-----<br />From: timriley@appahost.com<br />Sent: Sunday, March 3, 2013 11:15am<br />To: "lugod's technical discussion forum" <vox-tech@lists.lugod.org><br />Subject: Re: [vox-tech] Clusters, renderfarms and MySQL, LAN projects using more than one Linux at a time<br /><br /></p>
<div id="SafeStyles1362345846">
<p style="margin:0;padding:0;">> -------- Original Message --------<br />> Subject: [vox-tech] Clusters, renderfarms and MySQL, LAN projects using<br />> more than one Linux at a time<br />> From: pksky@finestplanet.com<br />> Date: Sat, March 02, 2013 9:35 am<br />> To: vox-tech@lists.lugod.org<br />> <br />> <br />> Hello:<br />> <br />> 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.<br /><br />Processing times can be improved with data structures. I'm not sure<br />storing MySQL tables across<br />multiple machines will speed this up. The data travels across your<br />motherboard's bus<br />much faster than it will travel across the network and then your<br />motherboard's bus.<br />But as you said, it's a excuse to try clustering.<br /><br />> 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.<br /><br />Check out the book titled, "MySQL Clustering" by Alex Davies and<br />Harrison Fisk.<br />http://www.amazon.com/MySQL-Clustering-Alex-Davies/dp/0672328550<br />It goes through the setup steps in nice detail.<br /><br />I've never implemented a cluster, however, because running MySQL on a<br />single machine has always<br />fulfilled my needs. The only tweak I've needed is to store a 300 million<br />record table<br />on another machine through NFS. And short of a complete backup,<br />processes accessing<br />it take at most 15 minutes.<br /><br /><snip><br />_______________________________________________<br />vox-tech mailing list<br />vox-tech@lists.lugod.org<br />http://lists.lugod.org/mailman/listinfo/vox-tech</p>
</div></font><br><br><br>Sent from Finest Planet WebMail.<br>