Loading…
Cloud Tech IV has ended

Cloud Tech is the largest gathering of cloud technologists & engineers in the bay area. Our speakers include the top cloud computing entrepreneurs & experts.

Come join us Saturday, October 6th, from 9am to 6pm. at the Computer History Museum in Mountain View, CA for a full 8 hours of learning directly from great minds sharing their secrets!

Register Here

Special thanks to our sponsors who made this all possible. They are: CloudStackScalrVMware,RackspaceHPDataStaxAWSCanonicalPuppet, and General Catalyst.

View analytic
Saturday, April 20 • 11:15am - 12:00pm
One to Many: The Story of Sharding at Box

Sign up or log in to save this to your schedule and see who's attending!

A step-by-step presentation of how we transitioned Box's web-application stack from a single bottlenecked MySQL database, to a fully sharded MySQL architecture, all the while serving 2 billion queries per day. The focus will be on the incremental steps and best practices that enabled the successful execution of this change, as well as the mistakes made and the lessons learned along the way.

We begin with an overview of our web application architecture both before and after sharding, and discuss our reasons for choosing sharded MySQL as our scaling solution. We then walk through the modifications we made to our ORM layer, including advanced features such as support for cross-shard queries and online moving of data between shards. Finally, we present a detailed description of the technique we developed for migrating live data to shards without downtime, which also supports table by table migration for added flexibility. Throughout the talk, the focus will be on how to make large-scale changes in an incremental fashion, without adversely affecting functionality, and most importantly without downtime.

 


Speakers
avatar for Tamar Bercovici

Tamar Bercovici

Staff Software Engineer, Box
Tamar Bercovici is a Staff Software Engineer at Box where she leads the Data Access Team in scaling Box’s database architecture and ORM layer. Prior to Box, Tamar was an early-stage employee at XMPie (now a Xerox company), where she drove the development of the award winning uImage product. Tamar holds a Ph.D. in Computer Science from the Technion... Read More →


Saturday April 20, 2013 11:15am - 12:00pm
Hahn Auditorium Computer History Museum

Attendees (7)