Video for the presentation at the 2009 MySQL Conference

Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040

Play the video directly in your browser
Download the video

I presented on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans. The key messages conveyed during the preso are:

• GlassFish is an open source community and delivers production-quality Java EE compliant Application Server.
• GlassFish v2 is the Java EE 5 Reference Implementation and GlassFish v3 for Java EE 6. Read complete difference here.
• Java Persistence API makes it really easy to create database-backed Web applications. It even creates MySQL-specific queries, when possible.
• The web-based administration …

I presented on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans. The key messages conveyed during the preso are:

• GlassFish is an open source community and delivers production-quality Java EE compliant Application Server.
• GlassFish v2 is the Java EE 5 Reference Implementation and GlassFish v3 for Java EE 6. Read complete difference here.
• Java Persistence API makes it really easy to create database-backed Web applications. It even creates MySQL-specific queries, when possible.
• The web-based administration …

• Peeping into memcached.

Really interesting read about how to examine what’s stored in memcached.

Peep uses ptrace to freeze a running memcached server, dump the internal key metadata, and return the server to a running state. If you have a good host ejection mechanism in your client, such as in the Twitter libmemcached builds, you won’t even have to change the production server pool. The instance is not restarted, and no data is lost.

Highlights include scalability improvements, subquery optimizations and join improvements, improved stored procedure management, out parameters in prepared statements, and new information schema additions.

The first production release of MySQL Connector/C++ is available, please see the official announcement. You can download source and binary packages from http://dev.mysql.com/downloads/connector/cpp/1.0.html. A long and detailed getting started type API introduction article is waiting for you in the DevZone. The documentation has sections on how to set up NetBeans or VisualStudio projects for creating client applications.

During beta we learned about a pitfall: binary portability on Windows and Linux (generic builds). Forum users …

In a few hours I will give my talk on mysqlnd. Well, the talk is not mine but we wrote it together with Ulf Wendel, of the MySQL Connectors Team fame. Although we haven't added much functionality to mysqlnd in the recent months mysqlnd is still pretty advanced and started to mature. I will talk about why mysqlnd is unique, why is it cool, why is it fast, and why you should use it!

Yesterday I gave my talk, in front of not that many people, about Connector/C++ at the MySQL UC 2009. Not too many questions came from the public, but this is a new product which very specific target group. You know, almost nobody writes Web applications in C++. And Java is the server language for the Enterprise. So I should have expected not many people in the room.

If you have missed the talk, don't worry. In May there will be a webinar which you can attend and if you miss it, you can just watch it at later time. The webinars are recorded and offered freely.

Yesterday the Connector/C++ got the GA stamp and we officially support it. Although we are going to make changes, mostly backward compatible, because this GA, 1.0.5, added the basic functionality the people need to use MySQL with C++ without using the weird libmysql API, which makes your life hard, if you don't use boost and start to get exceptions - you are gonna leak big …

Video from the 2009 MySQL Conference presentation:

If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)

The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363

Download the presentation slides (ppt).

It was a standing room only crowd at the MySQL Conference and Expo this morning in Santa Clara. With more than 2,000 attendees, this is the largest crowd the conference has ever drawn, which is saying something given that most conferences are projecting much lower numbers with the economic downturn. Perhaps open source is counter-cyclical after all and will continue to do well in tough times.

read more

At the MySQL Users Conference, Ken Jacobs from Oracle announced an embedded version of InnoDB, using a low-level, non-SQL interface, but still providing the transactional and other features of InnoDB. This is an interesting development, and I assume that this could be competitive to libmysqld, which you know is near and dear to my heart.

Frankly, I don't think this is the case. Libmysqld still has the edge on having SQL access and being available with more engines. But I DO see a place for Embedded InniDB which is in the really small devices, where not even libmysqld would fit, but you still need transactional capabilities.

But I do admit that this announcement takes some of the glamour away from my presentation on …