In MySQL, it's possible to comment out portions of code that you only want to work in specific MySQL versions:

i.e.
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `a` /*!40100 DEFAULT CHARACTER SET latin1 */;

The problem with this, is that the decimal point is omitted - and there's a real assumption that with something like 3.23.12 the "12" portion never exceeds 99.

When I look at 5.0, MySQL is currently at 5.0.60 - and there are still minor changes happening. 5.1 is at 5.1.25, and not even GA. Assuming that 5.1 does the same community/enterprise split and shuffles through releases in even numbers, how long will it take before we have 5.1.100?

If we do get there, the SQL commenting feature will need upgrading.

Sun Microsystems, Inc. today announced the general availability of MySQL™ Cluster Carrier Grade Edition 6.3, the latest version of its high-availability open source database, especially designed and certified for use in carrier grade telecom environments, such as Subscriber Data Management systems (HLR, HSS) and in Service Delivery Platforms. This new release enables Service Providers and Network Equipment Providers to deploy larger database applications and provide data availability across geographies in case of site-level failure. Additional MySQL Cluster 6.3 information and downloads are available now at www.mysql.com/cluster.

OmniMySQL 0.0.4 is a minor release fixing two bugs that I should have caught (it now crashes less). The current release can be downloaded here.

Since meeting yesterday with Vladimir Voskresensky, a Sun colleague from St Petersburg, I have a new favourite answer to the request “so tell me an example of technical advantages resulting from Sun’s acquisition of MySQL“:

Using NetBeans as an IDE (Integrated Development Environment) for coding and learning MySQL.

Now, that’s a simple answer, and that’s because it’s a simple and beautiful thought. But let’s start from the beginning.

In my days as a coder, I enjoyed the command line. I’ve used various coding editors, and I’ve disliked the hassle of learning new IDEs, who sometimes are more of a straightjacket than a productivity enabler. So call me conservative if you will, but …

When a PR contact from Reddit contacted us about "exciting news", a mixture of workload and getting sent press releases not remotely related to open source led me to ignore the request to meet with Reddit. My bad. The news is that Reddit has decided to open source the code behind reddit.com. The Reddit blog states: "There are only five of us who work on reddit; we couldn't have made this site if it weren't for a great community of developers. In no particular order, here's a quick list of the open source products that reddit is built and runs... READ MORE

If you happen to be in Munich, Germany next week, don't miss out the final Sun/MySQL launch event which will take place on Thursday, 26th of June at the "Sofitel Munich Bayerpost", Bayerstraße 12, D-80335 München.

Simon Phipps will speak about "Sun and Open Source - How it has changed the industry", Kaj Arnö will give a talk about the positioning, strategy and momentum of MySQL as a part of Sun. Other speakers include Donatus Schmidt (Marketing Director Sun Germany) and Ralf Gebhardt (Sales Engineer, MySQL). You can see the entire agenda here, you need to …

MONyog 2.5 beta 2 has been released.

Bug fixes:

* Under specific circumstances the service would stop very slow.
* If network connection was temporarily unavailable the first CPU value after network came back told 100% CPU load.
* The temporary files for storing public/private keys are now being created with very restrictive file permission in Linux. So only the owner will be able to read/write these temporary files. Although these files would exist only for a fraction of second, in earlier versions of MONyog other users in the same Linux system could get access to them within that small timeslice.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

I've just been informed that a PDF of my slides as well as a recording of yesterday's webinar about MySQL Backup and Security (in German) is already available for replay/review. You can access the files from our on demand webinars page (free registration required). Enjoy!

In code just tested:

ndb_mgm> ndbinfo MEMUSAGE
RESOURCE_NAME    NODE_ID    PAGE_SIZE_KB    PAGES_USED    PAGES_TOTAL    BLOCK
IndexMemory,1,8192,16,160,DBACC
DataMemory,1,32768,20,640,DBTUP
IndexMemory,2,8192,16,160,DBACC
DataMemory,2,32768,20,640,DBTUP

Win!

This is the first time that we’ve been able to get this kind of info out of the cluster without using the magic “all dump 1000″ (or “all report MemUsage”) which end up using events, which go to the log file, aren’t exactly reliable etc.

This performs a scan on the NDBINFO tables (in ndbd) from ndb_mgmd and returns the result to the management client. You can then use this in scripts from the command line. e.g. to find out how many pages of datamemory are used on each node:

$ ./storage/ndb/src/mgmclient/ndb_mgm -c localhost:9311 …

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

One of the potential favourites for EURO 2008 was always going to be eliminated from the group stages given France, Italy and The Netherlands were all drawn in Group C and it was France that made an early exit following a 2-0 defeat to the Italians last night.

France must also be considered one of the favourites to be crowned EURO 2008 Open Source champion given the number of open source-related policies, projects …