While taking a quick look at the newly released docs for Falcon, the new storage engine for the MySQL database from MySQL AB (and this is important, as actually InnoDB and the now ditched BDB storage engines for MySQL database are from Oracle) I noticed two "strange" things, at least to someone thinking of large databases running on dedicated hardware.
First of all the data storage, chapter 14.6.5.1. Falcon data file and data structures reads:

A single Falcon database file stores all record data, indexes, database structure and other information. ...

This doesn't sound like a good idea for me as it's better to keep indexes and data separated on different disks and something like Oracle's implementation of tablespaces and the ability to assign indexes and data to different tablespaces hosted on …

For the fourth consecutive year, I'm going to try to record my personal highlights from the previous year.

To get things started, here are a few memories from 2006 off the top of my head:

• I had an amazing surprise 30th birthday party featuring the Sallymacs.
• I played Midnight Madness for the fourth consecutive year.
• I saw FC Barcelona play in New York.
• I played on OmniTI's inaugural football club, OmniTI FC.
• I began using a MacBook Pro (connected to a 30" display) as my primary desktop.
• Essential PHP …

You may or may not have heard of it, SQLite has them, but what is a manifestation type (I'll call them mtypes from now on)?

You can think of an mtype as a untyped variable with a twist. That is you can assign anything you want to it without having to first declare its type OR size. But first lets look at a typed variable example using the C programming language. In C if you want to store a string you will need to declare a fixed char array or create a char pointer to some malloc'd memory cast as char:

// fixed length array
char str[28];

or

// malloc'd fixed length array
char *str;
str = (char)malloc(sizeof(char)*28);

You need to know ahead of time how much space you will need to store a string. If your string was longer than 28 characters you would lose everything after character 28, safely off course by being sure not to write more than 28 bytes ;) …

Matthew Aslett is reporting on MySQL's mostly unnoticed licensing change. As he notes, it's not really a change, so much as putting a stake in the ground to keep MySQL on GPLv2 for the future. As Kaj (VP of Community for MySQL) notes on his blog:

MySQL has today refined its licensing scheme from “GPLv2 or later” to “GPLv2 only“, in order to make it an option, not an obligation for the company to move to GPLv3.

Specifically, this means that copyright notice in the MySQL source code files will change from referring to “either version 2 of the License, or (at your option) any later version” to “version 2” only, in the MySQL 5.0 and MySQL 5.1 code bases.

This is not a once-and-for-all decision, but rather gives MySQL breathing room to wait …

One of the unique elements of MySQL is the ability to use a different storage engine to store your data. You can even mix and match storage engines within the same database.

read more

This is a weird world. I’ve learnt that the Falcon tree is now public thanks to following Brian’s blog (which thankfully I follow, not just thru Planet MySQL, which is also unreachable), and reading Slashdot’s RSS feed. I was sure there was going to be email, and today, I’ve managed to suck mail from the MySQL’s mail server thru some convoluted means and find the announcement :-)

The Taiwan quake has made Streamyx’s quality of service extremely low. More importantly, it’s not allowing me to write or get mail (something I haven’t done in a while). I sincerely hope that no one’s doing silly BitTorrents or podcasts (I think downloading MP3 files fail immediately, or I just can’t even connect to PodShow and get my Daily Source Code), and that some magic routing starts working.

…

Digium Unveils New Software Appliance AsteriskNOW, Digium (Press Release)

MySQL is on track with new storage engine, Computerworld, Jeremy Kirk (Article)

Asterisk an under-appreciated Open Source Success Story, O’Reilly Radar, Tim O’Reilly (Blog)

Mozilla’s 2005 revenue: $52.9 million, News.com Open Source and Standards Blog, Stephen Shankland (Blog)

A hypothetical New …

This week’s podcast is an interview with MySQL’s Stewart Smith, software engineer for MySQL Cluster. Straight from the warm southern hemisphere, Stewart talks about Cluster. Because we gabbed on and on for 19 minutes, we’ve stripped the format down a bit, having the feature as pretty much the only segment.

You can download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Direct play this edition at:

http://tinyurl.com/yd2ccc

Feature

Main cluster website:
http://www.mysql.com/cluster

Cluster documentation (in the manual):
…

There's an interesting article called "Open Source 2007" that appears in Educause Review magazine.  The irony is that the article was published in 2004 and was somewhat avant garde at the time.  While it's hard to make predictions (especially about the future!), it's clear that most of the ideas on open source have come to be accepted.  Brad Wheeler, CIO of Indiana University and an open source advocate with the research and statistics to back up his views, makes a compelling case for why open source will has already become mainstream. Adoption of open source software --both infrastructure and applications-- has accelerated faster than many have predicted, though perhaps it has become more accepted in commercial markets and among high-tech companies than in academia. 

…

The folks at del.icio.us must have made it harder to get on to the del.icio.us/popular page over the past few months.

When I first was listed on there you simply needed 10 bookmarks within the past 24 hours. I was looking at the article I published yesterday MySQL Optimization Hints and noticed that it has 28 bookmarks over the past 24 hours, and has not yet been listed on the popular page.

It appears that they still require only 10 recent bookmarks, but they have shrunk the window for what they call recent. It must be down to 10 bookmarks within 12 or 6 hours. Does anyone know the specifics?