Re: Setting up a MySQL Cluster

[martinof]

Hello,

Jon Stephens Wrote:
-------------------------------------------------------
> From the cluster's point of view, there shouldn't
> be any adverse issues with running the management
> node on the same machine as the LVS server. The
> overhead for the MGM process is minimal.
>
> However, you should minimise any processes and
> network traffic on the data node hosts that aren't
> absolutely essential to keeping those machines
> running.

Thanks for the advice


> Before you go trying to use Cluster to run
> multiple websites, however, have you tried simply
> separating the DB and fileserver roles, and/or
> using standard MySQL replication to improve
> performance?

I haven't tried separating the DB and fileserver roles because my main concern is reaching high availability. But I recently had some trouble with performance and that would be a good thing to try.

As for replication, it seems that I can't have any write request on the MySQL slave (insert, update, etc...). If the MySQL master hanged for some reason, I could manually make some modifications to use the MySQL slave. But I'd like this failover to be automatic and not human-dependant.

So it seems that I could set up this architecture :
- 1 firewall / MySQL node management
- 2 dedicated Apache servers
- 2 dedicated MySQL nodes (in 1 cluster) instead of a combined file / DB server
- 1 dedicated file server

Do you think this would be correct ? Is NFS suited for this architecture ?

Thanks