Just in time for Christmas: After the usual 2-week beta test phase, we can now announce the new "final" XAMPP version for public downloading.

In both versions we updated Apache (2.2.11), MySQL (5.1.30), PHP (5.2.8) and phpMyAdmin (3.1.1). The Linux version also contains the new MySQL storage engine PBXT (1.0.07-rc).

With this version our support of PHP 4 ends and from this version on PHP 4 is no longer shipped with XAMPP. After PHP 4 was officially no longer supported since the end of 2007 this was just a matter of time.

On the other hand XAMPP now supports the brand-new MySQL 5.1 database generation. If you're upgrading from MySQL 5.0 please take a look at MySQL's official Upgrading from 5.0 to 5.1 and Monty's critical …

Noch rechtzeitig zu Weihnachten: Nach der üblichen 2-wöchigen Beta-Phase können wir heute die neue "finale" XAMPP-Versionen zum öffentlichen Download anbieten.

Aktualisiert wurden in diesem XAMPP: Apache (2.2.11), MySQL (5.1.30), PHP (5.2.8) und phpMyAdmin (3.1.1). Die Linux-Version enthält zusätzlich auch noch die MySQL Storage Engine PBXT (1.0.07-rc).

Mit dieser XAMPP-Version endet auch unsere Unterstützung von PHP 4, d. h. ab dieser Version wird PHP 4 nicht mehr mit ausgeliefert. Nachdem PHP 4 seit Ende 2007 offiziell nicht mehr "supported" wird, war das die logische Konsequenz.

Dafür ist endlich die neue Generation der MySQL-Datenbank 5.1 als GA-Version erschienen und nun auch im XAMPP mit dabei. Empfehlenswert zu lesen sind dazu MySQLs offizielles Upgrading from 5.0 to 5.1 und Montys …

The Configurator and Sandbox (only the Custom part so far) has been updated to support MySQL Cluster 6.4!
MySQL Cluster 6.4 is a fantastic piece of software with new features such as:

• Multi-threaded Support. A new configuration parameter, MaxNoOfExecutionThreads=[2,4,8] allows you to set how many cores the data node should utilize.
  MaxNoOfExecutionThreads=2 for two core machines
  MaxNoOfExecutionThreads=4 for quad core machines
  MaxNoOfExecutionThreads=8 for eight core machines
  With 8 you will get 4 query handling threads! Can you beat Jonas' 1M reads on a single box? …

Ok, Now we are talking!

Oh well, we know the Obama team is quite technology savvy and want to run the administration on the state of the art computer technologies. As an example, Obama campaign website used MySQL on the backend. 

So then, can Cloud Computing benefits lure the administration? Security and Technology experts discuss on national public radio  if Cloud Computing will work for the White House and how their computers should run.  Kevin L. Jackson further muses if the Obama Administration should use Cloud Computing.  He believes that Cloud Computing technology can indeed be used to implement the recommendations made by …

Ok, Now we are talking!

Oh well, we know the Obama team is quite technology savvy and want to run the administration on the state of the art computer technologies. As an example, Obama campaign website used MySQL on the backend. 

So then, can Cloud Computing benefits lure the administration? Security and Technology experts discuss on national public radio  if Cloud Computing will work for the White House and how their computers should run.  Kevin L. Jackson further muses if the Obama Administration should use Cloud Computing.  He believes that Cloud Computing technology can indeed be used to implement the recommendations made by …

The following summary shows my personal understanding of MySQL 5.1 licenses, packages and products. It does not necessarily reflect 100% the way MySQL understands it. But after all the discussions I hope it is as close as possible to the reality:

MySQL Embedded Database Server

(Download -> OEM Software)

 Classic  (OEM license, -MEM -InnoDB)
 Pro      (= Classic +InnoDB)
 Advanced (= Pro +Partitioning)

MySQL Community Sever

(Download -> Download)

 Community (GPL, -NDB)

MySQL Enterprise Server

(Download -> Enterprise Software)

Pro      (GPL or commercial, -NDB +InnoDB +MEM, Basic + Silver customer, MRU + QSP)
 Advanced (= Pro +Partitioning, Gold …

The following summary shows my personal understanding of MySQL 5.1 licenses, packages and products. It does not necessarily reflect 100% the way MySQL understands it. But after all the discussions I hope it is as close as possible to the reality:

MySQL Embedded Database Server (Download: enterprise.mysql.com -> OEM Software)
Classic (OEM license, -MEM -InnoDB)
Pro (= Classic +InnoDB)
Advanced (= Pro +Partitioning)

MySQL Community Sever (Download: www.mysql.com -> Downloads)
Community (GPL, -NDB)

MySQL Enterprise Server (Download: enterprise.mysql.com -> Enterprise Software)
Pro (GPL or commercial, -NDB +InnoDB +MEM, Basic + Silver customer, MRU + QSP)
Advanced (= Pro +Partitioning, Gold + Platinum customer)

MySQL Cluster (Download: http://dev.mysql.com/downloads/cluster/)
Community Edition (GPL, all features)
Com (ex CGE?) (OEM or commercial, -InnoDB +NDB)
Com-Pro …

We’ve been working on fixing up the remaining test cases so that they run with Drizzle. We’ve found: bugs in Drizzle, bugs in MySQL (one that seems to have been there for at least 10 years), bugs in the tests, tests that no longer apply and occationally, something like this:


/* Please god, will someone rewrite this to be readable :( */
if (to->pack_length() == from->pack_length() &&
!(to->flags & UNSIGNED_FLAG && !(from->flags & UNSIGNED_FLAG)) &&
to->real_type() != DRIZZLE_TYPE_ENUM &&
(to->real_type() != DRIZZLE_TYPE_NEWDECIMAL || (to->field_length == from->field_length && (((Field_num*)to)->dec == ((Field_num*)from)->dec))) &&
from->charset() == to->charset() &&
to->table->s->db_low_byte_first == from->table->s->db_low_byte_first &&
(!(to->table->in_use->variables.sql_mode & …

We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work.  The first thing these have in common is that they're generally some kind of loggable event.

The next characteristic of a lot of these systems (real or planned) is the desire for "real-time" analysis.  Our customers often want their systems to provide the freshest data to their own clients, with no delays.

Finally, the analysis is usually multi-dimensional.  The typical user wants to be able to generate summaries and reports in many different ways on demand, often to support the functionality of the application as well as to provide reports to their clients.  Clicks by day, by customer, top ads by clicks, top ads by click-through ratio, and so on for dozens of different types of slicing and dicing.

And as a result, one of the most common …

As I mentioned earlier their are some limitations with Ec2’s setup and configuration that make it difficult to get Waffle Grid to perform at a high level.  One of the items we are hoping that helps us overcome the Ec2 limitations is Async ( non block ) sets in memcached, unfortunately their current implimentation has some limitations as well, but Brian Aker said they are working on fixing these right now.  But even the current Async implementation showed a slight performance bump on my test hardware, so I decided to give it a spin on Ec2 again.

Thats showing a little more improvement!   43% boost instead of the 22%we saw earlier.  …