If you’ve noticed that your recent upgrade did not go as planned and now the application does not load – please check this page: http://wiki.kontrollsoft.com/wiki/UpgradingReleases for notes on upgrades between versions. Typically you need to execute a SQL file against the current schema to bring it up to date. If you have any questions please [...]

I was reading another post comparing the different forks of MySQL (disclaimer: my employer), and again it seemed to me the term “fork” is somewhat imprecise. I agree with Morgan Tocker that “delta” does not capture these other creatures either – after all, isn’t a delta what makes a fork not a copy?

Wikipedia cites Eric Raymond‘s definition that “The most important characteristic of a fork is that it spawns competing projects that cannot later exchange code, splitting the potential developer community”, but also notes “However, this is not …

There hasn’t been a blog post for some time now but that does not mean that the MySQL Workbench Team has been lazy – the contrary.

All I can say at this point is that everybody should check out the upcoming Beta release of MySQL Workbench 5.2 and be prepared for something big.

Hint: Please take a look at the screenshots below. Post your speculations as comments to this blog post.

Screen 1:

Screen 2:

Marten Mickos joins Eucalyptus. Novell rejects Elliot. Perspectives on OSBC. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Mårten Mickos was named CEO of Eucalyptus Systems.

# Novell’s board rejected Elliot’s takeover proposal as inadequate, will review other alternatives.

# North Bridge Venture Partners published the results of its Future of Open Source survey.

# Rob Bearden was appointed executive chairman of the board of Pentaho.

# The Eclipse Foundation …

Since the time that I’ve been using MySQL I have filed quite a few bug reports. Some of these have been fixed and many of the bug reports are actually new feature requests. While working with MySQL Enterprise Monitor I’ve probably filed more feature requests than bug reports.

That’s fine of course and my opinion of what is needed in MySQL or Merlin is one thing,  yours or the MySQL developers is something else. We all have our own needs and find things missing which would solve our specific problems.

If I have ten feature requests open and only one could be added to the software I’d also like to be able to say: this feature is the most important one for me.

However, it seems to me that there is no easy way in the mysql bug tracker at the moment to group together different types of new feature requests into groups of related features and then see the different types of …

Last week Solutions Linux / Open Source event was held in Paris.

Kuassi MENSAH (Head of Product Management Database Technologies, Oracle Corporation) presented the open source Oracle strategy. Linux, MySQL, virtualization, GlassFish, Eclipse, dynamic scripting languages ,... etc . It was well received by the audience. Knowing that MySQL organization will be kept safe in Oracle is perceived as a nice move.

Florian Haas(LINBIT) gave a tutorial on DRBD and did some demos with NFS and video streaming. And of course he reminded people that now since Linux 2.6.33, DRBD is officially integrated into the Linux kernel source. DRBD making the push for mainline Linux kernel is going to make HA easier.

...

[...]

As anybody who has ever implemented a Storage Engine for MySQL will know, a bunch of the DDL calls got passed a parameter named “path”. This was a filesystem path. Depending on what platform you were running, it may contain / or \ (and no, it’s not consistent on each platform). Add to that the difference if you were creating temporary tables (table name of #sql_somethingsomething) and the difference if you were one of the two (built in) engines that were able to be used for creating internal temporary tables (temp tables that are created during query execution that do not belong in a schema). Well… you had a bit of a mess.

My earlier attempts involved splitting everything up into two strings: schema name and table name. This ended badly. The final architecture we decided on was to have an object passed around that would deal with various transformations (from what the user entered to …

Database replication is still interesting after all these years.  Two of my talks focused on replication technology were accepted for the upcoming MySQL 2010 Conference.  Here are the summaries.

• Clustering for the Masses - A Gentle Introduction to Tungsten for MySQL 

• Not Your Grandpa’s Replication-The New Wave of MySQL Replication and How It Helps Your Applications

The first talk is a solo presentation covering Tungsten, which creates highly available and scalable database clusters using vanilla MySQL databases linked by flexible …

I just created a portable release of the 5.0 beta code. Other than previous portable releases, this is not an installer any longer, but a simple ZIP file. Just unpack and run it.

How does HeidiSQL portable exactly work?
r3201 implements additional code into heidisql.exe, which checks for a "portable_settings.txt" file in the same directory. If present, heidisql.exe will read any settings from this file into a unique registry key, without interfering any running Heidi process or even other running portables. When you close the main window, settings will be written to the above mentioned text file and the registry key gets removed.

This way, the user is able to create its own portable with any build (ok, any later than r3201), just …

Here is in brief what's going on.

Last Friday (CET), big hardware troubles started on the server which db4free.net runs on. The server was unavailable and I didn't manage to start it up again by myself. I files a support ticked to my server provider, and by Saturday afternoon, the server was accessible again. Everything seemed to look fine, but Sunday, shortly after midnight, the same troubles started again.

My server provider gave me a new server, and thankfully, managed to get the old server to start up again. I backed up the user databases and copied them to the new server, so no - or at least almost no - data should be lost.

It will take me some time to migrate the entire service to the new server, so please be patient. I also want to use this "opportunity" to start offering MySQL 5.5, so my plan is to make the old server available on a different port, and start the entire service over on a fresh and …