I need to build a MySQL Cluster and I was wandering if anyone on the forum has any experience with it.

I don't have experience with mysql clustering, but I am interested in what cluster software you're going to be using. I have experience with Rocks Clusters, and love it, though i don't see any rolls for mysql cluster, though i know Rocks comes default with mysql.

Thanks for the tip on Rocks. I will look into it. I am thinking about using NDB which is part of MySQL.

Got 3 Ubuntu VMs running together and made a NDB cluster (according to the NDB manager)

That must either be a good computer, or some slow performance. Are u using VMware? I'm doin some stuff with VMware for work, and would like to build VM's automatically, with some sort of script. I know that vmware has a perl and c api, but that's only for start, stopping, and other management services, not creating the vm's.

Thanks

I was running 3 instances of VMPlayer with 3 nearly identical images until I specialized the VMs. This was merely a test to see how difficult the configuration was if we wanted to pursue that route further. I did not get a chance to test the performance. I was running them on the Intel 805 model, I think, with 2GBs of RAM. I was not using MySQL 5.1 so the NDB is RAM only. Probably will not work for us in the end. Optimizing the database and waiting may be the answer.

For an autobuild, see if you can do anything with easyvmx. Maybe you can do something with the blanks. I think they can be PXE booted, but I do not know how that process works. There is also a workstation 6 beta on vmware's website.