Building high traffic websites with Drupal

Slide 1

Slide 1 text

freistil IT Building high- trafﬁc websites with Drupal Markus Heurung

Slide 2

Slide 2 text

Markus Heurung @muhh Drupal Developer, Linux Sysadmin, Trainer, IT Manager Co-Founder of freistil IT

Slide 3

Slide 3 text

What’s high trafﬁc? anonymous vs. authenticated static vs. generated

Slide 4

Slide 4 text

Overview of layers to optimise Browser Webserver PHP Filesystem Drupal Database

Slide 5

Slide 5 text

Static ﬁles Browser Apache Filesystem

Slide 6

Slide 6 text

Tuning Linux Fast disks File system cache File system layout

Slide 7

Slide 7 text

Tuning Apache MaxClients & Co. KeepAlive Scaling out new complexities: network ﬁlesystem deployment

Slide 8

Slide 8 text

Drupal Browser Apache File System MySQL PHP

Slide 9

Slide 9 text

Tuning PHP Get many CPU cores Use an opcode cache (APC) Check apc.php 128-256 MB

Slide 10

Slide 10 text

Drupal Database for almost everything. Content Conﬁguration Content queries and layout Caches Watchdog (logs)

Slide 11

Slide 11 text

Conﬁgure Drupal Compression CSS & JS aggregation Caching Watchdog into syslog into logstash

Slide 12

Slide 12 text

Choose your modules wisely!

Slide 13

Slide 13 text

Optimise your database queries generated by views

Slide 14

Slide 14 text

Tuning MySQL Disk I/O InnoDB Buffers (caches, temp tables)

Slide 15

Slide 15 text

use less DB

Slide 16

Slide 16 text

Caching ↓ memcached

Slide 17

Slide 17 text

Search and content collections ↓ Apache Solr

Slide 18

Slide 18 text

Content ↓ MongoDB

Slide 19

Slide 19 text

Browser Apache File System PHP - Drupal MySQL memcached Solr MongoDB APC

Slide 20

Slide 20 text

Varnish

Slide 21

Slide 21 text

Goal Varnish Apache Browser

Slide 22

Slide 22 text

Drupal conﬁguration

Slide 23

Slide 23 text

Tuning Varnish Modules:   Purge, Expire, Rules  Varnish Optimise VCL logic

Slide 24

Slide 24 text

https://www.ﬂickr.com/photos/kimberlykv/5061421858

Slide 25

Slide 25 text

monitor & measure measure your settings monitor your usage apply insights to your setup rinse & repeat

Slide 26

Slide 26 text

Thanks! Questions? ! [email protected]