Mining for Insight Within Two Billion Visits

Average rating: ****.
(4.00, 2 ratings)

Running a globally popular virtual world with over 10 million monthly users (Oct 2008) in more than 30 countries and 12 languages is one thing — sharding, scale-out, massive caching, and dozens of database servers can do that.

Collecting all that data back to one place and analysing what do users enjoy doing, figuring out how to improve the service, keeping the in-world economy in balance, and providing next-day business results back to the management is another. We’ve tried a few things over the years — in-house reporting tools, reporting “in the cloud” with tools like Google Analytics, data mining, etc. All have their uses, as well as their weaknesses. MySQL’s strong point hasn’t really been the capability to deal with datasets in the millions to billions of rows, and data warehousing solutions built on the technology that has been so familiar to us has had it’s issues.

However, with the introduction to Infobright’s Brighthouse storage engine, we gained control of the process again. Loading speeds increased enough to not just keep up with the torrent of new data, but to catch up to with everything else waiting for analysis, and to provide a view across the entire history of the business. Query speeds for ad-hoc analysis increased even further — and suddenly we don’t have to try to anticipate every possible future requirement!

I will describe what our main issues were prior to the implementation, overall steps through the deployment, results and a few things we have in mind as next steps.

Osma Ahvenlampi


Osma heads the development and technical teams for Sulake, creators of Habbo, a virtual world for teens operating in 32 countries around the world and serving 10 million unique visitors every month.

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.