This will be a quick tutorial on looking at on-time flight analysis. This material will be part of a lab for a class on InfiniDB that I am developing. The information is from Data.Gov Website and you are free to follow the steps presented.

What I want to know is what flight from a certain airport arrives at my local airport on time the most frequently. Traveling from LAX to DFW can often be a combination of cancellations, flight delays, and being the nth plane in line for takeoff. So what is the best flight choice for that route?

The first step is getting the data. And is is available for free from Airline On-Time Performance and Causes of Flight Delays. Be sure to select the check box for documentation so that there will be a readme.html to described the file …

Here is one, but not all of the culprits in the codebase:

  /*
    Count warnings for all inserts.
    For single line insert, generate an error if try to set a NOT NULL field
    to NULL.
  */                         
  session->count_cuted_fields= ((values_list.elements == 1 &&
                                 !ignore) ?
                                CHECK_FIELD_ERROR_FOR_NULL :
                                CHECK_FIELD_WARN);

With MySQL you have to keep your mind firmly in the state of "if I was MyISAM, what would I do?".

MyISAM is the default engine for MySQL. It handles everything from temporary tables on disk to the authentication tables. It lays out its rows, for the most part, in the order written. Updates are written in place when possible, and any sort of traffic beyond INSERT and DELETE will fragment it. Its …

There was another acquisition involving open source software recently when Consona bought Compiere, but what is perhaps most striking about the deal from an open source software perspective is how little it and the Compiere community mattered in the deal.

By most accounts, including that of fellow open source ERP player xTuple CEO Ned Lilly, who offers an interesting and accurate depiction of Compiere’s changes, acknowledge the movement away from community that occurred over the last few years at Compiere. As discussed in our own recent report on the deal, we are also somewhat skeptical over the fate of what is left of Compiere’s open source community, even though Consona plans to …

By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations.

At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.

On Monday, June 28th from 4 pm – 5:30 pm I will be presenting …

The analysis that shows how to make deletions really fast by using clustering keys and TokuDB’s fractal tree based engine also applies to make updates really fast. (I left it out of the last post to keep the story simple). As a quick example, let’s look at the following statement:

update foo set price=price+1 where product=toy;

Executing this statement has two steps:

• 
  
• a query to find where product=toy
  
• a combination of insertions and deletions to change old rows to new rows
  

The analysis is identical to that for deletions. Just like for …

Pretty much exactly a year ago many german PHP meetups have held BBQs to celebrate the summer, to invite guests to join their meetups in a very relaxed atmosphere and to enjoy themselves. During the PHP BBQ week 2009 more than 140 people got connected and had fun . And, of course, I loved visiting all the meetups. I am not touring through the user groups this year. However, and that is fantastic news, some user groups have organized BBQs again. Today, June 22th - 19:00, you can enjoy a BBQ in Karlsruhe organized by the PHP user group Karlsruhe and sponsored by urlaubswerk.de! Check their homepage for the latest details.

KIT Campus Süd – Center für Innovation & Entrepreneurship (CIE)
…

Pretty much exactly a year ago many german PHP meetups have held BBQs to celebrate the summer, to invite guests to join their meetups in a very relaxed atmosphere and to enjoy themselves. During the PHP BBQ week 2009 more than 140 people got connected and had fun . And, of course, I loved visiting all the meetups. I am not touring through the user groups this year. However, and that is fantastic news, some user groups have organized BBQs again. Today, June 22th - 19:00, you can enjoy a BBQ in Karlsruhe organized by the PHP user group Karlsruhe and sponsored by urlaubswerk.de! Check their homepage for the latest details.

KIT Campus Süd – Center für Innovation & Entrepreneurship (CIE)
…

What happens when you mention Open Office and Firewall in once sentence, in public ?

People start actually building it (French Article)

Then add to that list that there's also people out there that think that running MySQL over NFS is providing them High Availability, or that using DNS Round Robin will provide them a scalable setup,

So yes .. apparently there is indeed a parallel universe out there.

And no .. I don't want to see Webmin in any Appliance .. that is a joke..., or rather a rant ..

Technorati Tags: firewall …

Dear MySQL Users,

We’re happy to announce the 3rd Release Candidate (RC) of MySQL Workbench.
Version 5.2.24 includes fixes for more than 70 issues.

MySQL Workbench 5.2 RC provides:

• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)
if you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench
As always, you will find binaries for the various platforms on our download pages.

Please get your copy from our Download

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

…

Couple of Fridays ago we had one of our @Inuits days again. Rather than having some people give talks and presentations about what they have been doing for the past couple of months this time we set out to research, test, and build stuff.

We split up in 3 different groups, one focusing on CI and testing freshly build stuff with cucumber, a second one setup and tested Galera

We setup a 3 node Galera cluster , not really as smooth as we'd like to ..

Our first bump was that the installation of the package on CentOS is hell, it needs manual interaction such as replacing packages. Deploying this from a repository is probably not going to be a straight forward option.

Galera only takes care of replicating data, just as with MySQL MM replication there still is a need for an external …