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 …

You know, amongst all the announcements this week, I should also mention that MySQL has been accepted into the Google Summer of Code 2009, and all our students are ready to rock and roll. Its the community bonding period now, and we have a bunch more mentors that will participate, its very exciting. Check out the student list for MySQL. Yes, lots of phpMyAdmin and Drizzle stuff too. They’re all part of the extended community, no?

…

Video for the presentation at the 2009 MySQL Conference:

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
Thorsten von Eicken (RightScale, Inc)

Slides

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

Unfortunately, this video was cutoff, but most of the presentation is available.

read more

While sitting in krow's talk on Drizzle, I was hacking on my project to allow query logging to Gearman from Drizzle, and I found a couple of annoying bugs in GearmanD, and a critical bug in Drizzle. With MontyT's help, I found and fixed the Drizzle bug, and then showed the GearmanD bugs to EricD, who has gone off to fix them.

Maybe there will be an actual running demo of it all at my BOF this evening.

Two years ago, at the very first MySQL Conference that I attended, MySQL and IBM announced they were working a storage engine for IBM DB2.

When I went to work for MySQL PS, one of my first gigs was going to an IBM site and help them with that.

Now I'm sitting in this MySQL conference, watching the talk where the resulting storage engine is being publically described.

I feel some level of pride in my part creating this very odd duck.

... or how to misuse RBR to fill a MySQL table in the hopefully fastest way.

In my session yesterday I didn't had time to talk about this. The slide-desk covers it and I still wanted to document the idea at least.

The starting point is "Row Based Replication stores data in internal MySQL row-format." The slave can apply these events without any SQL parsing involved.

The idea is to create a master plugin that

• takes a file or something else that you want to INSERT into the mysql-server
• creates a binlog-stream using row-based replication events from it
• expose the binlog-stream and pretend to be a mysql-master (listen on port :3306 and handle COM_BINLOG_DUMP)
• let the MySQL-server connect to master-plugin using CHANGE MASTER TO and …

… or how to misuse RBR to fill a MySQL table in the hopefully fastest way.

In my session yesterday I didn’t had time to talk about this. The slide-desk covers it and I still wanted to document the idea at least.

The starting point is “Row Based Replication stores data in internal MySQL row-format.” The slave can apply these events without any SQL parsing involved.

The idea is to create a master plugin that

• takes a file or something else that you want to INSERT into the mysql-server
• creates a binlog-stream using row-based replication events from it
• expose the binlog-stream and pretend to be a mysql-master (listen on port :3306 and handle COM_BINLOG_DUMP)
• let the MySQL-server connect to master-plugin using CHANGE MASTER …

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 …