Any beef about MySQL cluster?

teammatt3's picture

He has: 2,102 posts

Joined: Sep 2003

I setup a MySQL cluster with 3 servers and it seemed to work ok. I was wondering if anyone had experience using it in a production environment. Just wanted to know how well it worked. Are there any hidden hiccups with it, how was performance, how'd you handle backups?

Any thoughts?

JeevesBond's picture

He has: 3,955 posts

Joined: Jun 2002

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

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

a Padded Cell our articles site!

teammatt3's picture

He has: 2,102 posts

Joined: Sep 2003

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 Wink

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.

JeevesBond's picture

He has: 3,955 posts

Joined: Jun 2002

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

a Padded Cell our articles site!

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.