Drupal Making News - Speaker Deck

Drupal Making News

by Arne Jørgensen

Slide 1

Slide 1 text

Trellon 25 Aug 16:00 Drupal Making News Arne Jørgensen & Christian Schmidt

Slide 2

Slide 2 text

Agenda • About Berlingske Media • Fundamental architechtural decisions • News articles as nodes • Caching • Questions

Slide 3

Slide 3 text

About us • Arne Jørgensen (arnested) Systems architect • Christian Schmidt (c960657) Systems architect

Slide 4

Slide 4 text

About Berlingske Media • Largest newspaper publishing group in Denmark • Established in 1749 by Ernst Henrich Berling • 62 print titles, including 11 national and regional dailies • 75 websites o 6 million users per month (unique cookies) o 175 million page views per month

Slide 5

Slide 5 text

BOND: Berlingske on Drupal • Project started in August 2008 • First site launched in May 2009 • Sites on BOND so far: o Newspapers: www.berlingske.dk, www.bt.dk, www.erhvervsbladet.dk o Verticals/sub-brands: www.business.dk, www.fri.dk, www.sporten.dk o Community: www.løbnu.dk

Slide 6

Slide 6 text

Roles • Journalist: Write news, choose pictures • Editor of the day: Prioritize news • Site manager: Modify Panels configuration • Developer: Write modules and themes, setup Panels • Sysadm

Slide 7

Slide 7 text

Fundamental decisions • All sites in one database • No Views, no CCK • Lots of Panels • Reverse proxy caching • Dedicated backend for journalists • All nodes have one primary term

Slide 8

Slide 8 text

All sites in one database • Several settings.php files that define $conf['theme_default'], one $db_url • 2.4 million nodes, including 1.2 million news articles and 600,000 image nodes • 60,000 taxonomy terms • MySQL InnoDB with transaction support • Master/slave database replication • Unpleasant surprises …

Slide 9

Slide 9 text

Nodes • Simple model • Primary term • URL alias • Presentation tags (terms) • Node references • Node listings: By time, or node queues

Slide 10

Slide 10 text

Primary term • Used for most node listings, sections etc. • Determines page layout for node view • Determines whether individual Panels panes are visible • Determines URL alias of nodes: www.sitename.dk/section/node-title

Slide 11

Slide 11 text

Caching • Memcache – take load off database • Reverse proxy – take load off database

Slide 12

Slide 12 text

Next step • Migrate regional sites to BOND • New caching strategy for logged in users • ?