Sun has launched the Glassfish Portfolio,  the best web application platform on the planet.

To learn more, you can also go to "the Aquarium" and "Miles to go...."

Last week I had the chance to visit the MySQL Meetup in Boston at the invitation of prominent MySQL community persona Sheeri (who is organizing this year's MySQL Camp at the MySQL Users Conference) and give a small talk on the Event Scheduler feature of MySQL 5.1. The Meetup had about 15 people, which for a different night at a different venue was a great number in my mind.

I presented on the Event Scheduler which while a small subject is still a nice feature of MySQL 5.1. The presentation can be downloaded from my personal dups.ca site. Sadly I was suffering from a really bad cold/flu/whatever and was happily heavily dosed on flu pills. I only later discovered that these pills had caffeine in them and was the reason I hadn't been …

Unless you are doing it wrong.

And sadly I`m seeing more and more people doing it wrong.
To a lot of people Open Source means that they have a piece of software that does almost what they want and which they can modify to their best wishes and use internally.

So they fork locally,, they don't redistribute their code , but they aren't contributing their changes back upstream, chances are these changes wouldn't be accepted upstream anyhow as they are really customizing the code for their specific cases. At first sight this doesn't look so bad , at second sight ..

When weeks or months later the upstream project releases an urgent security fix, the local fork has deviated soo much that it can't upgrade anymore and stays with an insecure version.
Often it's worse.. a feature that could have been accepted upstream has been implemented slightly different in the local fork, the result being that newer features depending …

The current size of a MySQL 5.1.30 installation is around 420M.

$ du -sh .
426M    .

A further breakdown.

$ du -sh *
213M    bin
20K     COPYING
9.8M    docs
8.0K    EXCEPTIONS-CLIENT
436K    include
12K     INSTALL-BINARY
121M    lib
504K    man
4.0K    my.cnf
77M     mysql-test
4.0K    README
20K     scripts
2.3M    share
2.9M    sql-bench
100K    support-files

A means to reduce the footprint by 25% is to delete some unused stuff.

$ rm -rf docs/ mysql-test/ sql-bench/
$ du -sh .
337M    .

It’s no big deal, however it certainly does cut down on verbose output in the backup logs removing the mysql-test directory and files.

On February the 18th I have the privilege of participating in a seminar that Sun is putting on about one of the MySQL 5.1 case study finalist. I will kick things off covering the new features of 5.1.  Chris Lavigne, from Breadboard BI,   will be discussing how his company put together a business intelligence solution for the Boats.com and YachtWorld.com web properties. The project was developed using a 100% open source stack that leveraged Linux, Pentaho and MySQL, specifically using 5.1’s new table partitioning feature. Hear Chris explain how he helped his client unlock valuable information from their large and disparate data sources so that far more informed sales, production and marketing decisions could be made.

Join us! Registration is available here.

 Our latest article over at Database Journal is hot off the presses.  Advanced MySQL Replication – Improving Performance discusses some of the best ways to improve the performance of your MySQL slave setup.  If the slave is constantly getting further and further behind the master database, we discuss a number of techniques which may help you bring it under control.

At a customer yesterday, I confirmed what Jonas suspected and what is probably related to bug 42474. Scroll down and look for the output of SHOW PROCESSLIST.
It seems that TRIGGERs causes Table Locks to be taken when used with Ndb cluster tables!! I have created a bug report .

If we do an update on a table that has an update trigger the trigger will upon execution lock the entire table that is affected by the trigger.

This was verified by having several threads updating random records in a table. When one update gets to execute, the trigger will block the other updates from happening. This was shown using SHOW FULL PROCESSLIST¸ which shows a bunch of statements being in …

Sun has launched the Glassfish Portfolio,  the best web application platform on the planet.

To learn more, you can also go to "the Aquarium" and "Miles to go...."

Sun has launched the Glassfish Portfolio,  the best web application platform on the planet.

To learn more, you can also go to "the Aquarium" and "Miles to go...."

Yesterday Sun introduced Glassfish Portfolio. Its a new stack of open source middleware products including Glassfish Enterprise Server, Glassfish ESB, Glassfish Web Space Server, and the new Glassfish Web Stack, which includes support for projects such as Tomcat, Memcached, Apache, PHP, Ruby and Python and a copy of MySQL Community.

It’s a pretty complete infrastructure stack. What it is not, however, is an integrated LAMP stack, despite Sun’s reference to it as such not once but twice on its press announcement.

Glassfish Portfolio runs on Linux of course, as well as Solaris, but it does not contain Linux (integrated or otherwise) or Linux services (although that is available …