During the process of building the new query analysis feature for MySQL Enterprise Monitor 2.0, we thought the best way to test it at a nascent stage was to use it to tune our own application (since we use MySQL as the backend repository). What we found was actually quite interesting. It also showed that even to seasoned developers, who know that frameworks while helpful, often aren't the most direct, concise way to get things done, can often do very strange things that you don't quite expect.

For those of you that haven't heard about the feature itself, "query analysis" takes all queries that are being processed by a MySQL server, normalizes them into something similar to a prepared statement form by removing literals, and then keeps track of total, min/max, average execution times, result set sizes, etc. at an aggregate …

Just to remind you that Packt Publishing is running their Open Source CMS Award again:

The Packt Open Source Content Management System Award is designed to encourage, support, recognize and reward Open Source Content Management Systems (CMS) that have been selected by a panel of judges and visitors to www.PacktPub.com. Now entering its third year, the Award has established itself as an important measure for quality and the popularity of Open Source Content Management Systems.

You have two more weeks to submit your favourite CMS in the following categories:

• Overall Winner
• …

I’d like to inform members of the MySQL™ Community about an amazing Program @ Sun™ Developer Network: the Campus Ambassador Program.

Quote:
Sun has more than 500 campus ambassadors worldwide who help spread knowledge and awareness of leading-edge technologies such as Java™, NetBeans™ IDE, OpenSolaris™, and many more.

Now that MySQL™ is part of SUN™ I guess that you can be ambassador of MySQL™ too, among the other SUN™’s products.

Quote:
Campus ambassadors are Sun™ Microsystems interns who build a Sun™ community on their school or university campus. They learn all about the latest Sun™ open-source technologies and share that knowledge with fellow students. This includes activities such as starting a Sun™ user group on campus, demonstrating Sun™ technology to fellow students, …

If only your database would just tell you that replication had failed or that the disk was full…
Ok some database servers do but MySQL doesn’t (yet). Another excuse to write a script

In my pursuit for total database visibility I have been searching for a tool that would tell me when something went wrong, that would simulate regular usage, and let me know if anything failed. After all SNMP can only probe so far and if your database is secure the last thing you want to do is open up another port on your server.

Don’t get me wrong there are tools out there that do a decent job of monitoring MySQL. MySQL Entperprise Monitor is one such tool. But if you want to look under the hood or add some functionality specific to your environment things start to get …

Currently, there are several great opportunities with exciting companies available in the New York area. If you're a rock star Java/PHP/Ruby developer or a pixel-obsessed designer, contact me at your earliest convenience.

Web Developer:

Give Real is a well-funded startup in the midst of an exciting period of growth and success. Our technology uses a patent pending platform that combines the ubiquity of credit card transactions and the power of social networks to create a new gifting experience.

Our primary platform is Rails, but there are programming challenges that range from SOAP APIs to Facebook application development. We are searching for full-time developers with expertise and broad experience in:

* Ruby on Rails (we also use rSpec, Starling, Memcache)
* MySQL
* xHTML & CSS, and comfort with Javascript
* Team development with tools like Git & Trac

…

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Sun continues to take a performance pounding, and the rumors of replacements, layoffs and revamps are beyond swirling and now perpetuating skepticism of the company. It strikes me as odd that Sun, which has embraced open source and is also the defacto leading corporate open source software contributor, is continually dogged by doubts about its transitions and tenures despite well-respected technology and participation in open source. Part of this lies in the company’s continuing dichotomy in strategy — a reference to tepid support for Linux and continued preference for and focus on Solaris. This is a large part of Sun’s ‘handicap,’ IMHO when it comes to Linux and open …

It's been a while since the last post. This is mostly due to me entering new territory in several ways. For one, I have been digging into JavaME development lately (platform change #1), building a mobile data entry and manipulation application that uses a an embedded database and talks to its server via Webservices, if connected. Otherwise data will be queued up locally and sent as soon as the