MONyog is the best out-of-the-box GUI monitoring tool for MySQL that I have seen. It "just works." As promised, getting up and running quickly is easy, and having a centralized location for monitoring is very useful. The graphs are beautiful and the statistics that are graphed are useful time-savers.

The biggest difference between MySQL's Enterprise Monitor and MONyog is that MONyog is agentless. At Pythian, we have many clients with differing security requirements. Requiring a daemon process to be running is not something we currently do, and it might be a hard sell for some clients. Even if every client was amenable to it, making sure the daemon is up and running on each MySQL server is tedious. Note that agentless operation works for every feature, including log analysis as well as operating system statistics.

I have used MySQL Enterprise Monitor for a year and a half, and although some believe its a superior product, its 5K per server per year for the Enterprise version. I just started using MONyog a month ago, and purchased it today. I bought the Unlimited Pack and that is a perpetual license for an unlimited amount of servers. It gives me all the monitoring I need and without an agent installed on the MySQL server. That makes the sys-admins I work with very happy. My prefered feature is the log analyzer. It makes analysing the slow-query-log and the general-log really easy and efficient. Cool product, check it out if you can.

We use SQLyog Enterprise for some database administration of our customers' MySQL databases. It can save quite a bit of time, especially having multiple queries in the Query editor and being able to execute each query individually. Let's you step through things, and check on data as you go along.

Where we get the most benefit though, is the Structure Synchronization Tool. This has saved us countless hours. Our core product uses an abstracted database layer that actually does a good job of generating our database schema automatically. When we need to update a customer's database to a new schema, we use the Structure Synchronization Tool to generate a difference script between the two schema versions. This tool gets it right every time, and takes minutes for a task that would typically take days to compile manually with the number of tables we have.
We tested a few other products for this specific feature before trying SQLyog and no others were as easy to use, and also give the result we were after. We almost didn't try SQLyog Enterprise because we didn't think that we could get the features we needed in a product that was sold at this price! I'm glad we did! This product paid for itself 10 times over the first time we run the Structure Synchronization Tool! Because it saves us so much time and gets it right EVERY TIME, we are a lot more confident in getting new features that our customers want in our software on a more regular basis. Major Update does not equate to a major pain anymore.

While temporarily contracting for another company, I recommended SQLyog Enterprise for the Database Synchronization Wizard (we were migrating some software from MS SQL Server to MySQL). They purchased a license, and once again, this software paid for itself on saved time in the first afternoon. For the rest of the project, we used it to develop database maintenance scripts, design new tables and relationships in the Schema Designer, and found it very handy for importing data files (MySQL dumps as well as CSV files) across the network.

I have already recommended it to others, and there is no reason why I won't continue to do so. Keep up the great work guys!

Dancing with joy... still. I have been using SQLyog Enterprise for some time now and am convinced that it is simply the best MySQL management tool ever. I have tried many different tools over the years, including those from the MySQL website; I am really in to Open Source, but every once in a while a product/program really stands out and is worth buying. Nothing touches SQLyog Enterprise for easy, comprehensive power and usability.

When I first downloaded SQLyog, I was a little apprehensive, but excited to see what it could do - well, after about an hour of poking around, I was literally dancing around the room, my wife thought I was NUTS; it had immediately solved many issues I had with different projects quickly and easily. I have a couple of web-based applications that use in-house database systems, to get that data on the web without complicated programming is now a breeze with the Database Synchronization Wizard. Just a short set-up process and the use of the integrated SQLyog Job Agent, data stored in a separate system is easily updated to the web via the supplied Tunneling Script for public use whenever updates are needed; it's awesome! I recently had a rather large project that I converted from SQL to MySQL and the Migration Tool Kit made the job a breeze, instead of spending hours fretting over data types, complicated drivers and filters, and the sheer size of the SQL database I was converting, I was immediately able to resume work optimizing queries by quickly adding Indexes and viewing results in the Query Analyzer; I didn't miss a step, my client was impressed and I was the hero... being the hero is always a good thing.

Scheduled back-ups are a slam dunk too! I don't ever have to worry about keeping backups current with regard to my clients databases, they now take care of themselves, I am completely prepared for any loss of data that may occur as a result of server issues; if for some reason a table is acting a little buggy, the Table Diagnostics make identification and repair easy and fast. Need a quick report of data within a table or from a specified query to display for your client? SQLyog Enterprise makes exporting into either .CSV,.HTML,.XML or .SQL files fast so you can display or send your data to your client without delay. That works in reverse as well, if a client sends you data in any of those formats, importing is just as easy and you no longer need to spend time with complicated scripts to import data. I could go on, but suffice it to say that SQLyog Enterprise has saved me time and money and has taken a lot of thought and worry out of database management.