David Stokes mentioned yesterday that the mid-April Orlando Florida “Collaborate 11″ conference has many MySQL-related sessions.

I (Peter Gulutzan) emphasize these session titles, presenters, and what they represent:
MySQL 5.5 Replication by Lars Thalmann (MySQL replication team)
InnoDB: Performance and Scalability Features by Inaam Rana (MySQL InnoDB team)
MySQL Backup and Security - Best Practices by Lenz Grimmer (MySQL community team)
InnoDB: Status, Architecture and Latest Enhancements by Calvin Sun (MySQL InnoDB team)
Sharding Techniques for MySQL by Mats Kindahl (MySQL replication team)
When Things Go Wrong: How to Find SQL Error by Sveta Smirnova (MySQL support team)
MySQL, Oracle and …

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 …

Monty Widenius has announced that Trudy Pelzer's and
Peter Gulutzan's reference book "SQL-99 Complete, Really" is now
available on the askmonty.org knowledge base
http://monty-says.blogspot.com/2011/01/sql-99-complete-really-now-freely.html

Of course I agree with Monty's praise of our book, but
remember that for more current SQL-standard
information I occasionally post here on blogs.mysql.com/peterg.

When you have an .sql with a huge number of single INSERT statements, such as this:

INSERT INTO mytable (id, name, ...) VALUES (1, 'foo', ...);
INSERT INTO mytable (id, name, ...) VALUES (2, 'bar', ...);
INSERT INTO mytable (id, name, ...) VALUES (3, 'xyz', ...);
...

Such dumps take quite a long time to import normally, as there is a significant overhead per query, multiplied many times for large dumps. HeidiSQL now can package such statements into one larger multi statement query and send this at once the server. As I was testing 4000 INSERTs on a local, simple table I experienced a huge performance improvement:
- single queries: ~40 seconds
- one packaged multi stament: <1 second.

HeidiSQL automatically calculates a package size of some kb below your max_allowed_packet size. Which is in some cases not small enough as I noticed connection cut offs as I sent …

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 …