The latest from the MySQL community

Uh oh. It seems my blog posting frequency is dropping even below my modest minimum target of one per month. I didn't post anything at all in my summer vacation. Well, a small child plus a house to re-decorate does take its share of energy I guess.

I thought I'd still follow up with were we left before holidays:

What I'm left with is the question: Are we there? Is this it? Is all that is left just some minor cleaning up after the big battle has already been won? I think it might be. For me, somehow the day I read the news of the release of Symbian as Open Source marks the milestone when it was clear that we had "won". [...]

read more

Help.... the info I find online online is a tad messy and sometimes outdated. Has anyone created installable Scribus packages for OS X yet?

I'd prefer to not go through the whole Fink saga, and MacPorts doesn't appear to want to fly for building qt4. Each approach seems to have some issues, but perhaps that observation too is based on now outdated info. Please do tell me!

Right now I need a PPC Tiger build for an old PowerBook, and a Intel Leopard for myself would be most useful.
Thanks!

The hardware guys are presenting new storage devices called
SSD's based on flash memory. At the moment I think they are
about 3-4 times cheaper than DRAM memory and the gap seems
to be increasing. They're still far from the price of hard
drives but also here the gap seems to be closing.

So as I'm now an employee of Sun that actually puts together
systems with this type of HW in it I get questioned what I
as a DBMS developer can do with those devices.

First some comments on performance. These new devices will be
able to perform reads and writes of a few kilobytes large pages
in about 25-100 microseconds compared to hard drives which
takes about 3-10 milliseconds for the same thing.

An obvious use is obviously to use them to speed up database
logging, particularly in commit situations. However this
doesn't really require any significant …

As burtonator pointed out parallelism is an important
feature that partitioning makes possible. So I thought
it might be a good idea to mention a little bit what
we're doing in the area of partitioning.

It's quite correct that parallelism is one of the main
advantages of partitioning (not the only one though since
also partition pruning and dividing large indexes and
being able to add and drop partitions efficiently are
important as well). In 5.1 we focused on the maintenance
features of partitioning but the intention to move on
to parallelisation was more or less the main goal from
the very start.

This is why it's such extra fun to actually get going on
this when one has worked on the foundation for this work
for almost 4 years (partitioning development started out
2004 H2 and most of the partitioning code in 5.1 was ready
about two …

It may be tested again! Reason for the new version are two new releases of the main components of XAMPP: PHP and MySQL.

New in both XAMPP versions: MySQL (5.0.67), PHP (4.4.9), and phpMyAdmin (2.11.8.1). .

Go to XAMPP BETA download area

XAMPP BETA versions are always for testing purposes only. There will be no upgrade packages from and to beta versions. To all testers: Many thanks in advance!!

Es darf wieder getestet werden, neue XAMPP-Betas sind da. Grund sind zwei neue Versionen der Basiskomponenten MySQL und PHP, die seit der letzten XAMPP-Version erschienen sind.

Neu in beiden XAMPP-Versionen: MySQL (5.0.67), PHP (4.4.9) und phpMyAdmin (2.11.8.1).

Zum XAMPP-BETA-Bereich

Beta-Versionen sind ausschließlich zum Ausprobieren und Testen da. Wir würden uns allerdings sehr freuen wenn ihr einen kritischen Blick auf diese Version werfen könntet und uns berichtet, ob die Beta bei euch problemlos lief oder sie Probleme gemacht hat.

Baron posted something interesting about agent vs agent-less monitoring in response to Rob.

While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.

I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?

Trivially, you need some piece of software to collect data. With munin you configure a server that triggers scripts on the monitored servers. The set of data sources is governed by what you install in the correct directory on the monitored server. Cacti relies on SNMP heavily and also …

“MySQL Cluster 6.4 Windows tree” branch in Launchpad

That’s right folks, I’m pushing up patches for MySQL Cluster on Windows. This tree is incomplete, and no promises on when enough will be pushed for it to even compile on Windows.

Tree is updated when launchpad pulls from our internal tree.

Last week I gave my first webinar for MySQL titled “Bau sicherer LAMP Anwendungen”. The webinar, which was a cooperation between MySQL and my company SektionEins, was held in german, covered SQL-Malware, SQL-Injection, safe programming and some tools to detect and block SQL-Injection attacks.

The recording of this webinar is now available on the MySQL site.

For those that only want to see my slides they are available on the MySQL site after registration or here.

Because it was a german webinar the recording and slides are in german, too.

I’ve been following the Drizzle project with some interest. There’s a lot to like about it. But you know what I like most about the project?

No dual licensing. Just plain GPL, version 2.

I personally think this is the foundation for why people are empowered, why there is excitement, why there is progress, [...]