Clickability: Scaling SaaS with MySQL and memcached

Architecture and Technology, ISV/OEM, Java, Replication and Scale-Out
Location: Ballroom G Level: Intermediate
Average rating: ****.
(4.00, 3 ratings)

Clickability is the global leader in On Demand Web Content Management, offering the first and only commercially available, multi-tenant, Web content management and publishing platform on the market. This platform brings together multiple services into one integrated solution and delivers over 400 million pages per month across hundreds of customer websites. The demands of delivering a platform on this scale are magnified by the flexibility that Clickability’s platform provides customers in creating truly unique and innovative websites.

Building a SaaS platform requires application and infrastructure engineering that push beyond “enterprise scale” to “web scale”. MySQL and Memcached play a key role in scaling the Clickability platform. This presentation will tell the evolutionary story of the core architectural and technology components that have allowed the Clickability Platform to scale from 0 to 400 million pages delivered per month without changes to the core platform architecture.

Application platform – from 2 servers to 200

  • use of Java
  • distributed application architecture
  • loose coupling around the data
  • database connection management and load balancing

MySQL Databases – from 2 servers in one datacenter, to 30 servers across three datacenters

  • early separation of database early to scale needs independently
  • master/master for HA from day one
  • master/slave for splitting reads and writes
  • multi-datacenter replication for DR and HA
  • MySQL 5.1 table partitioning benefits, including performance gain metrics

Multi-tiered Caching – performance, performance, performance

  • Squid, Java Ehcache and Memcached
  • “Cache clear” messaging subsystem
  • Performance metrics/gains from adding these caching layers
Photo of Jeff Freund

Jeff Freund


Jeff Freund, Clickability, Inc.

Chief Technology Officer & Founder

Jeff designed and deployed the first and only pure-play SaaS platform for the entire web content lifecycle, from content creation to optimization. His work to launch the flagship Clickabilty cmPublish platform in 2003 has advanced and his team’s solutions will be serving over 200 million pages per month by end of 2007. In addition to the platform’s core content management and publishing capabilities, Jeff has overseen the launch of Clickability’s comprehensive suite of publishing modules, which include an ad server, newsletter services, reports, polls and surveys, and search capabilities.

With over 10 years of software and Internet experience, Jeff’s earlier posts include Western U.S. head of technology for Network Software Associates, a provider of legacy-to-web host connectivity products for enterprise customers. He collaborated on Linux cluster supercomputer projects at UCLA. Jeff received his BS and MS in Environmental Engineering from Stanford University.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.