[SATLUG] MySQL Cluster and OpenMosix

[Thomas King]

I finally got the green light to set up a cluster at work, a small one, but 
I want to get some pre-task advice if I may.

I don't know the exact specs on the computers, but they are normal Dell 
towers with IDE. I think most of them have 512 MB, and I'll be using 4. The 
cluster will be using MySQL Cluster off of the -max package, and I'll most 
likely use FC4 unless someone has a suggestion otherwise (CentOS?).

I am setting up the cluster similar to MySQL's example: 2 data nodes, 1 
management node, and one mysqld. I also plan on adding Open Mosix to all 4 
to help with the processing.

To one of the computers I am going to add two more IDE hard drives, 120GB 
each, and set up a mirror RAID for a SAMBA file service. True, I should use 
SATA or SCSI, but this won't really be high-availability - it will service a 
single department of about two dozen folks for now. Our main file server is 
running out of space.

In addition, I'll be putting a Jabber server for communication inside the 
office, the config I already have set up on a test computer.

I don't think they'll allow me to have a switch between all four computers, 
so they'll be hooked directly into the Cisco switches for our V-LAN, Fast 
Ethernet.

After setting everything up and physically securing the cluster, I want to 
run the Bastille scripts to harden the setup.

Once it has all been set up, I need to migrate the data from the Microsoft 
Access db to MySQL. Any decent way of doing this?

Thanks in advance,
Tom King