“Publishing software in English will make you reach most of the global audience” is a myth. Users like software in their own language. For Non-English speaking audience localized software is a necessity. We heard it. SQLyog is now available in Japanese & will be made available in other international languages soon. We are using crowd-sourced human translation services from myGengo for translating SQLyog. I’d also like to add that our website is machine translated using Google Translate.

Embedded below are some related screenshots:

Option to change language

SQLyog in Japanese

If you want to do your own translation, we will soon provide instructions and tools …

We have released SQLyog 9.2 GA with enhancements to the Data Search feature (and more).

Since we introduced the Data Search feature in SQLyog 9.1 we had a lot of positive responses – but also a few critical remarks that using the feature could cause unnecessary server load as well as unnecessarily long response times. Such scenario could arise when searching for a string in a BLOB column used for storing media files for instance. Or when searching all tables of a database when there was only need to search a few tables.

We have addressed this concern by adding filter options that let the user restrict the search to specific data types and to a subset of databases of a server, a subset of tables of a database or a subset of columns of a table.

Also we have added “+” and …

Until now, MariaDB 5.2 was lacking a yum repository for easy installs and upgrades. It is now available, thanks to OurDelta.

Just follow our very simple installation instructions.

With this release we further enhance the ease of MONyog customization. This includes:

* This release ships  with a bunch of useful Dashboard charts which can be enabled/disabled from the ‘manage dashboard charts’ in the Dashboard page. Users will not need to write any Javascript to enable those.
*  Dashboard charts can now be reordered. User will be able to place those most important for him on top.
*  Added an option to copy/duplicate advisors. This can be used as a template to make a new Monitor/Advisor.

See the new interface for Dashboard configuration interface here:

Further we added an option to alert on server configuration change and fixed a few minor bugs.

Downloads: …

I don’t need to emphasize how productive you can be if you find what you are looking for in a quick and easy way. Google has shown it to us. Wouldn’t it be fun to have the same ease and speed while searching for data in your databases? Well, that’s what Data Search is all about. Find the data you want without writing any queries or worrying about the underlying schema. Type in the search string and you’ll have a table of all search results waiting to be clicked and be taken to the exact cell of the table. It also supports search operators like AND, OR and “”. Note that the results of this search is not the same as WHERE clause query results. Its rather a natural way of search. Lets say its like googling your database. For better precision you can search with regular expressions too.

…

Please note that when upgrading from a version previous to 4.5  to this one, it is required that MONyog detects the replication topology of registered servers before the ‘registered servers’ page can display. This may take a few minutes with a large number of registered servers. Please be patient for as long. Note that this delay will only happen once.

Changes (as compared to 4.5) include:

Features:
* This release focuses on improving performance of the MONyog built-in HTTP daemon. You will find up to 10 times performance improvements for most MONyog pages. This has been achieved by internal code optimizations, use of compression (if browser supports) and minification/optimization of HTML, Javascript, CSS and graphics.

Bug fixes:
* Prepared statements were not handled properly by the Query Analyzer.
* Events (as …

Hi,

We are delighted to announce the release of MONyog 4.5. Listed below are some noteworthy features:

• You did get to know about what needs attention in Monitors/Advisors, but how about looking at all the alerts that need attention grouped on their severity for a certain period? This is what event is all about. An event occurs when the status of a counter changes. Keep your events tab open & you see MONyog alerting you – may it be “server availability” or “replication failure” or many other umpteen things that need attention.
• Many a times, MONyog shows an alert to bring your attention, but you are OK with that & don’t want to fix it. Just close the event & it will appear only when it becomes alert-able again. This is a nice way to accept & dismiss events, so that you can start with a clean slate with a baseline for normal acitivity for that instance.
  …

This is the first GA release in a new major branch of the SQLyog MySQL GUI.

This release introduces an easy way to look up proper values for values inserted to columns that have a Foreign Key CONSTRAINT.  Foreign Key CONSTRAINTs can be difficult to handle for a human user because when updating a ‘child’ table valid values for columns that have such CONSTRAINTs  in the  ‘child’ table will often be ‘just a code’ ( an autoincrement integer or some very ‘compressed’ and ‘symbolic’ values (like item numbers, order numbers etc.).

This SQLyog release provides a direct way to look up in ‘parent’ what should be inserted in child. It works like this: In both GRID and FORM mode a ‘…’ symbol will display if the actual column has a Foreign key CONSTRAINT. If you enter some value in the cell and next click this button SQLyog will find all matches for what you have …

We are pleased to announce a new and improved GA version of SQLyog MySQL GUI. The highlights of this  release (8.8) are:

* Drastically improved memory management in DATA and RESULT tabs. This allows for larger result sets in memory and significantly improves scrolling with large result sets.

* Added a sql_mode setting for connections. There is an option to let the GLOBAL mode apply for the session as well as to specify a sql_mode for the connections. The setting is stored on a per-connection basis. Sometimes the GLOBAL sql_mode setting on server is not the best option for a GUI tool and sometimes you may want to take special precautions by setting a specific sql_mode different from the GLOBAL mode.

* With HTTP-tunneled connections to MySQL connection through Unix SOCKET is now possible by specifying the path to the MySQL Socket file on the server …

Cloud, cloud, cloud. Cloud computing has become the phrase du jour, says one analyst from Gartner. But with many moving to cloud for its obvious benefits, it can no longer be ignored. An offshoot of cloud computing is utility computing. What interests us here is Database-as-a-Service, in particular MySQL on cloud.

Coming back to our original question – Is your MySQL monitoring tool cloud ready? Well, many monitoring tools need agents on server to be monitored. For obvious reasons database-on-cloud vendors don’t allow one to install anything on the servers. With Amazon launching RDS (which is nothing but MySQL instance on cloud) there is a pressing need for tools that …