Yesterday I blogged about the release of our latest Connector/Net product.  Version 5.1, this release includes the addition of a new namespace MySql.Web.  This namespace includes implementations of a Membership and Role provider.  These providers work together with the membership and role systems in ASP.Net 2.0 to provide a simple mechanism for web developers to add authentication and role support to their web properties.

As we were unable to include proper documentation for these new providers before release, I thought it proper to write down a few thoughts on how these work and how to use them.

1. Provide a connection string

The Connector/Net installer will register the providers in the proper sections of the machine.config file.  When registered, they reference a connection string that is non-existent.  To use the providers, you must provide a connection string that points …

It's starting to feel like conference season is in full tilt.  Last week we had the MySQL Conference with over 1,500 people and later this week is the SugarCRM developer conference.  Next week is the Red Hat Summit in San Diego.  I've been to this conference in the past, and it's a great technical event.  Lots of in-depth technical sessions with the gurus from Red Hat, their partners and the community.  The keynotes are also high quality (not commercial pitches) and the parties are great.  The conference is a good deal and includes 3 nights hotels and conference meals.  I hope to be at the conference for some announcements we're making. …

I'm sure I have a lot of cleanup to do... but....


mysql> show create table t1;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL
) ENGINE=FEDERATED_ODBC DEFAULT CHARSET=latin1 CONNECTION='obdc://Driver=myodbc3;Server=localhost;Database=federated_odbc;Port=5555;socket=/tmp/mysql-5555.sock;Option=3;UID=root:t1' |
…

Alrighty, I'm flying down in the morning and will spend Thursday at the OpenCeBIT conference and exhibition.

While in Sydney, I'll be scouting for potential MySQL support engineers in the APAC region, and signing up more sponsors for the OSDC conference. Just catch me on the ground at OpenCeBIT if you want to chat with me about either (or anything else), I'll be wearing a blue MySQL shirt.

Thursday evening (6.30pm) we're having the OSIA AGM so if you're an OSIA member this is a reminder to be there!

Baron Schwartz was nice enough to make recordings of about a dozen talks at the recent MySQL conference. The original uploaded files were in ogg format and wouldn't work on an ipod and weren't very portable.

With his help, I uploaded the original MP3 files and made a podcast which contains all the links to the sessions and should work fine with iTunes and an ipod.

Here's the link to the podcast. Just add it to iTunes or your favorite podcasting software and off you go.

Everyone likes to scale - Peter Van Dijck has got some top 10 presentations listed - Twitter, Flickr, LiveJournal, Six Apart (Vox), Last.fm, SlideShare, etc. Guess what these sites are all generally backed by? You guessed right - go MySQL. I however didn’t know that Bloglines was backed by Sleepycat.

If you’re interested in viewing some rather swanky MySQL-related presentations, check out the mysql tag on SlideShare, as well.

I especially like Brad Fitzpatrick’s …

MySQL AB today announced that the EUROPAGES international business directory has chosen MySQL Enterprise to power its critical online applications.

Dtrace is one of the coolest things in Solaris 10, adding great observability to applications. A Dtrace provider for PHP that adds probes to function entry and exit points has long been available. I finally got around to integrating this with the php in Cool Stack. 

Bryan Cantrill has some excellent examples of how to use dtrace to trace through your php code, down to the system libraries and kernel (if you want to go that far !) .

Instructions for installing the php dtrace extension

1. Download the shared library for the extension :

    dtrace.so.x86.bz2

…

Baron Schwartz was nice enough to make recordings of about a dozen talks at the recent MySQL conference. The original uploaded files were in ogg format and wouldn’t work on an ipod and weren’t very portable.

With his help, I uploaded the original MP3 files and made a podcast which contains all the links to the sessions and should work fine with iTunes and an ipod.

Here’s the link to the podcast. Just add it to iTunes or your favorite podcasting software and off you go.

This is the first part, in what hopes to be, a series where I go through the entire process of building a storage engine for MySQL.

The first thing to do is to download the skeleton engine. You can find the latest copy at:

http://hg.tangent.org/skeleton-mysql-engine?ca=tip;type=gz

You will need to untar and uncompress the file. The Skeleton engine is a basic bare bones engines which is a starting point for creating a storage engine project (the memcache, PBXT, AWS, HTTP, Google File system and many other engines all evolved from it).

What you will find once you download the engine and cd into its directory, is that it doesn't have a configure file just yet. To generate one, run the following:


[brian@zim skeleton-mysql-engine]$ sh config/bootstrap
+ aclocal …