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.  …

When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of time before you reach same results as you would reach much sooner with focused approach.

The time is critical for many performance optimization tasks not only because of labor associated expenses but also because of the suffering - slow web site means your marketing budget is wasted, customer not completing purchases, users are leaving to competitors, all of this making the time truly critical matter.

So what can be the goal ? Generally I see there are 2 types of goals seen in practice. One is capacity goal this is when the system is generally overloaded so everything is slow, when you're just looking to see how you can get most out of your existing …

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

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 …

I’ve been thinking about the business of what’s variously come to be called commercial open-source and enterprise open-source. I’m interested in the gestalt – the product, development processes, marketing, licensing and so on. MySQL has tried many different ways to earn money. These include dual licensing, support subscriptions, a knowledgebase, consulting, an Enterprise/Community split, trying to make parts of the server closed-source, making tools in a split community/premium version, building functionality externally in closed-source software where they can charge for it, and most recently creating three tiers of functionality for the MySQL 5.