Hey all,

I hear that the collective "you" are annoyed by all of the technical bits on this blog. So I've decided to move non-personal blog entries to my movable type server at mt.colliertech.org. Specifically, work blog posts will be made to

http://colliertech.org/~cjcollier/mysql/

If this works well and I start making lots of posts, I will have the planet mysql aggregator point to the new atom feed:

http://mt.colliertech.org/mysql/atom.xml

good fun, that. For those of you who don't read this blog to get new and juicy bits of information about MaxDB and MySQL, rest assured that posts to this blog will now be easier to consume :)

Hey all,

I hear that the collective "you" are annoyed by all of the technical bits on this blog. So I've decided to move non-personal blog entries to my movable type server at mt.colliertech.org. Specifically, work blog posts will be made to

http://colliertech.org/~cjcollier/mysql/

If this works well and I start making lots of posts, I will have the planet mysql aggregator point to the new atom feed:

http://mt.colliertech.org/mysql/atom.xml

good fun, that. For those of you who don't read this blog to get new and juicy bits of information about MaxDB and MySQL, rest assured that posts to this blog will now be easier to consume :)

In this article, I'll give a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: "I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of the year" -- or anything similar that involves any number of SQL statements, and a schedule.

In the tradition of my 2003 and 2004 highlights, I'm posting my personal highlights of 2005. As in years past, this is mainly for my own benefit. I hope everyone has a wonderful 2006. :-)

• Launched the PHP Security Consortium (31 Jan)
• Interviewed for the first time (01 Feb)
• Launched Brain Bulb (28 Feb)
• Spoke at PHP Quebec for the first time (30 Mar - 01 Apr)
• Spoke at NOAA's IT Security Conference for the first time (04 May)
• Spoke at php|tropics (now …

Last week my laptop crashed and while installing the new one I decided to update my perl versions. I mainly use the DBD::mysql and DBD::Oracle modules and although I'm confortable building them on Linux/Unix, like most people I use the Activestate binaries on windows.

However it turns out that Oracle licensing changes now prevent Activestate from distributing an Oracle binary, so I was forced to build them from source. It wasn't easy, but now both the Oracle and MySQL modules are working. Here's the procedure in case it helps anyone.

Install Pxperl

Firstly, you probably want to move to the pxperl windows binaries. Pxperl support the familiar CPAN system for updates. Get Pxperl at www.pxperl.com. The installation should be straight forward.

I installed into c:\tools\pxperl

Install MinGW

You'll need a C compiler capable of building native windows binaries. I used the MinGW system. You can't …

I have lights on the front of my house!

Its been 15 months since that has been the case! I even have a
ceiling light in the entrance way. Sure... no ceiling, but I have a
light!

Amazing, my house now won't look like some sort of scary haunted
house from the street.

In other news I added bittype support to the archive engine in MySQL.
Eight characters to create.

Just have to love low hanging fruit....

I have lights on the front of my house!

Its been 15 months since that has been the case! I even have a
ceiling light in the entrance way. Sure... no ceiling, but I have a
light!

Amazing, my house now won't look like some sort of scary haunted
house from the street.

In other news I added bittype support to the archive engine in MySQL.
Eight characters to create.

Just have to love low hanging fruit....

As I mentioned in an earlier post: Brian Aker, MySQL's Director of Architecture, will be on a little grand tour of AU/NZ in the coming few weeks. Next week he'll be in Melbourne, speaking at the Melbourne MySQL User Group. Exact day/time: Wednesday 18 January, 7pm

If you're in Melbourne, do sign up (free) and RSVP for this event, Brian is an interesting guy.

As I mentioned in an earlier post: Brian Aker, MySQL's Director of Architecture, will be on a little grand tour of AU/NZ in the coming few weeks. Next week he'll be in Melbourne, speaking at the Melbourne MySQL User Group. Exact day/time: Wednesday 18 January, 7pm

If you're in Melbourne, do sign up (free) and RSVP for this event, Brian is an interesting guy.

Saturday I will be at Camp SysAdmin Bay Lisa, Usenix, and of course Splunk.

Wednesday of next week I will be in Melbourne for the MySQL meetup.
mysql.meetup.com/93/

The week after I will be at Australia's national Linux conference (which is actually in New Zealand)

On Tuesday the 31st I will be in Brisbane and attending the meetup there:
MySQL Users Group Brisbane (http://mysql.meetup.com/84/events/4811014/)

And somewhere else late that week but Groggy wasn't around to get me the information :)

I have Saturday night free in San Fran? Any thoughts on what I should go do?