Building high traffic websites with Drupal

The slides for my talk at World Hosting Days 2014 in Rust, Germany.
An overview of technologies you should use to boost Drupal performance.

Transcript

1. freistil IT
   Building high-
   traffic websites
   with Drupal
   Markus Heurung
   

   View Slide

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

   View Slide

3. What’s high traffic?
   anonymous vs. authenticated
   static vs. generated
   

   View Slide

4. Overview of layers
   to optimise
   Browser Webserver
   PHP Filesystem
   Drupal Database
   

   View Slide

5. Static files
   Browser
   Apache
   Filesystem
   

   View Slide

6. Tuning Linux
   Fast disks
   File system cache
   File system layout
   

   View Slide

7. Tuning Apache
   MaxClients & Co.
   KeepAlive
   Scaling out
   new complexities:
   network filesystem
   deployment
   

   View Slide

8. Drupal
   Browser
   Apache
   File System MySQL
   PHP
   

   View Slide

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

   View Slide

10. Drupal
    Database for almost everything.
    Content
    Configuration
    Content queries and layout
    Caches
    Watchdog (logs)
    

    View Slide

11. Configure Drupal
    Compression
    CSS & JS aggregation
    Caching
    Watchdog into syslog into logstash
    

    View Slide

12. Choose your
    modules wisely!
    

    View Slide

13. Optimise your
    database queries
    generated by views
    

    View Slide

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

    View Slide

15. use less DB
    

    View Slide

16. Caching
    ↓
    memcached
    

    View Slide

17. Search and
    content collections
    ↓
    Apache Solr
    

    View Slide

18. Content
    ↓
    MongoDB
    

    View Slide

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

    View Slide

20. Varnish
    

    View Slide

21. Goal
    Varnish
    Apache
    Browser
    

    View Slide

22. Drupal configuration
    

    View Slide

23. Tuning Varnish
    Modules: 

    Purge, Expire, Rules

    Varnish
    Optimise VCL logic
    

    View Slide

24. https://www.flickr.com/photos/kimberlykv/5061421858
    

    View Slide

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

    View Slide

26. Thanks!
    Questions?
    !
    markus@freistil.it
    

    View Slide