If you’ve attended just one of my recent talks, either at the UC, LOSUG or MySQL University, you should know that MySQL 5.1.30 will be in the next official drop of OpenSolaris.

In fact, you can find MySQL 5.1 in the current pre-release builds – I just download build 111 of the future 2009.06 release.

Key things about the new MySQL 5.1 in OpenSolaris:

1. Contains the set of DTRACE probes that also exists in MySQL 5.4 (see DTrace Documentation)
2. Like the 5.0, we have SMF integration, so you can start, stop, monitor and change some of the core configuration through SMF
3. Directory layout is similar to 5.0, with a version specific directory (/usr/mysql/5.1), and the two can coexist if you want to handle a migration from 5.0 to 5.1

To install MySQL 5.1, use the pkg tool to …

I had the pleasure to sit on the Performance Panel at the recent Percona Performance Conference. While the panel contained a number of usual MySQL suspects, one person was not familiar, that being Cary Millsap from Method R.

An expert in optimizing Oracle performance, Cary also gave an session on Day 2 that I attended. While he opened professing not to be an expert in MySQL, his talk provided valuable foundation knowledge irrespective of whether you use MySQL or another database product.

Having come myself from 7 straight years in system architecture and performance tuning in Ingres, then a further 6 years in Oracle again heavily involved in system architecture and performance tuning, a lot of my …

1. Flare -- dynamically partitioning and reconstructing key-value server. Currently built on Tokyo Cabinet, but backend is theoretically pluggable. (via joshua on delicious)
2. Implantable Device Offers Continuous Cancer Monitoring -- the sensor network begins to extend into our bodies. The cylindrical, 5-millimeter implant contains magnetic nanoparticles coated with antibodies specific to the target molecules. Target molecules enter the implant through a semipermeable membrane, bind to the particles and cause them to clump together. That clumping can be detected by MRI (magnetic resonance imaging). The device is made of a polymer called polyethylene, which is commonly used in orthopedic …

Tomorrow (Wednesday, May 20, 2009), Ulf Wendel and Andrey Hristov, engineers working in the Connector team of Sun|MySQL database group, will be presenting a webinar about the new MySQL Connector/C++. This connector, which uses much the JDBC API patterns, was recently made available as a GA release during the MySQL Conference and Expo.

Register from anywhere in the world and listen to Ulf and Andrey as they talk to you about Connector/C++ from somewhere in Germany!

Addendum: At this very moment, I'm attending this free Webinar. It is truly amazing how well-coordinated this is. So, if you couldn't get to this, try to make it to some other upcoming MySQL Webinar.

Recently on a client site I had to fight the pain of having no way to confirm loss of data integrity when optimizing data types. Due to MySQL’s ability to perform silent conversion of data, when converting a number of columns we enabled sql_mode to catch any truncations as errors.

sql_mode=STRICT_ALL_TABLES

This ensured that should any data truncations occur, an error is thrown not a warning. The following shows an example case study for converting an INT to TINYINT UNSIGNED and shows that without sql_mode silent conversions occur.

mysql> drop schema if exists tmp;
Query OK, 25 rows affected (0.40 sec)

mysql> create schema tmp;
Query OK, 1 row affected (0.01 sec)

mysql> use tmp
Database changed
mysql> create table t1(i1 INT NULL);
Query OK, 0 rows affected (0.15 sec)

mysql> insert into t1 values(1),(2),(3),(256),(65536),(NULL);
Query OK, 6 rows affected (0.06 sec)
Records: 6  Duplicates: 0  Warnings: 0 …

Tomorrow (Wednesday, May 20, 2009), Ulf Wendel and Andrey Hristov, engineers working in the Connector team of Sun|MySQL database group, will be presenting a webinar about the new MySQL Connector/C++. This connector, which uses much the JDBC API patterns, was recently made available as a GA release during the MySQL Conference and Expo.

Register from anywhere in the world and listen to Ulf and Andrey as they talk to you about Connector/C++ from somewhere in Germany!

Addendum: At this very moment, I'm attending this free Webinar. It is truly amazing how well-coordinated this is. So, if you couldn't get to this, try to make it to some other upcoming MySQL Webinar.

Tomorrow (Wednesday, May 20, 2009), Ulf Wendel and Andrey Hristov, engineers working in the Connector team of Sun|MySQL database group, will be presenting a webinar about the new MySQL Connector/C++. This connector, which uses much the JDBC API patterns, was recently made available as a GA release during the MySQL Conference and Expo.

Register from anywhere in the world and listen to Ulf and Andrey as they talk to you about Connector/C++ from somewhere in Germany!

Addendum: At this very moment, I'm attending this free Webinar. It is truly amazing how well-coordinated this is. So, if you couldn't get to this, try to make it to some other upcoming MySQL Webinar.

As the recipient of the 2009 MySQL Community Member of the Year award I received a MySQL crystal ball. While it looks good in my bookcase, unfortunately the best advice I can offer during this time of uncertainty is “watch this space”.

A number of topics where information is still very much unknown and I’m either asked about, or am following includes:

• The Oracle acquisition of Sun, owner of MySQL.
• MySQL 5.4 Alpha release and schedule for production release
• The end of MySQL 5.0 Community/Enterprise split
• The future of Falcon in MySQL 6.0?

Thanks to Julian Cash of the Human Creativity Project of his photograph at the 2009 MySQL Conference.

…

The announcement last month of Oracle to acquire Sun continues to warrant a lot of discussion over exactly what Oracle will do with MySQL. Only time will tell what will happen with the official product, however it is important to remember that MySQL is GPL, there will always be a free version of MySQL available for popular LAMP stack products such as WordPress and Drupal and new and existing startup’s will continue to use MySQL.

This announcement will see Oracle resources begin to better understand and evaluate MySQL. As a resident MySQL Expert, I also have a strong background in Oracle having also worked for Oracle Corporation. I have also delivered several successful one day and half day workshops on MySQL/Oracle related content including:

• 2009 - Best Practices …

Sorry for the (relatively) short notice, but I will be talking at Sun’s CommunityOne conference in San Francisco on June 1st.

I’ll be talking about, and demonstrating, the DTrace probes we have put into MySQL in a joint presentation with Robert Lor who will be doing the same for Postgres.

CommunityOne West Badge

Our presentation is on the Monday afternoon.

Check out the CommunityOne West Conference Site for more details and registration.