For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse at email@example.com
Download the OSCON Data Sponsor/Exhibitor Prospectus
For information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of convention news and announcements, please sign up for the OSCON email bulletin (login required)
View a complete list of OSCON contacts
These days every database supports some form of replicated read slaves to enable horizontal scaling for read operations. That’s good, but what happens when you’re read traffic doesn’t spread uniformly across all nodes? What happens when you’re ability to write data and push it out amongst these nodes outstrips outstrips the capabilities of the master node? In these cases people turn to sharding, but how best to accomplish that isn’t quite the simple solution many people would like it to be.
In this talk we’ll focus on how to solve this problem; sharding data across multiple nodes to handle both read and write traffic, even in cases where that traffic might not be uniform. We’ll also cover how to keep things running; schema changes, index builds, and failover scenarios will all be covered, discussing the trade-offs and constraints that various database will impose upon you.
We’ll also discuss the other half of the equation; how this affects the applications that need to interface with the database. Sharded architectures add complexity to any environment, and navigating those waters can be tricky. We’ll cover some of the most common hurdles we’ve run across, and show how to stretch the patterns based on your needs.
Working on database backed, internet based systems for over a decade, Robert is co-author of the book Beginning PHP and PostgreSQL 8, maintains the phpPgAdmin software package, and has been recognized as a major contributor to the PostgreSQL project for his work over the years. An international speaker on databases, open source, and managing web operations at scale, he spends his days as COO of OmniTI, perhaps the best technology consulting firm on the planet.