Scaling WordpressHow we scale Wordpress Multisite to server millions of users

Lana Wordpress team

Content● Why Wordpress?● Architecture● Scaling Wordpress● Demo● Open Source● Web Analytic● Q & A

Why Wordpress?● Most popular CMS● Open source● Lots of plugins & themes● Simple database model● Large community

Architecture

BUSINESS INTELLIGENCEPRODUCTION TECHNOLOGY STACK

MySQL

PHP

Wordpress vBulletin

MySQL MySQL

Customized vbSSOJasperR

eport

Server

Social

Data

mining

Cloud Tools

WP/vBB Customization

InfrastructurePlatformOur code

Google

Analytics

Nginx, Caching

Architecture

WordpressMultisite

Homepage

LamMe

TVMore...

Scaling Wordpress

Load Balancer

HTTP

Web1-n

Site 1Site 2

Site 3Site 4

Site 5Site 6

Mem Cache

1-n

Scaling Wordpress

WORDPRESS TEMPLATE

WORDPRESS CORE & PLUGINS

Core Files3rd-party PluginsOur plugins

Template 1 Template 2 Template 3

Homepage Beta● More than 600k articles● Handle at least 10% Webtretho (more than 8M per day)● Synchronizing with forum database

○ Articles○ User○ Comments○ Thanks

Homepage BetaWhat did we do?● Using ajax● Memcached:

○ W3 Total Cache ○ Our cached plugin

● Optimized Wordpress sql query

Demo● Plugins● Templates● SSO

Web AnalyticsWHAT WHYclick,click,click why_click,why_click,why_click

● Data Report ● Experiment & Testing● User’s behavior ● Competitor analysis

Web Analytics“WHAT” gap:● instantly useful● increase revenue/ reduce cost● improve customer’s satisfaction

Web Analytics - Sample

Implement

Measure

Analyze

Improve

Q & A

Q & A