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 clients 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, Bank of America, JP Morgan Chase, UCLA, Verizon, SONY Pictures, Siemens, Segway, Lucent Technologies and thousands more...
|
Read what Press and Customers have to say...
 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 for $999 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.  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. Having used command line tools and phpMyAdmin for years to manage my databases,
I tried SQLyog Community Edition to do some exports from a server with a very
old version of phpMyAdmin.
I caught myself using SQLyog more and more to prototype queries,
alter database structures, do maintenance work and run incidental reports.
In the past I used phpMyAdmin to do this, but almost all work has shifted to
SQLyog. The best thing is not having to switch windows when working on a
complex query. Although phpMyAdmin is a good tool, it can't beat a
Windows application on responsiveness and usability.
This experience led me to buy a full version of SQLyog Enterprise,
which even has more features that help me speed up my work and make my life easier.
Auto completion in the query editor helps me remember table and field names,
saving me a lot of time looking them up. The best new thing I discovered so
far is the HTTP tunneling feature however, enabling me to work on databases that
don't accept external connections.
I'm discovering new features every day! I can't imagine how I ever did without... 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.
|
|
