MySQL Workbench is an extensible tool for database design, development, and administration – with support for python scripting and plugins, that can automate basic tasks.

Starting with MySQL Workbench 5.2.31, and with MySQL designers, developers, and administrators in mind, we’ve added a new plugin called MySQL Utilities. The MySQL Utilities is a set of python scripts that automate basic tasks. And as MySQL Workbench is about helping design, develop and administer databases, we’ve put the MySQL Utilities at your fingertips so you can quickly get to them and get your job done. Users will benefit from proven scripts, leverage the testing and ideas of the community and the experts at MySQL, and avoid having to reinvent common scripts…

Lets go on a quick tour…

The MySQL Utilities Plugin starts a shell that contains a set of python scripts that perform tasks such as copying, exporting, and importing databases, finding …

I only recently found out about GigaOm's upcoming Net:Work conference.  It's held December 9 at UCSF Mission Bay conference center.  While the name of the conference is a bit ambiguous, the actual area of focus is very clear: how will we collaborate in the 21st century?  

The impact of smartphones, tablet computing, social networks, Software-as-a-Service and Cloud computing is just starting.  As a result, I think there are tremendous opportunities for startup companies to disrupt existing markets with more modern, lightweight applications that foster collaboration inside the company as well as with partners, vendors, consultants and customers.  

…

Update: Thank you all for making this campaign a stupendous success. We are extending this offer till 3rd Dec 10, 23:59 PST succumbing to users demand. Many corporate users requested us to extend the offer as they require time to get official approval. Pick your copy right now! Use coupon code blkfrdy10 to get 50% off.

Happy Thanksgiving!

Black Friday is back with a bang! We are happy to offer a 50% flat discount on all Webyog products. Hurry up, this offer is valid only till 29th Nov 10, 23:59 PST 3rd Dec 10, 23:59 PST.

Still using SQLyog Community Edition? Upgrade to feature rich SQLyog Professional/Enterprise/Ultimate Edition. This offer is literally too good to pass up. Check out the features here.

Worried about your MySQL server’s health? Monitor it like a PRO. Get MONyog – MySQL Monitor & …

Now it's two and a half year since the last refactoring of HeidiSQL's dialog for editing user accounts. The current dialog was ok from a usability point of view, but it did not allow users to assign routine privileges on newer servers. And it edited and created users by updating the tables in the mysql db directly, which is error prone, complex and not recommended by MySQL.

The new dialog now does all updates by GRANT, REVOKE, RENAME USER and SET PASSWORD, as recommended by MySQL. The GUI has also evolved:
- you can clone users now
- the entered password must be repeated
- privilege names are painted in different colors for read, write and admin relevance
But see yourself:



To get it, just go to Help > Check for updates and install the latest build.

Now it's two and a half year since the last refactoring of HeidiSQL's dialog for editing user accounts. The current dialog was ok from a usability point of view, but it did not allow users to assign routine privileges on newer servers. And it edited and created users by updating the tables in the mysql db directly, which is error prone, complex and not recommended by MySQL.

The new dialog now does all updates by GRANT, REVOKE, RENAME USER and SET PASSWORD, as recommended by MySQL. The GUI has also evolved:
- you can clone users now
- the entered password must be repeated
- privilege names are painted in different colors for read, write and admin relevance
But see yourself:



To get it, just go to Help > Check for updates and install the latest build.

There's an interview with Baron Schwartz (that's me) on WebPulp.tv. Topics include the history of Percona's software such as Percona Server (our version of the MySQL database server) and XtraBackup, what we do at Percona, what tools we use to do it, how to think logically about performance optimization, what ugly surprises happen when you set up mysqldump backups and forget about them for a couple of months, and lots of other things. If you have not watched past episodes, I encourage you to do that. They feature a lot of really smart people from companies such as New Relic and 37signals. Josh is a great host for the show. He's a web engineer himself, and he knows how to ask probing questions that bring out a lot of interesting details about various web applications.

Entry …

We are pleased to announce the general availability of Zimbra Desktop 2.0!  This is a major milestone for the Zimbra team and includes significant feature and performance upgrades.  The difference between Desktop 1.0 and 2.0 is enormous thanks to the millions of downloads, thousands of forum posts, and hundreds of bugs posted by Zimbra customers and community members.

As most readers of this blog know, Zimbra Desktop is a completely unique client.  It’s the only free, cross-platform tool allowing you to meld your worlds on or offline – storing and syncing your email, …

Looks like 2010 is the year of multiplication in HeidiSQL: Some months ago I had implemented multiple query tabs. Then, each query tab became capable of displaying multiple results in subtabs. And now, we finally have multiple connections in the database tree. Thanks to monkeilas for constructive suggestions.

Recent Tips and News on Java EE 6 & GlassFish:

Exactly one month from today, OpenSQLCamp Boston 2010 will begin its technical content (we will have a social event on Friday evening, Oct. 15th, starting no earlier than 6 pm). Have you registered yet? It's 100% free! Make sure to get your flight before next week or the costs will go up, as it is generally more expensive to book a flight within 21 days of your trip. Also do not forget to book your hotel, we have a good rate of $149 per night for single or double occupancy....click here for details.

read more