MONyog
MySQL Monitor and Advisor
What is MONyog?
MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box" that helps
MySQL DBAs manage more MySQL servers, tune their current MySQL servers
and fix problems with their MySQL database applications
before they can become serious problems.
|
SQLyog
MySQL GUI
What is SQLyog?
SQLyog MySQL GUI is the most powerful MySQL manager and admin tool,
combining the features of MySQL Query Browser, Administrator,
phpMyAdmin and various other MySQL Front Ends and MySQL GUI tools in a
single intuitive interface.
|
|
Top Blog Posts
|
General Info.
|
Webyog Customers
Google, Yahoo, Adobe, MIT, NASA, IBM, Intel, GE, HP, Xerox, Executive Office of The US President, Amazon, AOL, Boeing, Columbia University, DivX, eBay, Accenture, Harvard University, Starbucks, BT, Bank of America, JP Morgan Chase, Verizon, UCLA, SONY Pictures, Siemens, CBS Interactive, Novell, Lucent Technologies & thousands more...
|
Top Screencasts
|
Read what Press and Customers have to say...
 MONyog is a lightweight, agentless monitoring system that takes a different approach from the tools previously mentioned. It is designed to run on a desktop system, where it starts an HTTP listener on an unused port. You can point your browser at this port to see information on your MySQL servers, rendered by a combination of JavaScript and Flash. The underlying implementation uses a JavaScript engine, and all configuration is done via a JavaScript object model.
MONyog is actually both interactive and noninteractive, so you might want to examine its capabilities for both kinds of monitoring.  I was already using SQLyog Community edition for a while, and thus got to see how good Webyog's support was. This is one of the major facts that made me feel safe with investing in both MONyog and SQLyog Enterprise – those products are constantly evolving, and the developers listen closely to the customers. I personally asked for some features or changes that found their way into the product extremely fast – on some occasions in less than a week!
MONyog basically just gave me exactly what I needed. Checking on the current and past state of the servers became a no-brainer. When someone asks me about a high load on a certain day – I can answer in minutes what was the condition of database at that moment. With the new Disk Info tool, finding out where your space is wasted is as easy as it gets.
No need to use sets of custom scripts and hack all kinds of small solutions together – MONyog does it all for you, the moment you install it. SQLyog Enterprise does exactly what it said it would do. It even has additional
features such as SSH tunneling as security is always a priority when
transporting data between office locations. As a result of using SQLyog Enterprise, It
saves us time and gets the job done; very good for productivity. Excellent
product and we've been using it for years! SQLyog Enterprise makes browsing, searching, testing, and backing up
MySQL databases far easier than using the CLI interface.
Its layout and UI is also a tremendous improvement over the
Administrator GUI from MySQL AB themselves.
As a developer who has to test complex database interactions
(often through data that is updated or added via AJAX) it's invaluable
in testing and debugging.
I didn't think that the GUI would make as much of a difference as it does.
Of course the price was a consideration, since the tools I'm using now
(CLI + MySQL Administrator) are free, but the performance of SQLyog Enterprise combined
with my increased productivity more than makes up for the software cost.
Since the tool integrates so well into my existing workflow,
I felt that SQLyog Enterprise was a tool that helped rather
than hindered my productivity. So many software tools
require a great deal of overhead in maintaining and learning the tool
that I never use them to their full potential, whereas SQLyog Enterprise is
fairly intuitive enough that I was able to use it to do what
I needed within minutes of installing it. I had to migrate a database
from SQL Server to MySQL and the Migration Toolkit wizard made
mapping the fields and importing the data easy.
I also tend to do a lot of database backups and restores via MySQLdump,
and being able to easily backup and restore from a menu item is the biggest
time-saver that SQLyog Enterprise has to offer. Adding indexes, triggers
and relationships are also just a right-click away.
I'll never install phpMyAdmin again.
|
|
