Hi. 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). Cheers, James
You can use a MySQL cluster, but it has a major disadvantage: it runs solely in your RAM, therefore you need lots of RAM, and if your cluster nodes go down at the same time, your data is lost. Have a look here: http://www.howtoforge.com/loadbalanced_mysql_cluster_debian Maybe MySQL replication is what you're looking for? http://www.howtoforge.com/mysql_database_replication
