If so, you should check out OpenSQLCamp 2009, European Edition. November last year, the home of OpenSQL Camp was Charlottesville, VA, but now it is time to have something a bit more local. OpenSQL Camp will take place Saturday 22nd and Sunday 23rd of August, in St. Augustin, Germany, so it could do for a nice August getaway to Germany.

It’s not really the biggest of cities, but then again, that is part of the charm, going to some small city and learning more about databases.
In case you do happen to be curious, feel free to check out the list of proposed sessions, although it is not complete, it does give a overview of what to expect.

I for one am looking forward to a European event, as it seems like most things is based in the US, and that means travel time will be less and no …

Default partitioning

By default, Cluster will partition based on primary key

When adding rows to a table that’s using MySQL Cluster as the storage engine, each row is assigned to a partition where that partition is mastered by a particular data node in the Cluster. The best performance comes when all of the data required to satisfy a transaction is held within a single partition so that it can be satisfied within  a single data node rather than being bounced back and forth between multiple nodes where  extra latency will be introduced.

By default, Cluster partions the data by hashing the primary key. This is not always optimal.

For example, if we have 2 tables, the first using a single-column primary key (sub_id) and the second using a composite key (sub_id, service_name)…

mysql> …

One of the most typical reasons for performance and scalability problems I encounter is simply failing to do the math. And these are typically bad one because it often leads to implementing architectures which are not up for job they are intended to solve.

Let me start with example to make it clear. Lets say you're doing some reports from your apache log files - how many distinct visitors hit the page and stuff like that. You picked full logs because they are great in flexibility - you can run any adhoc queries and drill down as much as you like. Initially traffic was small and young and with 10000 page views a day you few days of history the queries there instant which gave you a confidence this approach will work.

As the time passes and you get 1.000.000 events per day and looking to do reporting for up to the whole year worth of data you find things not working any more with response times for individual queries taking half an …

On April 9-10 the National Science Foundation hosted the Workshop on the Science of Power Management (SciPM 2009), where I gave an invited talk. Here I give a brief summary of my talk along with a pointer to the slides.

The talk describes how MySQL with TokuDB can provide a path to more energy-efficient database implementations. It’s a theoretical talk. That is, rather than presenting results from an existing implementation, it provides food for thought about future possibilities.

Here’s an executive summary of the talk.

Disks use a substantial fraction of the computing power in a typical database application. Although different workloads and configurations can give very different values, somewhere around 1/3 to 2/3 of the total energy consumed by the computing unit seems like a good …

Devart has released today the updated version 3.50 of dbForge Fusion for MySQL – a powerful add-in for Microsoft Visual Studio or CodeGear RAD Studio, designed to simplify MySQL database development and enhance data management.

Up to 100 usability improvements have been implemented, so you get better insight and satisfaction as well as a total control over performed tasks through the modernized UI of dbForge Fusion for MySQL.

Striving to speed up performed tasks, dbForge Fusion offers compression to reduce traffic, while exchanging data with MySQL server, and makes the exchange quicker.

The new features of dbForge Fusion for MySQL 3.50 include:

A new excellent Database Designer

The new version includes a modern tool for online database design – Database Designer. It is indispensable for anyone who needs to build a clear and …

I wrote about my MySQL wishlist on November 14th 2007 and now it's time for an update. I will copy-paste the old entry. The original text will be in italics.

1. Per user and/or per database quota
Would very useful in setups for shared hosting. This would also prevent one database from bringing down the whole server. Separate tablespaces on different mountpoint can ease the pain, but I consider that a nasty hack.
No update. Still problematic

2. External authentication
I've seen numerous scripts which fetch the authentication info from ldap, a file, another database or some other authentication store. This should be integrated into mysql. The mysql grant tables should be pluggable so it is possible to write a custom authentication plugin. We already have plugable engines and function (UDF) so this shouldn't be that hard …

I wrote about my MySQL wishlist on November 14th 2007 and now it's time for an update. I will copy-paste the old entry. The original text will be in italics.

1. Per user and/or per database quota
Would very useful in setups for shared hosting. This would also prevent one database from bringing down the whole server. Separate tablespaces on different mountpoint can ease the pain, but I consider that a nasty hack.
No update. Still problematic

2. External authentication
I've seen numerous scripts which fetch the authentication info from ldap, a file, another database or some other authentication store. This should be integrated into mysql. The mysql grant tables should be pluggable so it is possible to write a custom authentication plugin. We already have plugable engines and function (UDF) so …

DotAsia, the registry in charge of .ASIA domains, is offering a nice 2GB USB key for every .ASIA registration!

The registry will send the gadget directly to the owner's address. We remind you that we provide the compulsory CED contact for the Asia zone automatically and for free, thus making this extension available to all at Gandi.

This offer is valid from today the 6th of July, until October the 6th, for all new .ASIA domain name creations, from 2 to 10 years.

As we found this to be an interesting idea, we have decided to reduce by 10% the price for the creation of a .ASIA from the second year. for example: over 2 years, a .ASIA will cost you $45/£22.5 excl.VAT, instead of the usual $50/£25 excl.VAT.

You can check the .ASIA price list on this page : https://www.gandi.net/domain/price/detail/asia/

And the .ASIA …

Image via Wikipedia

BI/Data Warehousing is an easier market to enter for new database platform vendors.  This is for a few reasons.  Firstly, most BI deployments are custom built projects for each organization.  This means the ability to pick and choose various layers of the stack is much greater. 

Secondly, BI/DW projects success/failure metrics are often tied to database platform driven properties – performance, scalability, load times etc.  The ability to stray outside any existing database platform “standards” to choose a platform that better meets key metrics is more tolerable.

Thirdly, because the ratio of BI to OLTP is low, the associated impact of violating a corporate standard is much lower.  With OLTP …

Installing the Spider storage engine is not trivial but not extremely difficult either. My previous article has a step-by-step …