Scaling WordPress for High Traffic Sites

Presented at WordCamp Manila 2017, Microsoft, Makati City, Manila Philippines

Transcript

1. Scaling WordPress for High Traffic Sites
2. Customer Success Engineer Pantheon Performance & Application Senior Developer X-Team IT Consultant World Bank Senior Developer New Amsterdam Ideas (NuCivic now) Who am I ? Weston Ruter Technology Director, XWP
3. “We have a Million of Containers and running 6 Billion Pageviews a month”
11. CMS Support Spectrum
17. Today’s Topics • Page Caching • Object Caching • Query Performance • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
19. How Varnish Works
20. How Varnish Works
21. How Varnish Works
22. Page Caching
23. Page Caching Challenges & Takeaways Cache TTL and Expiration Fragment caching Cookies
24. Page Caching
25. Page Caching
26. Today’s Topics • Page Caching • Object Caching • Query Performance
 • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
27. Object Caching An object cache speeds up PHP execution time while lessening the load on the database.
28. Object Cache Challenges & Takeaways ! Complexity
 ! Invalidation
 ! Optimization
 ! Eviction
29. Object Cache
30. LCache for WordPress
31. LCache for WordPress
32. Today’s Topics • Page Caching • Object Caching • Query Performance • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
33. Query Performance mysql> SELECT count(*) FROM wp_options WHERE autoload=’yes’;
34. Mysql Replication Break
35. Mysql Replication Break
36. Mysql Replication Break
37. Avoiding “Queries of Death”
40. Query Performance Challenges & Takeaways ! Query routing
 ! Replication lag
 ! Debuggability
 ! Regressions
41. Query Performance
42. Today’s Topics • Page Caching • Object Caching • Query Performance
 • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
43. Searching for Scale Use a dedicated search index like Apache Solr or ElasticSearch
44. Searching for Scale Challenge & Takeaways ! Overriding WP_Query ! Index Rebuilds ! Complexity
45. Today’s Topics • Page Caching • Object Caching • Query Performance • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
46. Elastic Architecture Horizontal Scalability Is the Scalability That Matters
47. Traditional Options Shared vs VM vs Cluster
48. Traditional Options at Scale In Real Life
49. Next Generation Architecture The Same Design, Just Add More
50. Elastic Architecture Challenges and Takeaways ! Load balancing
 ! Shared media
 ! Consistency
51. Today’s Topics • Page Caching • Object Caching • Query Performance
 • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
52. Development & Workflow
53. Development & Workflow
54. Development & Workflow
55. Development Workflow Challenges & Takeaways •Environmental consistency •Site configuration •Local development •Automation
56. Today’s Topics • Page Caching • Object Caching • Query Performance
 • Searching for Scale
 • Elastic Architecture • Development and Workflow • A Real-World Scalable Architecture
57. ✓Linux ✓Varnish or Edge Cache Provider ✓Content Delivery Network ✓Apache or Nginx ✓PHP ✓Memcached or Redis ✓ElasticSearch or Apache Solr ✓MySQL and Database Replication Putting it all Together