addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Database Month! Bazaarvoice VP of Eng. Scott Bonneau - How to Scale Big on MySQL

How to Scale Big on MySQL? Break a Few Rules!

A Database Month event:

Throughout colleges and in development teams around the world, software developers are explicitly and implicitly taught a number of database principles: Normalization, avoid duplicating data storage, don't over-constrain your queries, and many others. In high scale web applications dealing with billions of requests, there are a number of these "rules" that commonly have to be broken. Bazaarvoice has over a terabyte of data in MySQL instances, and serves over a billion requests per month, however, as the Bazaarvoice backend scaled to this size, the team recognized a number of compromises made along the way and documented them in this presentation.

If you're worried about your application's scalability, or how to handle the onslaught of traffic when your new site launches, this presentation will give you some great techniques to consider and will introduce you to Engineers who've done this before. You'll hear us talk about which of these compromises paid off, and which we still regret. In addition to scaling on MySQL, we'll also talk briefly about other datastores we've used in conjunction with MySQL, when just an RDBMS wasn't enough.

Scott Bonneau is the VP of Engineering at Bazaarvoice, He is an experienced engineering manager with a proven track record of delivering Google-scale projects and building and organizing world-class engineering teams. Scott has proven himself as a team leader with excellent individual management and mentoring abilities, and as a systems architect who is not afraid to roll up the sleeves and crank out code when need be. Since joining Bazaarvoice he has been instrumental in the formation of the Data team, whose sole focus has been to create and maintain a datastore capable of managing terabytes of data and billions of requests per month.

RC Johnson is the New York City Development Manager at Bazaarvoice, Originally starting as a Senior Software Engineer, RC has been a part of the myriad of changes the backend systems have gone through over the last four plus years of exponential growth. With his recent background in technology, RC is now leading the creation of a New York based Bazaarvoice Engineering team working on complex problems and large datasets.

Event video will be broadcast live over the GoChat VideoChat! on

Seeking data replication and clustering for business-critical open source databases? Check out Continuent Tungsten for a zero-downtime solution.

Seeking a scaling solution for MySQL? Check out ScaleBase, they make MySQL sharding easy!

Schooner created SchoonerSQL, a high-performance high-availability database that's 100% compatible with standard MySQL and InnoDB, and Membrain, a complementary cache that's 100% compatible with memcached.

Vork Enterprise Framework is the most-scalable high-performance PHP framework and can be learned & mastered in under an hour!

Power-Networking at 6:45pm
Presentation starts at 7:00pm

Join or login to comment.

  • Eric David B.

    Event video in HD at:

    July 11, 2012

  • A former member
    A former member

    It was very helpful to hear about how different database/data store options are viable to create an overall solution.

    January 31, 2012

  • Irina L.

    Awesome presentation! Very educational, engaging, up to the point and extremely useful! Didn't know much about Bazzarvoice but would definitely keep tabs on them after this presentation.

    January 31, 2012

  • Gary C.

    Interesting and beneficial discussion on how to scale mySQL in the real world. Takeaway some tips to be implemented at my workplace

    January 31, 2012

  • A former member
    A former member

    Yes it was recorded. Slides and video will be available soon on the database month site I believe.

    January 31, 2012

  • A former member
    A former member

    We do over a billion page views a month to our origin servers and store over a terabyte of content in MySQL.

    January 29, 2012

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy