A Federated Table is a table which points to a table in an other MySQL database instance (mostly on an other server). It can be seen as a view to this remote database table. Other RDBMS have similar concepts for example database links.

class Guard {
public:
Guard(NdbMutex *mtx) : m_mtx(mtx) { NdbMutex_Lock(m_mtx); };
Guard(NdbLockable & l) : m_mtx(l.m_mutex) { NdbMutex_Lock(m_mtx);
};
~Guard() { NdbMutex_Unlock(m_mtx); };
private:
NdbMutex *m_mtx;
};

Traffic at www.mysql.com has continued to increase and over the last few months, we've broken into the top 500 websites according to Alexa.  While the Alexa rankings are not perfect, they do enable relative comparisons between sites and over time.  For example, MySQL's traffic surpassed Oracle's back in April of this …

It's been an interesting last few weeks for me and MySQL. One of my side projects (I currently have three, two are MySQL-focused) provided an opportunity to really dig into the MySQL source code (5.1 tree). For many of my evenings for the past few weeks I've been hacking away, fiddling with the kind of MySQL customizations I've previously only seen other folks do.

The list of customizations:

• 
  
• build a user defined function (UDF) that gets dynamically loaded into MySQL
  
• add a new native (built-in) function to the MySQL source code
  
• create a storage engine using the pluggable storage engine architecture
  
• create a new SHOW command
  
• create a new virtual table in the INFORMATION_SCHEMA database
  

And of course, while I was in there I threw …

Swedish telecom vendor Teligent has employed several different databases in its products in the past -- including Oracle, Berkeley DB and Microsoft SQL Server -- but now the company has chosen MySQL Cluster to be the standard for its Teligent P90/E platform, on which its products are based. Teligent supplies innovative network services like voice message systems, Mobile data and VoIP to operators like British Telecom, Deutsche Telekom, TeliaSonera and Vodafone.

The International PHP Conference in Frankfurt is coming up again, 5-8 November. Running in parallel is the Open Source Database Conference (reg is free if you're at the PHP conf).

I'll be doing a tutorial and a few sessions:

• Power Workshop: MySQL 5.1 in Depth
• MySQL Falcon Storage Engine
  
• An Introduction to MySQL Cluster: Architecture and Use
  
• Confession Time: Deadly Sins using MySQL and PHP

Check out the site for all the details. Of course there's plenty of other sessions and tutorials from some great PHP and database experts, including Giuseppe Maxia and Peter Zaitsev on MySQL.

Perhaps I'll see you there?
I'll actually be travelling on to The Netherlands afterwards (holiday) , with my wife Harmony and daughter Phoebe. So if you're at the conference you can meet them too! …

Motorola Announces Intent to Develop Java ME Stack Under Apache License Version 2.0 , Motorola (Press Release)

NetBeans Community Reaches Latest Milestone With General Availability of Open Source NetBeans 5.5 Integrated Development Environment, Sun Microsystems (Press Release)

rPath Supports Virtual Appliances for Xen 3.0.3, rPath (Press Release)

Time to Short Open Source?, The Motley Fool, Tim Beyers (Article)

Oracle Linux …

It's inevitable that if you play in the MySQL source code for long enough you'll eventually stumble into the source for the show authors command and be tempted to do something with it:

mysql> show authors;
+---------------------------+------------------------+-----------------------------------+
| Name                      | Location               | Comment                           |
+---------------------------+------------------------+-----------------------------------+
...
| Mike Kruckenberg          | Boston, MA, USA        | Just one line of code, this one   |
...
+---------------------------+------------------------+-----------------------------------+

Some more tools were added to my collection.

Some more database benchmarks were added to my collection.