Any beef about MySQL cluster?
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 posted this at 22:47 — 29th January 2008.
He has: 3,956 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.
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.
a Padded Cell our articles site!
teammatt3 posted this at 19:31 — 1st February 2008.
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
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 posted this at 02:13 — 4th February 2008.
He has: 3,956 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.
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.