Pirate Costume - Consolidation Debt - Free Ringtones - Televisores - Flights
PDA

View Full Version : MySQL Cluster

digitalpoint
Sep 5th 2005, 11:01 am
I'm curious if anyone has any experience with MySQL Cluster (http://www.mysql.com/products/database/cluster/), and if so what are your thoughts on it (good/bad)?
TheHoff
Sep 5th 2005, 11:50 am
I did some research on it for a client and it looks impressive. Ended up going a cheaper route using memcached (http://www.danga.com/memcached), one very large DB server, and 5 accessory memcache boxes.
Enigma121
Sep 5th 2005, 12:05 pm
We haven't deployed it yet, but see it as part of our future business plans. Looks nice and scaleable, loadbalancing and failover options are available, ideal for larger business / mission critical needs. I'm surprised it doesn't have much wider use across e-commerce / ebusiness sites.
Liminal
Sep 8th 2005, 11:18 am
See if this helps at all: http://jeremy.zawodny.com/blog/archives/002415.html

I don't have any experience with MySQL Cluster myself
forkqueue
Sep 8th 2005, 1:26 pm
Like vbmechanic I've only used memcached to scale MySQL. I've used the slaving features quite a lot as online backup (only as part of a backup strategy of course, it doesn't help when someone forgets the where clause in a delete statement), and that works very nicely, the only problem being you can't write to the slaves.

I'd also be interested in hearing anyone's experiences with MySQL clustering. It's one of those things I don't have enough load to justify on my own kit, and having never tried it don't feel confident in recommending to customers either.
Shoemoney
Sep 8th 2005, 1:45 pm
I dont like the whole SCO + MYSQL partnership talk agoing on right now.... Currently I am doing mysql 4 for round robin clustering (a-b-c slaving) but now testing mysql 5 master to master replication for clustering.
digitalpoint
Sep 8th 2005, 1:51 pm
now testing mysql 5 master to master replication for clustering.Let me know how that goes... I messed around with something like that in MySQL4:

http://www.digitalpoint.com/~shawn/2005/02/my-fake-mysql-cluster.html
Shoemoney
Sep 9th 2005, 10:41 pm
will do chief

I always have wanted to try the official mysql cluster but its a little to enterprise for me.... I like the haxorific setup like you have ;)