Database Scalability Patterns

Location: Portland 255
Average rating: ***..
(3.73, 26 ratings)

We often have clients approach us looking for help in scaling their systems, and all too often their long term vision is a mixed reality based on the approaches read about on popular blogs from people trying to solve very different problems. Hey, scaling your database can be difficult enough by itself, you don’t want to get tripped up by not understanding where you’re really going. In Database Scalability Patterns we will attempt to distill all of the information/hype/discussions around scaling databases, and break down the common patterns we’ve seen dealing with scaling databases. “Buzzwords” we’ll cover (and hopefully debuzz) include:

Vertical Scaling
Horizontal Partitioning
Horizontal Scaling
Read Slaves
Vertical Partitioning
Federated Data Storage

More important than just describing what these things are (although that’s a good first step), we’ll also discuss along the way different points in the life-cycle of your database when you need to be thinking about the different options in front of you. We’ll factor in the types of application that your working on (think OLTP vs OLAP, or Social Networking vs. Corporate Application), the environment you’ll be working on (Scaling “in the cloud” is very different from DIY in the datacenter), and we will talk about the types of tools you’ll need to accomplish these goals (All replication systems are not the same, and some won’t help at all).

Photo of Robert Treat

Robert Treat


Robert Treat leads the Database Operations Group at OmniTI and has been working with open source for over a decade. An author and veteran industry speaker at conferences worldwide, Robert is a recognized expert within the open source database industry, maintaining a popular blog at

Comments on this page are now closed.


Picture of Dirk Bergstrom
Dirk Bergstrom
07/21/2010 7:43am PDT

Got me up to speed on an area I was embarrassingly behind the times on. My only complaint is that he didn’t get around to defining “sharding” and SOA, despite mentioning them.

  • Intel
  • Microsoft
  • Google
  • Facebook
  • Rackspace Hosting
  • (mt) Media Temple, Inc.
  • ActiveState
  • CommonPlaces
  • DB Relay
  • FireHost
  • GoDaddy
  • HP
  • HTSQL by Prometheus Research
  • Impetus Technologies Inc.
  • Infobright, Inc
  • JasperSoft
  • Kaltura
  • Marvell
  • Mashery
  • NorthScale, Inc.
  • Open Invention Network
  • OpSource
  • Oracle
  • Parallels
  • PayPal
  • Percona
  • Qualcomm Innovation Center, Inc.
  • Rhomobile
  • Schooner Information Technology
  • Silicon Mechanics
  • SourceGear
  • Symbian
  • VoltDB
  • WSO2
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the OSCON 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

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON Newsletter (login required)

OSCON 2.0 Ideas

Have an idea for OSCON to share?

Contact Us

View a complete list of OSCON contacts