Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to deploy a MySQL cluster but initially no bucks for the MySQL Cluster Manager Client.

It's at least $5k and I actually think in my case it will go way over that.

I looked a lot on Google (a few days actually, part-time) for an opensource solution with no success. I also didn't find anything about such solution here at stackoverflow etc.

But I still find it hard to believe that no one tried or succeeded building such a client, even if it's not open source, at least "cheaper/less expensive".

Now another point, what will I be missing by not having this client? For what I saw I could write scripts for most of what it does, is there HUGE advantages to using it?

PS. Changing to another "HA" solution like master master or etc is not an option...

PS2. Using any of the other cluster solutions, like persona's is not an option...

Edited here: btw, it works great and I wrote simple automation scripts myself. I wanted to use names instead of ips for the nodes, but it it seems impossible... lol

Thanks everyone for the replies!

share|improve this question
1  
Be sure you know what you're getting in to. The thing called MySQL Cluster is not vanilla MySQL, but a specific storage engine with a specific set of requirements and restrictions. You are going to need to do some hardcore architectural investigation if you go down that road. –  Charles Mar 11 '12 at 6:16
add comment

migrated from stackoverflow.com Sep 10 '12 at 6:24

This question came from our site for professional and enthusiast programmers.

5 Answers

up vote 5 down vote accepted

The cluster manager software can help make a lot of operational tasks much simpler, and can avoid mistakes such as restarting machines in the wrong order for a rolling upgrade or so on. There is also a competing product from SeveralNines which is said to be superior in some respects, although I can't comment more on that because I haven't used it.

Why would you want some kind of cluster management software? Can you live without it? Yes, you can. But do not underestimate the complexity of administering a MySQL cluster based on NDB technology. It is NOT just a storage engine for MySQL, and it is NOT related to or similar to standard MySQL. It is a set of MySQL servers with a storage engine acting as a front-end or proxy to a completely separate NDB database, and NDB is probably unlike anything you've administered before. It's also not really compatible with standard MySQL from the behavioral point of view, so you will have to build your application to work with/around its characteristics; an NDB cluster migration commonly involves a significant application rearchitecture project.

If you don't really know what you are doing, you will probably not achieve whatever your goals are (high availability, high durability, high performance). Fat-finger something and you can cause downtime or even complete data loss. A "good" administrator usually has years of experience with it. No offense, but the fact that you need to ask what the cluster manager software does for you probably indicates that you're not knowledgeable enough -- I would be scared if I were you. NDB is not simple; take a look at the number of lines of code and compare that to MySQL; now compare the size of the user manual and the size of the userbase, and consider that you're getting into a very specialized field with not enough documentation, only a few gurus, and not a huge population of administrators with a very large shared knowledge.

The reason someone mentioned Percona XtraDB Cluster is likely because it's basically standard MySQL with standard InnoDB, with a cluster communication component to replace standard replication with something better, called Galera. I work for Percona, and I'm not trying to boost it, only adding a little context to other replies.

share|improve this answer
    
I appreciate your insight! You are 100% right about my experience with clustering and it is, as I have been seeing on the net, a not so well documented option. –  Jake Armstrong Mar 12 '12 at 2:01
    
My comment editing expired... I appreciate your insight! You are 100% right about my experience with clustering and it is, as I have been seeing on the net, a not so well documented option. In the other hand if done well can handle all my needs. Using other options will put me with a large amount of "other" problems which might just make up for the cluster hassle. Isn't it worth learning? Isn't there a limited number of things that can actually go wrong on a day to day basis? –  Jake Armstrong Mar 12 '12 at 2:10
    
Btw, I spoke with severalnines sales and it costs 1.6k Euros/node/year. –  Jake Armstrong Mar 12 '12 at 2:14
    
+1 for excellent insight –  ssmusoke Mar 12 '12 at 4:11
    
I would say that, in general, most technologies have a basically unlimited number of things that can go wrong :) Clustered systems have particularly interesting failure modes. If you learn it well, and if it suits your needs, great -- I am not trying to scare you away from it, just trying to make sure you have a "healthy respect" for NDB. –  Baron Schwartz Mar 12 '12 at 12:34
show 1 more comment

Disclosure first: I'm part of the MySQL Cluster product team

You can try out MySQL Cluster Manager without cost or obligation to determine if does what you need. The bootstrap option enables you to evaluate cluster simply by provisioning with a single command: http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-2-creating-a-cluster-is-now-trivial/

The Evaluation Guide provides best practices on building a Proof of Concept on Cluster, and benchmarking your configuration: http://mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php

Please also note the prices you are quoting are not just for MySQL Cluster Manager, but also includes 24x7 support for the whole Cluster (not just the manager) in addition to MySQL Enterprise Monitor, MySQL Enterprise Security, etc

Good luck with you evaluations!

share|improve this answer
    
Uhmm, this is new... I will take a look, thanks a lot! :-) Considering the support it sounds a good price, but only when the company is actually making any money / lot of data... :-| anyway, thanks... –  Jake Armstrong Mar 13 '12 at 8:19
    
Can MySQL Cluster, MySQL Cluster Manager, MySQL Enterprise Monitor, MySQL Enterprise Security be downloaded & used for free if one isn't interested in Support? i.e. my question can all these products be used commercially without paying for it. I am not asking about the moral aspects but the legal aspects. –  user93353 Nov 7 '12 at 13:04
add comment

Please read about purpose of that client:

Cluster will work without that manager client. BUT you have setup script to test cluster is ok. You can use pacemaker or other clustering software(yes, i see that it was "not a option") or you can create similar softwar yourself.

I am recomending use nagios monitoring software for monitor cluster and do all operation "manualy". so you will have monitoring system, script which will try auto-restore(invoked by nagios) and script which will do backup. After that you can add script which do other operation like check cluster perfomance logs etc.

Note, that overal time of creating and testing such installation can be more then cost of original soft.

share|improve this answer
    
Thanks, I took a look at nagios, still, I think severalnines solution sounds the best option for now. They even provide automated configuration scripts and online settings generator for initial setup... –  Jake Armstrong Mar 13 '12 at 8:20
add comment

Try the Percona XtraDB cluster - http://www.percona.com/software/percona-xtradb-cluster/ its currently in Beta with a release candidate at the end of March 2012

share|improve this answer
    
I will try, thanks... –  Jake Armstrong Mar 12 '12 at 2:11
add comment

Take a look at Several Nines' Cluster Control software: http://www.severalnines.com/cluster-control-mysql-cluster

I've used it as part of a package install for MySQL Cluster on Amazon EC2: http://support.severalnines.com/entries/20916823-installing-on-amazon-ec2

and have found it quite useful. I suspect its not as fully featured as Cluster Manager, but might be what you need.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.