I had the opportunity to review a client’s production Drupal installation recently. This is a new site and traffic is just starting to pick up. Drupal is a popular LAMP stack open source CMS system using the MySQL Database.

Unfortunately I don’t always have the chance to focus on one product when consulting, sometimes the time can be minutes to a few hours. Some observations from looking at Drupal.

Disk footprint

Presently, volume and content is of a low volume, but expecting to ramp up. I do however find 90% of disk volume in one table called ‘watchdog’;

+--------------+--------------+--------------+-------------+--------+
| table_schema | total_mb     | data_mb      | index_mb    | tables |
+--------------+--------------+--------------+-------------+--------+
| xxxxx        | 812.95555878 | …

This week I was the invited speaker to give a 4 hr presentation to the Federal Government Sector in Washington DC on “Best Practices in Migrating to MySQL“. This was a followup to my day long “MySQL for the Oracle DBA Bootcamp” which I presented in Washington DC last year. It was good to see a number of attendees from my first DC presentation.

There was good attendance across various government departments and companies providing services to the government sector, as well a variety of job descriptions.

Thanks to Carahsoft and Sun/MySQL for organizing and sponsoring the event. Thanks also to Phil Hildebrand who provided fantastic support during my preparation answering all my SQL Server questions.

Thanks also …

I had a customer recently who had very hierarchical data, with some complicated measures that didn’t aggregate up according to regular ole aggregation rules (sum, min, max, avg, count, distinct count). Now, one can do weighted averages using sql expressions in a Measure Expression these rules were complex and they also were dependent on the other dimension attributes. UGGGGH.

Come to that: their analysts had the pristine, blessed data sets calculated at different rollups (already aggregated to Company Regions). Mondrian though, is often too smart for it’s own good. If it has data in cache, and things it can roll up a measure to a higher level (Company Companies can be rolled up to Regions if it’s a SUM for instance) Mondrian will do that. This is desirable in like 99.9% of cases. Unless, you want to “solve” your cube and just tell Mondrian to read the data from your tables.

I started thinking - since …

Living in Portland, OR, I was sad to see O’Reilly move OSCON to San Jose this year (don’t they have enough with MySQL, Velocity, …?). So what did the Portland locals do? Start their own:

Open Source Bridge (we have a lot of bridges here in Portland).

It looks like they just opened up their call for papers recently, quoting from their page: “Open Source Bridge is accepting proposals now through March 31st for our 2009 conference, which will take place June 17–19 at the Oregon Convention Center in Portland, OR.”

February 2009 has been a very busy time for presentations on Open Source Software in the Dallas/Fort Worth Area. Yahoo's Tommy Falgout presented at the recent DallasPHP.Org meeting on Scaling MySQL. You can find his presentation at http://www.dallasphp.org and I highly recommend their meetings as an excellent.

Next up is the Dallas OpenSolaris/Dallas Sun Users Group(DSUG)and they are offering the ultimate geek-bait! Free Pizza!

Meetings Held the Third Thursday of Every Month
Next Session: Thurs Feb 19th (6:30PM Pizza, 7:00PM Program)
Topic: Open Source Roundtable - share your Open Source experiences with the group
Speaker: Jim McGuinness will kick off the discussion with updates on MySQL, Glassfish and Openoffice
Location: Dallas Sun Office, Mansion Conference Room
16000 North Dallas Parkway, Suite 700

Register here: …

Last week, my good colleague Gerv gently took me to task about requiring that videos submitted to the Mozilla Net Effects video program be licensed under the Creative Common NonCommercial-ShareAlike license (instead of an actual Free Culture licensed like Creative Common ShareAlike license or Creative Common Attribution license) . I thought about this for a while and got to wondering why I’d ever let fear of misuse overcome my experience and common sense.

Licensing and contract choices are often driven by fear and greed. We work, play, love and give in an …

Just read it !

The only unrealistic part about the scenario is that I fear that most purchasers within a government agency won't be asking these questions, yet.

Technorati Tags: mysql open core open source Share with Shareomatic!

Trackback URL for this post:

http://www.krisbuytaert.be/blog/trackback/879

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 slides for my Monitoring MySQL talk , which I gave earlier today in an overcrowded MySQl Developersroom at Fosdem are now online, both at my site and at Slideshare

As of now I actually expect people to use those slides for schoolwork or next year in a main Fosdem track :)
As afterall that is the goal of Open Source and spreading the word ..

MySQL Monitoring Shoot Out View more presentations from Kris Buytaert. (tags: mysql …

When I read Monty's post on leaving this passage struck me the most.

The main reason for leaving was that I am not satisfied with the way the MySQL server has been developed, as can be seen on my previous blog post. In particular I would have like to see the server development to be moved to a true open development environment that would encourage outside participation and without any need of differentiation on the source code. Sun has been considering opening up the server development, but the pace has been too slow.

In short, Sun isn't open enough. I think I've said that enough, it's typically more Open Core than Open Source .. and for a growing amount of people.. that isn't good enough.

Reacting on that post we see Matt Asay …