MySQL 4 - Clustering
I've got a setup whereby I need multiple MySQL servers to be able to get and save data off a single master SQL server. However, I need all the servers to be locally run- I need very low latencies and response times (It's for an MMORPG).
I have one box which I want to run a server and the cluster master server on, and a few others which will be normal servers connecting to the master.
Versions of MySQL will vary- 4.0.25-max and 4.1.12 will be the two i'm using.
Is a MySQL cluster the best way to do this? All the machines are in separate datacenters.
If it is, how would I go about setting this up? I've had quite a lot of MySQL experience but not much on the server side of things (I can install and do a few perf tweaks but not much else).