MySQL 4 - Clustering

Discussion in 'Server Operation' started by JamesHarrison, Apr 13, 2006.

  1. JamesHarrison

    JamesHarrison New Member


    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).

  2. falko

    falko Super Moderator Howtoforge Staff

Share This Page