Supercharging Drupal - Speaker Deck

Slide 1

Slide 1 text

freistil.it Supercharging Drupal Jochen Lillich

Slide 2

Slide 2 text

Jochen Lillich @geewiz Sysadmin since 1993 Managing director of freistil IT IT architect for freistilbox

Slide 3

Slide 3 text

Tuning strategies 10 Optimise capacity 20 Minimise cost 30 Measure 40 GOTO 10

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

“They stink?”

Slide 6

Slide 6 text

“They make you cry?”

Slide 7

Slide 7 text

Layers

Slide 8

Slide 8 text

Browser Apache File System Static ﬁles

Slide 9

Slide 9 text

Tuning Linux Fast disks File system cache File system layout

Slide 10

Slide 10 text

Tuning Apache MaxClients & Co. KeepAlive CPU with AES support

Slide 11

Slide 11 text

Browser Apache File System Drupal MySQL PHP

Slide 12

Slide 12 text

Tuning MySQL Disk drives InnoDB Buffers tmpdir

Slide 13

Slide 13 text

Optimise your f%#§ing  SQL queries!

Slide 14

Slide 14 text

Tuning PHP Get many CPU cores Use an opcode cache

Slide 15

Slide 15 text

Browser Apache File System Opcode Cache MySQL PHP APC

Slide 16

Slide 16 text

Tuning APC 64-128 MB Check apc.php

Slide 17

Slide 17 text

Tuning Drupal Compression Aggregation Caches Choose modules wisely

Slide 18

Slide 18 text

Browser Apache Object Cache MySQL PHP memcached memcached

Slide 19

Slide 19 text

Conﬁguration $conf['cache_default_class'] = 'MemCacheDrupal'; ! $conf['cache_class_cache_form'] = 'DrupalDatabaseCache';

Slide 20

Slide 20 text

Browser Apache HTTP Cache Varnish

Slide 21

Slide 21 text

Drupal conﬁguration

Slide 22

Slide 22 text

Cache headers HTTP/1.1 200 OK Date: Wed, 06 Nov 2013 17:30:00 GMT X-Drupal-Cache: MISS Expires: Sun, 19 Nov 1978 05:00:00 GMT Last-Modified: Wed, 06 Nov 2013 17:29:45 +0000 Cache-Control: public, max-age=3600 X-Generator: Drupal 7 (http://drupal.org) Vary: Cookie,Accept-Encoding Age: 14 X-Varnish-Cache: HIT X-Varnish-Cache-Hits: 2

Slide 23

Slide 23 text

Tuning Varnish Modules: Purge, Varnish Optimise VCL logic IsVarnishWorking.com

Slide 24

Slide 24 text

http://www.ﬂickr.com/photos/seriousbri/4020277369

Slide 25

Slide 25 text

Browser Apache Search Engine MySQL PHP Solr

Slide 26

Slide 26 text

Tuning Solr Caching # of indexed/stored ﬁelds mergeFactor Sharding

Slide 27

Slide 27 text

Other approaches CDN Load balancing

Slide 28

Slide 28 text

Daily practice Management Updates Monitoring Metrics … Know-how

Slide 29

Slide 29 text

We’re hiring!

Slide 30

Slide 30 text

Thanks! Questions? ! [email protected]