#1  
Old 13th April 2006, 03:24
JamesHarrison JamesHarrison is offline
Junior Member
 
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question MySQL 4 - Clustering

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
Reply With Quote
Sponsored Links
  #2  
Old 13th April 2006, 15:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

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/loadbalanc...cluster_debian

Maybe MySQL replication is what you're looking for? http://www.howtoforge.com/mysql_database_replication
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 21:49
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 02:26
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41


All times are GMT +2. The time now is 09:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.