MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute • Hacker News Board

Re: MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute

#31

Post by orthecreedence » Thu, Feb 16, 2012, 5:40 AM UTC

kungfooguru wrote: post #11

pc wrote: post #5

Has anyone here used MySQL Cluster in production?

Yes. And its a pain in the ass. From reading whats new in this release I could care less about AQL but hearing them say you can bring up a whole cluster with one command it shares user permissions between them... that gets me excited!

I played around it with in some of our apps, and I can second that running it was a pain in the ass. It seemed to fail randomly (the entire cluster would go down) even with minimal use.

I know I must have been doing something horribly wrong, but I never could really figure out what it was.

Re: MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute

#32

Post by seanp2k2 » Thu, Feb 16, 2012, 6:33 AM UTC

bermanoid wrote: post #6

pc wrote: post #5

Has anyone here used MySQL Cluster in production?

I'm also very curious to hear real world feedback on this, I've been aware of the option for a while, but never heard much about actual use. Automatic sharding and memcached integration are pretty awesome features, and could definitely ease code at the application level (sharding code is a particularly special pain in the ass, not so much getting it working, but allowing for re-sharding migrations if you decide you n…

MySQL is an expensive toy if you spring for Enterprise. Crashes all over the place, bugs stay open forever, no one really knows how to fix it, people on IRC are mean and think they know more than they do, etc.

Check out Postgres or Cassandra.

Re: MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute

#33

Post by seanp2k2 » Thu, Feb 16, 2012, 6:36 AM UTC

dedene wrote: post #18

Looks awesome! Does anyone have a suggestion for a good site explaining what's the best path for migrating from a master / master setup to a MySQL Cluster?

Schedule downtime, dump DBs, backup EVERYTHING three times, import DBs into new RDBMS, switch over config and bring everything back up.

You know who has scheduled maintenance? Apple, Verizon, Sprint, etc.

Re: MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute

#34

Post by andrewmorgan » Thu, Feb 16, 2012, 9:40 AM UTC

dedene wrote: post #18

Looks awesome! Does anyone have a suggestion for a good site explaining what's the best path for migrating from a master / master setup to a MySQL Cluster?

You still have MySQL Servers in MySQL Cluster and you can mix and match storage engines (e.g. use InnoDB for some, Cluster (ndb) for others). Cluster 7.2 uses a tweaked version of MySQL 5.5 for the MySQL servers and so if you're already on 5.5 then the migration is fairly simple...

0) Always a good idea to backup! 1) Create your cluster... http://www.clusterdb.com/mysql-cluster/deploying-mysql-clust... - stop before starting your mysqlds 2)Configure your mysqlds to use the same data directory as your existing ones 3) Stop your existing mysqlds 4) Start up your new (cluster) mysqlds. At this point you still have your existing tables stored in the original engine (e.g. MyISAM or InnoDB). 5) Migrate appropriate tables to cluster... "ALTER TABLE ENGINE=ndbcluster;"

Re: MySQL Cluster 7.2 GA Released, Delivers 1 Billion Queries per Minute

#35

Post by macros » Thu, Feb 16, 2012, 11:41 AM UTC

bermanoid wrote: post #6

pc wrote: post #5

Has anyone here used MySQL Cluster in production?

I'm also very curious to hear real world feedback on this, I've been aware of the option for a while, but never heard much about actual use. Automatic sharding and memcached integration are pretty awesome features, and could definitely ease code at the application level (sharding code is a particularly special pain in the ass, not so much getting it working, but allowing for re-sharding migrations if you decide you n…

We've been happily using it for the better part of a year now. Our data set fits easily in memory and the limitations of the product aren't a problem at all. We started with riak but the cognitive overhead on the developer side was a bit much for the operations side win, mysql cluster has been trouble free so far.