Barry, Vladimir and I (the entire PrimeBase dev team!) will be presenting next week at the MySQL User Conference and Expo.

We've got lots of cool stuff going on. Barry will tell you how PBMS can store your BLOBs in the clouds, Vladimir will be explaining what makes PBXT so fast, and I will be talking about the past, the present and the future...

Even if that all doesn't interest you, be sure to just drop by to say hi. We're friendly, really! :)

The PBXT Storage Engine: Meeting Future Challenges
Paul McCullagh
3:05pm - 3:50pm Tuesday, 04/21/2009
Ballroom B

BLOB Streaming: Efficient Reliable BLOB …

The Memcached Functions for MySQL are user-defined functions that I have written to use with MySQL that allow you to interact with one or more memcached servers from within MySQL. These allow you the ability to use MySQL as a one-stop-shop to obtain data both from MySQL (durable data) and memcached (cached, non-durable data). These functions also allow for not having to require using a particular client library such as Perl or PHP to use memcached.

Installation

1. You will need a working MySQL instance. I won’t tell you how to get this. You can figure it out. Your a smart person and wouldn’t be even reading this article if you didn’t have MySQL running, right?

2. memcached server. Many Linux distributions come with memcached pre-installed, but often the version is stale, old, yellowy. You want to be running at least 1.2.6. You can easily check by doing the following:

telnet localhost 11211
Trying ::1... …

What is open source, production-quality, supported by a large vibrant community, and comes with full enterprise support ? - GlassFish and MySQL.

Did you know that GlassFish ...

• is the only open-source Java EE 5 compliant Application Server
• can be used to deploy Rails, Grails, and Django applications
• has 13x better price/performance than Dell/HP, and therefore a much lower TCO
• has an easy-to-use and intuitive web-based administration console
• has enterprise features like clustering/high availability, .NET-interoperable Web services, ...

Are you attending MySQL Users Conference 2009 …

As I mentioned in my previous entry, InnoDB has it’s own auto increment counter which it uses to generate the next value for the database kernel (as we call it in Drizzle). At Drizzle project, we came across a suspicion that InnoDB doesn’t increment it’s internal counter on row updates. So what can this mean to you as a database admin?

Well, consider this simple table:

CREATE TABLE t1 (
    a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    val INT
) ENGINE=InnoDB;

and the following statements:

drizzle> INSERT INTO t1 (val) VALUES (1);
Query OK, 1 row affected (0.01 sec)
 
drizzle> UPDATE t1 SET a=4 WHERE a=1;
Query OK, 1 row …

I’ve been using the MySQL Workbench 5.1 beta for the past few days now, and I’m wondering how I designed databases without it.

Okay, so that’s a pretty strong statement, but I’m genuinely happy with it. 5.1 has fixed my main problem with 5.0, in that the EER diagram mode was horribly slow to render, now it’s all nice and smooth. The ability to easily visualise tables and their relationships makes design very simple.

In fact, I really only have one (minor) complaint, the ability to export without foreign keys would be nice. Sometimes you just don’t want to deal with the performance hit.

That’s about it. Go and download the OSS edition for free now, have a play around. Make it your Friday afternoon experiment. I promise you’ll like it.

Today I spoke with Farhan “Frank” Mashraqi, former Fotolog DBA, now working at a startup, NetEdge, working on social analytics. He’s talking about the two sessions he’s giving next week at the MySQL Conference & Expo 2009, as well as the benefits of being at the MySQL Conference & Expo.

He’s giving two talks:

1. Hadoop and MySQL: Friends with Benefits in where he will tell you about how you can combine data sets and queries, some of which run on Hadoop, and others which run on MySQL, but eventually probably end up in MySQL (he works on this cool stuff at NetEdge, the startup he’s currently attached to). …

I am calling it.  The death of the PHP die function.  Now, I have no actual authority to do so.  My PHP CVS karma does not extend that far.  And I doubt it will actually get removed despite it being nothing more than an alias for exit now.

No, what I would like to call a death to is the usage of die such as:

$conn = mysql_connect($server, $user, $pass) or die("Could not connect to MySQL, but needed to tell the whole world");
I don't know who thought that particular usage was good, but they need to .... no, that is harsh.  I just really wish they had never done that.

So, what should you use?  Well, there are a couple of options depending on what context you are working in and whether or not the failure is actually catastrophic.

…

What is open source, production-quality, supported by a large vibrant community, and comes with full enterprise support ? - GlassFish and MySQL.

Did you know that GlassFish ...

• is the only open-source Java EE 5 compliant Application Server
• can be used to deploy Rails, Grails, and Django applications
• has 13x better price/performance than Dell/HP, and therefore a much lower TCO
• has an easy-to-use and intuitive web-based administration console
• has enterprise features like clustering/high availability, .NET-interoperable Web services, ...

Are you attending MySQL Users Conference 2009 …

What is open source, production-quality, supported by a large vibrant community, and comes with full enterprise support ? - GlassFish and MySQL.

Did you know that GlassFish ...

• is the only open-source Java EE 5 compliant Application Server
• can be used to deploy Rails, Grails, and Django applications
• has 13x better price/performance than Dell/HP, and therefore a much lower TCO
• has an easy-to-use and intuitive web-based administration console
• has enterprise features like clustering/high availability, .NET-interoperable Web services, ...

Are you attending MySQL Users Conference 2009 …