Introduction

Improving Drupal's MySQL performance is more than just optimizing Drupal and MySQL themselves. I wanted to mention that the server hardware, operating system, webserver, and PHP also play important roles in deploying the fastest system possible. Benchmarking and profiling a system is a very methodical step-by-step process starting from the hardware, the operating system, Apache, PHP, MySQL then finally Drupal itself.

Server Hardware

Everything starts at the hardware level and having a way to benchmark CPU, memory, and harddrives is very important. Not all motherboards are created equal either. If at all possible, developing a benchmarking plan to test different CPUs, memory and harddrives will go along way to help creating a high performance Drupal/MySQL system. Using sysbench from http://sysbench.sourceforge.net/, it's possible to show which CPU, …

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …

It was fun, the good part about T-Dose is that is small enough to actually be able to speak with everybody you want to .. well almost .. there were still some people around I wanted to talk to but I didn't get the chance to . Specially Ber Kessels and Roy Scholten who filled in the gaps in the Drupal track. After my own talk I had to run to the other track so I could answer the tricky questions in our other talk about Open Source Monitoring Tools. And I never really made it back to the Drupal room. So Ber, Roy , next time you run into me I`ll buy you a Beer !

Anyway Pics are up (so Geert now finally has pictures of himself on stage)

Social event …

Tomorrow (Thursday, 11th of September) at 9:00 PST/16:00 UTC/17:00 GMT/18:00 CET, there will be an new free MySQL University Session. MySQL University started as an internal training program for MySQL engineers, to share and spread knowledge about their areas of expertise and has been available to the public for quite some time now. It covers a wide range of technical topics around the MySQL Server and usually takes place once per week.

For the first time, the presentation will not be performed by (former) MySQL employees/developers, but by two of our "Sun Classic" colleagues: Jyri Virkki (OpenSolaris Web Stack community lead) and Murthy Chintalapati (Sr Engineering Manager, Web Stack development) will talk about the …

One of the sessions at DrupalCon I attended was Larry Garfield's talk about "Drupal Databases: The Next Generation", which gave me a good insight into the current state of the Drupal database layer and how they plan to overhaul it for Drupal 7. The key points that I took away:

• A new API based on PDO
• Object-oriented, requiring PHP5
• Support for using prepared statements
• A unified access API
• A query builder
• More support for other database systems (currently Drupal supports MySQL and PostgreSQL only). In particular, they are …

I had a nice chat with Kieran from Acquia at DrupalCon last week - we discussed how people running local Drupal user groups could expand their outreach into other communities, in particular into the MySQL User Groups. Scott Mattoon captured our conversation on video, which is now available on blip.tv:

Click To Play

The gist of what we talked about: if you are organizing a local Drupal User Group Meetup, check out http://mysql.meetup.com to find …

Lenz just posted pointers to a great presentation of his about MySQL HA and Drupal,

Seems like a small part of me did go to Szeged afterall :)

Lenz just posted pointers to a great presentation of his about MySQL HA and Drupal,

Seems like a small part of me did go to Szeged afterall :)