How to setup a Cluster with 3 Servers

[Thomas Goik]

Hi,

i have the following question:

We have now running 2 mysql Server as separated servers, no replication.
Each of these servers has 1 mysqld running with 4 databases on each server there is at least one table who uses fulltext index - what i can't use on clusters.

The servers have both 2 xeon CPUs with 3 GB RAM. one is SCSI RAID and the other only SCSI.

Know we have still 3 Severs for apache an mail stuff. One dual xeon a two PIII all with SCSI

If i understood well the data node do not need to have performance because the data sort and select is done in the mysqld server or I misunderstood – if not what kind of performance the data node server should have?

How I have to do that the 2 mysql servers I can use to provide the cluster, one of the 3 other server could be used as mgm server for the cluster.

Thanks for any help or suggestions