SQLYog allows us to quickly check our databases and has enough depth of functionality to run our mor complex requests
Pros
Simple, quick access to our databases. The interface is simple and clean
Cons
Sometimes it is unclear that my editor is not pointed to a particular database so my queries don't work
Rating breakdown
Likelihood to recommend: 10/10
Pros
the dashboard panel and the ability to tell what the hit ratio is on the e-cache is great. that is an example of how I wish they all worked. it knows we should know that and it seemed to automatically start showing that without me needing to do anything.
Cons
trying to figure out what it means to "configure a monitor" - I don't mind seeing the code it is going to execute - but I have a hard time figuring out any details about intended or typical usage. I cannot tell whether they are indicating hints on how to configure the my.ini file, whether the my.ini needs a certain setting to activate or what the expert would do to set up that certain monitor. having them separate is fine, allowing granular configuration. my hope is a far more turn-key rev that opens up knowing that we want to see db throughput, e-disk usage, any kind of errors (I have tried but failed to figure out how to link MySQL error log to MonYog), and a better way to look at queries or other system activity that is not operating as efficiently as it *should*. I will say, it is difficult for this level of admin software to be made simple, when it really isn't simple. I'm primarily a developer and don't have formal db admin training. I would like to use Monyog to know that everything is running properly and I'd like to know common sense nips and tucks that could be very helpful in gaining maximum performance from the db. to be honest, I would probably be willing to pay a consulting fee for someone to help take the mystery out of implementation in a way that gets my configuration of monyog improved. thanks!
Thank you Mark for taking your time to review Monyog. We really appreciate your feedback and our team would love to help you out at all points.
Monyog ships with various monitor/advisors that would certainly help you to fine tune your servers and optimize the performance. For e.g., If there is a root user without password, then this is something that needs attention and Monyog alerts for critical issues like this.
You can also add new monitors by writing JavaScript expressions to compute the value to monitor specific server parameters.
And to enable MySQL Error Log monitoring in Monyog and use the Monitor group "MySQL Logs" to monitor your error log. You can refer to our documentation for further information.
[http://docs.monyog.com/].
Rating breakdown
Every time somebody changed a configuration variable i get notified. We can simply compare configuration on (galera, drbd) clusters
Pros
- Web based
- Integration of most often needed metrics
- role based access control
- ldap integration
- easy comparision of server configurations
- e-mail based notifications of configuration changes
Cons
- high load when ssh connection is not available
- high storage consumption (udo.data) although only 7 days of history is stored.
- private ssh keys have to be entered for each monitored server
- errors in context popups, e.g. Monitors->Innodb Cache->Cache misses (shows html sourcecode instead of popup), same error on other places too.
Rating breakdown
Likelihood to recommend: 7/10
Visibility into database usage and queries so that our tech team can proactively monitor and optimize our db as well as our application code. Reduce number of incidents caused by DB issues.
Pros
The realtime capture of queries and slow query analysis has been a boon.
The ability to look at and alert based on db performance and other metrics assists our team to head off issues before they happen
The ability to look at historical queries and performance is great
BEAUTIFUL WEB UI!
Cons
I wish there was a clustered/redundant option that would allow us to replicate the captured data, in case one machine dies.
It's a bit slow at times when pulling up longer captures that are setup using the realtime capture feature.
Thanks for the review, we are happy to know that you're able to effectively monitor in real-time. We would also certainly look into your request.
Rating breakdown
Likelihood to recommend: 10/10
Pros
Very easy to use, software so predictable , user don't need much knowledge about SQL to use this, its a great tool very powerful, graphic and have more options that competition.
Cons
It's a great software, i can't say very much problems, the constant publicity of their seminars web (webinars) is a shame, only that
Rating breakdown
Likelihood to recommend: 8/10
Pricing based on number of MySQL servers and support levels.