Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We build for a customer a social network site, where we will have on beginning 1 Master and 2 Slave MySQL Server.

I'm not sure if we need to go with the Enterprise or use the GA Version. The only advantage for me would be the MySQL Enterprise Monitor, who we only get with the USD 5000/Server Enterprise version. Would you suggest to buy it, or to use a 3rd party monitor tool? Does anyone know any similar tool as the MySQL Enterprise Monitor?

share|improve this question

4 Answers 4

up vote 2 down vote accepted

You could also take a look at Kontrollbase. It is feature-rich and free and there is also an online demo. On the site a way down there is also a feature comparison with MonYog / SysYog and MySQL Enterprise Monitor.

share|improve this answer
    
Thank you, this is really a great tool. This way I will spend the bucks to a FusionIO Drive duo :) –  Nenad Apr 12 '11 at 9:42

Actually I would caution again MySQL enterprise without thoroughly looking into your options, unless you're using them for a service agreement or to meet an SLA. To many people think paying for an option automatically makes it more reliable.

I prefer community as it track record of bugs/fixes versus Enterprise is much better.

Personally I prefer nagios and cacti over MySQL enterprise monitor as it is easier to customize and far less costly.

share|improve this answer
    
We use on this new setup Zabbix for Server/Hardware monitoring, as I know Zabbix has limited functionality to report on MySQL anyway I will look into nagios. The software kontrollbase metioned above by shakalandy will fit our needs in full. –  Nenad Apr 12 '11 at 9:44
    
Excellent, glad to see you found a solution :-) –  rfelsburg Apr 12 '11 at 13:17

I haven't used it but you can explore http://www.webyog.com/en/

share|improve this answer

The one major benefit of Enterprise is they will always backport fixes to a specific version of MySQL if you run into a BUG in production. With community version, they will not even look at the BUG unless you can reproduce it on the latest version that is out there.

Besides that, you can also get SLA agreements with Enterprise, but have never done that with them before.

IF you have a good in house DBA, Enterprise is probably not a necessity. Cacti/Munin can do a great job to graphing all MySQL performance and help you figure out how the server is being used and performing.

share|improve this answer

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.