0

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?

Improve this question

4 Answers 4

Reset to default
2

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.

Improve this answer
1
  • Thank you, this is really a great tool. This way I will spend the bucks to a FusionIO Drive duo :)
    – Nenad
    Apr 12, 2011 at 9:42
1

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.

Improve this answer
2
  • 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, 2011 at 9:44
  • Excellent, glad to see you found a solution :-)
    – rfelsburg
    Apr 12, 2011 at 13:17
0

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

Improve this answer
0

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .