Making Drupal fly with Pressflow, varnish and more for performance

This article is currently a work in progress.

Drupal I believe is one of the best Open Source content management systems available and it's constantly improving. One of the reasons for its appeal is the amount of modules available that give it a vast array of functionality. This is however a drawback as well. All of this functionality comes at the cost of performance. Even a modest amount of modules left without any performance enhancements turned on will make the most basic of sites very slow. Turning on Drupal's Normal caching offers a significant boost because it caches pages to the database so they don't need to be built again but there's a hell of a lot more you can do. In a nutshell, imagine serving a cached version your website completely from memory without even touching the web server or file system. Of course, at some point requests do need to go through to Drupal and when that happens we can make Drupal perform close to the speed of compiled code.

The technologies that make this possible are reverse proxy caches such as Varnish, and OpCode caching such as APC and database caching with Memcache.

Notes:
Don't check cache for "SESS" (User is logged in - only Pressflow), "NO_CACHE" (User has recently posted), cron.php
Varnish module

Amazon instances

http://thecloudmarket.com/image/ami-9f9f70f6--pantheon-mercury-32-bit-1-0

Innodb

There are various advantages to using Innodb vs Myisam for some database tables. One big issue with Innodb can be the fact that the filesize cannot shrink when rows are deleted and of course the larger a file is, the longer it takes to process. However there is a setting, 'Using Per-Table Tablespaces', that offers several advantages, especially if you are dealing with large tables.
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
The advantages are things like being able to store tables on separate physical disks.

Other stuff

Post new comment

By submitting this form, you accept the Mollom privacy policy.

User login

Author of...

  • Did you know today is world peace day? http://t.co/5woHsuaQ 7 years 35 weeks ago
  • If you would like to donate to Sport relief and change people's lives the address is: http://t.co/riQCnQEq 8 years 9 weeks ago
  • Why big businesses cannot compete with small businesses: http://t.co/dNaQVJv3 8 years 12 weeks ago
  • The newest addition to my kindle: 'Know Me, Like Me, Follow Me' - Social networking for business by @pennypower http://t.co/hPVMRQKe 8 years 12 weeks ago
  • Using YouTube videos to improve your exposure and credibility http://t.co/rLKx6ByY 8 years 12 weeks ago
  • Penny power making great points about social media being personal #kpiday 8 years 13 weeks ago
  • @philhawksworth Yes, I lust after kate 8 years 14 weeks ago
  • Monday the 13th is the new Friday 13th. 8 years 15 weeks ago
Oliver Polden