It's always good to mess

JeevesBond — Mon, 04 Feb 2008 02:13:27 +0000

It's always good to mess around with tech, suppose clusters would be pretty fun to play around with. Thanks for the link too, I'll have a read of that.

I don't need a MySQL for any

teammatt3 — Fri, 01 Feb 2008 19:31:02 +0000

I don't need a MySQL for any of my projects, but it's nice to know if I ever become uber-successful, I can use one

Of all the sources I looked at, they all pretty much say the same thing, I guess that's a good thing. At least the limitations/problems are consistent.

My largest database project uses a dual-master setup. It was simple to setup and I haven't had any problems with it. This slideshow does a good job of showing some popular topologies. That's where I learned about the multi-master setup.

I've never used it

JeevesBond — Tue, 29 Jan 2008 22:47:41 +0000

I've never used it personally, but I do know of two large sites that use it:

I did find out some complaints: http://books.slashdot.org/comments.pl?sid=131519&cid=10985218 a search also revealed the usual 'MySQL sucks...' and in particular 'MySQL clusters suck!' posts, but they lacked any evidence so I skipped past them.

That post seemed to sum-up the problems best, but there are large sites that get along with MySQL Cluster perfectly well. One other thing to consider: do you necessarily need a full cluster, you might be better off using a master with a couple of slave servers. See how Drupal.org is setup for an example of this. If you're mostly doing reads, with few writes, master-slave should work well for you.