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 and thousands more...
|
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.  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. 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!
From the moment I used the trial version of SQLyog I was impressed.
I knew that this was one tool that was well worth the investment.
I work as a MySQL DBA and consultant and it has saved me time and money.
One of the best features I found, was the ability to not only tunnel MySQL
over an SSH session to the same host I'm SSH'ing to, but I can also SSH
into a firewall and have it tunnel MySQL to a different server.
From a security perpective this is a great feature because it doesn't
require that I expose SSH on my database server.
Also, I was really impressed with the database syncronization tools.
There are numerous times where I have had to work on a customer's
replicated MySQL environment and this has given me the ability to do a
quick check to see if everything is in sync or not.
For anyone who is looking for a great, affordable MySQL tool, SQLyog Enterprise is
the best and well worth the money.
|
|
