digg

Facebook Connect Join Digg About

How to setup a MySQL cluster on Linux

davz.net — An article on how to setup a MySQL DB cluster using two servers and a third server as a management node on Linux.

Who dugg this? Made popular Dec 19, 2005

Digg DudeWhat is Digg?

Digg is a place for people to discover and share content from anywhere on the web. Digg surfaces the best stuff as submitted and voted on by the community. Take the Tour to learn more.

13 Comments

show profanity settings
expand all
  • ericpp, on 10/12/2007, -0/+0The current MySQL Cluster suite requires you to store your entire database in RAM. This is no problem for small sites, but its impractical for large sites. If you're thinking about MySQL Cluster, you should probably wait until 5.1 which will feature on-disk storage.
  • seaner, on 10/12/2007, -0/+0Thanks alot! I am in need of this type of setup.
  • timdorr, on 10/12/2007, -0/+0"If you're thinking about MySQL Cluster, you should probably wait until 5.1 which will feature on-disk storage."

    Actually, it's only barely on-disk. Data is stored on the disk, but any indexed column is stored in memory. So, heavily indexed or large tables will still have problems with memory limitations.
  • ericpp, on 10/12/2007, -0/+0I would think so...

    The setups I've heard about use only the master for writing and the master/slaves for reading.

    You can also use multiple masters, but it gets very tricky to resync them if they become out of sync.

    The MySQL Replication FAQ actually does a decent job discussing this:
    http://dev.mysql.com/doc/refman/5.1/en/replication-faq.html
  • haxr, on 10/12/2007, -0/+0does anyone know what DB digg uses?
  • fkuall, on 10/12/2007, -0/+0this should be required reading for everybody using a computer
  • inactive, on 10/12/2007, -0/+0digg +++
    see in how almost every server should have this very good digg!
  • ericpp, on 10/12/2007, -0/+0I think Digg is using a MySQL replication setup. Kevin talked on twit.tv about how digg's slave servers were becoming out of sync with the master server and showing negative diggs.
  • seweso, on 10/12/2007, -0/+0A replication setup is reading from multiple servers and writing to only one...right?
  • seweso, on 10/12/2007, -0/+0We had someone over from Getronics PinkRoccade which told us that a Mysql cluster does not need to have every database in memory. Strange. Is it possible to run multiple mysql databases on a cluster without running out of memory? What cheap alternative is there?
  • inactive, on 10/12/2007, -1/+0ack.. I'll stick with clustering with windows advanced..
  • jay42, on 10/12/2007, -1/+0Woops, misdugg....- 1 Digg
  • creepah, on 10/12/2007, -3/+0Thanks for the news :)

    http://www.proxyindex.com - Free Anonymous Surfing

  • Add a Comment

    Login or register to comment!
    Or, sign-in super fast with your Facebook account ...

© Digg Inc. 2009 — Content created and posted by Digg users is dedicated to the public domain | Terms of Use Updated | Privacy Policy
DIGG, DIGG IT, DUGG, DIGG THIS, Digg graphics, logos, designs, page headers, button icons, scripts, and other service names are the trademarks of Digg Inc.