Rome is a great city and it will host a bunch of great people (including me ) at November 12-13. This is when the second IKS Project workshop will take place. The goal of this workshop is to start working on an Open Source software stack that allows other Open Source projects and software vendors to leverage semantic search technologies.

IKS is an EU-funded project with an overall budget of 8.5 million Euros. The first workshop back in May saw two dozen of bright Open Source CMS minds discussing a semantic stack in general. This time, it will also make sense for non-CMS-related Open Source projects and vendors to join.

There will be interesting presentations from some key figures at the second workshop in Rome, such as Peter Mika of Yahoo! Research talking about “The Role of …

This post describes how MySQL Cluster executes queries. First of all, Cluster is a storage engine. It doesn't actually execute queries because it doesn't speak SQL. That is why you use a MySQL server, which parses your queries and sends low-level storage engine API calls to the Cluster data nodes. The data nodes know how to retrieve or store data. Or you can talk to the data nodes directly using the NDB API(s).

MySQL Cluster has various means of executing queries. They boil down to:

1. Primary key lookup
2. Unique key lookup
3. Ordered index scan (i.e., non-unique indexes that use T-trees)
4. Full table scan

Let's say you have 4 data nodes in your cluster (NoOfReplicas=2). This means you have 2 node groups and each one has half the data. Cluster uses a hash on the primary key (unless you've controlled the partitioning using the 5.1 partitioning features). So for …

Testing and automation. These two are key to ensuring high quality of software releases.

Ever since I worked briefly in the team at MySQL AB that is responsible for creating the binary (and source) packages of MySQL releases, I have had the vision of a fully automated release procedure. Whenever someone pushes a new commit to the release branch revision control tree, the continuous integration test framework should kick in and do all the steps needed for producing release packages:

• Checkout the new revision.
• Build a source tarball, and save it.
• For each platform, build a binary package from the source tarball. The build should be done in a freshly installed machine without any revision control checkouts, previous build trees, or extra installed software, to ensure that no unwanted dependencies or stray …

I really like this new toy (for me) called UDF. So I try to provide some more, hopefully useful, functionality.

The newest extension I like is the possibility to write to the MySQL error log through the application. Oracle can do that since long. Now we can do this as well...

A list of what I have done up to now you can find here:

• Query and change InnoDB spin_wait_delay: udf_spin_wait_delay-5.1.30-linux-i686-glibc23.so (md5 807c6bc09b5dc88a8005788519f2483a, BIN ... kbyte)
• Send message to the MySQL error log: udf_log_error-5.1.30-linux-i686-glibc23.so (md5 dc8ef3e91cf6dec84ab3ad95626ec9b5, BIN ... kbyte)
• ...

If you have some more suggestions, please let me …

I really like this new toy (for me) called UDF. So I try to provide some more, hopefully useful, functionality.

The newest extension I like is the possibility to write to the MySQL error log through the application. Oracle can do that since long. Now we can do this as well...

A list of what I have done up to now you can find here:

• 
  
• Query and change InnoDB spin_wait_delay: udf_spin_wait_delay-5.1.30-linux-i686-glibc23.so (md5 807c6bc09b5dc88a8005788519f2483a)
  
• Send message to the MySQL error log: udf_log_error-5.1.30-linux-i686-glibc23.so (md5 dc8ef3e91cf6dec84ab3ad95626ec9b5)
  
• ...
  

If you have …

Yesterday I attended CPOSC 2009. The conference was great. It was very well run, and I liked the sessions. I would definitely attend this conference again, and will recommend that Percona sponsor it next year. I attended the following talks:

• Stop Worrying and Start Monitoring with Nagios (Andrew Libby)
• DRBD, Network Raid, High Availability and General Awesomeness (Brian Gorka)
• MySQL Performance Tuning for non-DBAs (Tom Clark)
• Wonderful Desktop Tricks, and Aesthetics (Seth Jerome)
• Jump Start Django: The Web Framework for Perfectionists with Deadlines (Rob Yates)
• Watching and Manipulating Your Network Traffic (Josiah Ritchie)

And then of course I gave my own talk on Maatkit ( …

FOR IMMEDIATE RELEASE

MYSQL FOUNDER OUTLINES SOLUTION:
INSTEAD OF LETTING SUN SUFFER,
ORACLE SHOULD SELL MYSQL
(ORCL, JAVA)

Michael 'Monty' Widenius says European Commission is "absolutely right to be concerned" about proposed merger between Oracle Corporation [ORCL] and Sun Microsystems [JAVA], nominates award-winning EU strategist to support the proceeding

Tuusula, Finland, 19 October 2009 -- Michael 'Monty' Widenius, the creator of open source database MySQL and founder of the namesake company later acquired by Sun, today suggested Oracle should resolve antitrust concerns over its US$7.4 billion acquisition of Sun by committing to sell MySQL to a suitable third party. The proposed takeover has not yet been consummated because it is being investigated in depth by the European Commission as well as competition authorities in several other jurisdictions.

Widenius, who …

I'm pleased to announce the release of Spider storage engine version 2.6(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/

The main changes in this version are following.
- Add server parameter "spider_remote_access_charset", "spider_remote_autocommit", "spider_remote_sql_log_off" and "spider_remote_trx_isolation".
  These parameters are setted by Spider at connecting remote server. But it does not need to be setted if you know it previously and no need to change it. In this case, you can set these parameters for improvement connecting performance.

Please see "99_change_logs.txt" in the download documents for checking other changes.
Thanks to Giuseppe for bug report.

Enjoy!

Yesterday I attended CPOSC 2009. The conference was great. It was very well run, and I liked the sessions. I would definitely attend this conference again, and will recommend that Percona sponsor it next year. I attended the following talks: Stop Worrying and Start Monitoring with Nagios (Andrew Libby) DRBD, Network Raid, High Availability and General Awesomeness (Brian Gorka) MySQL Performance Tuning for non-DBAs (Tom Clark) Wonderful Desktop Tricks, and Aesthetics (Seth Jerome) Jump Start Django: The Web Framework for Perfectionists with Deadlines (Rob Yates) Watching and Manipulating Your Network Traffic (Josiah Ritchie) And then of course I gave my own talk on Maatkit (slides).

You want to use or to know more about Sun technologies? Join these Webinars to improve your knowledge and skills. You will be able to ask questions to Sun's experts.

• Mercredi 10 Février : Securité pour les applications Web. Pour les startups du Web, la protection et la sécurisation de leurs applications, de leurs données, et de celles de leurs clients est un véritable facteur clé de succès.  Ce Webinar couvre les différents challenges liés à la sécurité ainsi que les solutions associées telles que l'encryption, l'authentification, les certificats, la sécurisation du stockage et le stockage à tolérance de panne, les environnements étanches. Les architectes de Sun Startup Essentials présenteront des implémentations économiques basées sur des composents standards et ouverts tel qu'Apache, MySQL et ZFS. Ce webinar est …