Schedule: Architecture and Technology sessions

Add to your personal schedule
Location: Ballroom A
Jeremy Zawodny (craigslist.org)
Average rating: ***..
(3.22, 9 ratings)
This talk will discuss the ongoing evolution of data storage at Craigslist, starting from a homogeneous one-size fits all "MySQL everywhere" approach and moving toward a heterogeneous environment that considers our real data and performance needs and the plethora of tools available today (including Redis, MongoDB, MySQL, and Sphinx). Read more.
Add to your personal schedule
Location: Ballroom C
Sarah Sproehnle (Cloudera, Inc.)
Average rating: ****.
(4.00, 3 ratings)
Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reporting and injestion of large amounts of raw or unstructured data. Read more.
Add to your personal schedule
Location: Ballroom D
John Smiley (Amazon.com)
Average rating: **...
(2.14, 7 ratings)
Amazon engineers share experiences managing a large fleet of MySQL databases. Read more.
Add to your personal schedule
Location: Ballroom F
Tags: ec2
Anders Karlsson (Recorded Future)
Average rating: ***..
(3.50, 2 ratings)
Does it really work well to have large amount of data on Amazon EC2? Yes it does, but it does require some careful thinking and testing. EC2 is not like your standard Linux box when in terms of cabability of sustaining a high load and large amounts of data. But it can sure be done, but in a different way. This talk is about what Recorded Future has experienced when working with EC2. Read more.
Add to your personal schedule
Location: Ballroom A
Jay Janssen (Percona, Inc.)
Average rating: ***..
(3.57, 7 ratings)
In the midst of many attempts to "solve" the RDBMS high availability problems, the vast majority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architecture, it's advantages and disadvantages, as well what we see as needed for future HA advances. It's old-school, it's crude, but somehow it solves most HA problems. Read more.
Add to your personal schedule
Location: Ballroom B
Giuseppe Maxia (Continuent)
Average rating: ***..
(3.33, 3 ratings)
Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience. Read more.
Add to your personal schedule
Location: Ballroom E
Ryan Thiessen (Facebook)
Average rating: ****.
(4.67, 9 ratings)
Getting sharding right is crucial for achieving high scale with MySQL on commodity hardware like we do at Facebook. We will overview sharding best practices, and show some examples of both successful and unsuccessful methods at sharding MySQL. Read more.
Add to your personal schedule
Location: Ballroom D
Stewart Smith (Percona)
Average rating: *****
(5.00, 2 ratings)
HailDB is a project that maintains InnoDB as a shared library (forked from embedded_innodb). It provides an API direct to InnoDB without any pesky SQL in front of it. This session is an introduction to HailDB, followed by an introduction to programming it. Read more.
Add to your personal schedule
Location: Ballroom E
Tags: postgis, gis
Ragi Burhum (Burhum LLC - GIS Consulting)
Average rating: ****.
(4.00, 2 ratings)
PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. It includes support for spatial indexes, and functions for analysis and processing of GIS objects. Read more.
Add to your personal schedule
Location: Ballroom F
Colin Charles (SkySQL Ab/MariaDB Foundation)
MariaDB - Community Developed. Feature Enhanced. Backward Compatible. A branch of the popular MySQL database, the project began in 2009 around a storage engine, but quickly evolved to being another database project, with two major releases in 2010. This session will introduce the project, and will help any DBA or developer get to grips with MariaDB. Read more.
Add to your personal schedule
Location: Ballroom F
Average rating: *****
(5.00, 1 rating)
Eucalpytus is a GPL open-source private cloud computing infrastructure platform that is compatible with Amazon Web Services. It has an undeserved reputation as being hard to provision, install, and operate. We hope to help dispel this reputation by walking through and talking through installation and operation of a small Eucalyptus cloud. Read more.
Add to your personal schedule
Location: Ballroom B
Tags: dba, scale_out
Average rating: ***..
(3.57, 7 ratings)
In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier. Read more.
Add to your personal schedule
Location: Ballroom D
Vadim Tkachenko (Percona Inc)
Average rating: ***..
(3.00, 3 ratings)
Percona Server is most known for its performance and slow-log diagnostics, but it has many other useful features. In this talk I will describe them. Read more.
Add to your personal schedule
Location: Ballroom F
Eric Day (craigslist)
Average rating: **...
(2.00, 2 ratings)
The OpenStack project was launched last summer by Rackspace, NASA, and a number of other cloud technology leaders in an effort to build a fully-open cloud computing platform. It is a collection of scalable, secure, standards-based projects currently consisting of OpenStack Compute and OpenStack Object Storage. This session will introduce the projects, principles behind it, and how to get started. Read more.
Add to your personal schedule
Location: Ballroom B
Vadim Tkachenko (Percona Inc)
Average rating: ****.
(4.00, 5 ratings)
Are you considering how to use SSD disks with MySQL? Should you even use them? Will they make your database faster? They are still expensive, so how can you get the most out of them? This is the talk for you Read more.
Add to your personal schedule
Location: Ballroom D
Roland Bouman (XCDSQL Solutions / Strukton Rail)
MQL-to-SQL is open source software that lets you query a RDBMS over HTTP using MQL (Metaweb Query Language). MQL is the native query language of www.freebase.com. There are good reasons to want MQL also as RDBMS query language, instead of SQL. This talk explains what MQL is, how it compares to SQL, why MQL is great for AJAX apps, and how MQL-to-SQL allows you to query RDBMSes like MySQL & Postgres Read more.
Add to your personal schedule
Location: Ballroom A
Michael Glaesemann (myYearbook.com)
Average rating: ***..
(3.50, 2 ratings)
Founded by two high school students in 2005, myYearbook.com has grown to become one of the top 5 social networks and one of the top 25 most trafficked web sites in the United States. In this session, we'll review the growing pains, unique architectural decisions, and methodologies employed to support the consistent growth and demand of a social network. Read more.
Add to your personal schedule
Location: Ballroom D
Jeff Davis (Aster Data)
Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications. Read more.
Add to your personal schedule
Location: Ballroom F
Tags: nosql, mongodb
Eliot Horowitz (MongoDB)
Average rating: ***..
(3.43, 7 ratings)
While MySQL and MongoDB often fight over the same deployment, there are many cases where MySQL and MongoDB should be used in conjunction. They each excel at different things, so its important to understand when to use one or the other, and how to make them work well together. Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB Read more.
Add to your personal schedule
Location: Ballroom A
Corey Donohoe (GitHub)
Average rating: ***..
(3.67, 3 ratings)
GitHub's history with MySQL and what we've built off of it. Read more.
Add to your personal schedule
Location: Ballroom B
Ronald Bradford (EffectiveMySQL)
Average rating: ****.
(4.00, 5 ratings)
Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations. Read more.
Add to your personal schedule
Location: Ballroom E
Robert Hodges (Continuent.com)
Average rating: ****.
(4.33, 3 ratings)
Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works. Read more.
Add to your personal schedule
Location: Ballroom F
J Chris Anderson (Couchbase)
Average rating: ****.
(4.60, 5 ratings)
Apache CouchDB implements a reliable storage engine, webserver, and HTTP application server environment, in under 20k lines of Erlang and JavaScript source code (with an additional X lines of test code.) I'll show 3 related examples that strike at the core of CouchDB's simplicity: The storage engine, the incremental map reduce views, and replication. Read more.
Add to your personal schedule
Location: Ballroom G
Eran Levin (Xeround)
If you thought running a database in the cloud was easy, think again. Databases in a cloud environment are inherently different from traditional installations in a datacenter or even in your trusted hosted environment. Today I'll explain the four key considerations we believe every system architect should take into account when designing their database for the cloud. Read more.
Add to your personal schedule
Location: Ballroom H
Michael Widenius (Monty Program Ab), Kristian Nielsen (MariaDB / Monty Program AB)
Group commit is a very important optimisation for ACID storage engines in high transaction-per-second OLTP that is implemented for the binlog in MariaDB. Usage, benchmarks, and technical details of the implementation are presented, as well as the underlying extension to the storage engine API that enables better provisioning of replication slaves from non-blocking backup, and other enhancements Read more.
Add to your personal schedule
Location: Ballroom A
Tags: case_study
Tao Cheng (AOL)
Average rating: ***..
(3.00, 3 ratings)
AOL deployed its large scale Real Time News (RTN) system in 2007. This system receives news updates from over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabytes of data. However, news are delivered to end users in close to real time fashion. This presentation shares how it is done and the lessons learned. Read more.
Add to your personal schedule
Location: Ballroom B
Ronald Bradford (EffectiveMySQL)
Average rating: ***..
(3.60, 5 ratings)
Too much for just one session, in Part 2 we continue with learning the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time. Read more.
Add to your personal schedule
Location: Ballroom D
Andy Parsons (Obikosh.com)
As CTO of Outside.in, and in my new stealth company, I've seen my share of challenging scenarios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars! Read more.
Add to your personal schedule
Location: Ballroom E
Venu Anuganti (ScaleIN)
Average rating: *....
(1.00, 1 rating)
This is a DBA or Data Architect perspective session which covers designing MySQL as data warehouse solution to handle tera bytes of data which compromises OLTP, ETL, OLAP and reporting Read more.
Add to your personal schedule
Location: Ballroom F
Matt Freels (Twitter)
Average rating: *....
(1.67, 3 ratings)
At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate. Read more.
Add to your personal schedule
Location: Ballroom E
Kevin Knapp (Facebook)
Average rating: ***..
(3.80, 5 ratings)
A real-world example of how re-sharding and table partitioning cut load data times in Facebook's analytics infrastructure from greater than 24 hours to less than 5 minutes. Read more.
Add to your personal schedule
Location: Ballroom F
Yekesa Kosuru (Nokia), Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.00, 1 rating)
The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discussions that focus on availability and scalability highlight ACID issues but not really SQL. The key-value systems can be built many ways and relational databases as a back end is a serious contender. Read more.
Add to your personal schedule
Location: Ballroom H
Selena Deckelmann (PostgreSQL)
Average rating: ****.
(4.00, 1 rating)
Taking lessons from the PostgreSQL community, and recent experience with the growing communities around the forks of MySQL, this talk will lead business owners, project managers and developers through best practices for connecting to and being successful working with open source database developers. Read more.
Add to your personal schedule
Location: Ballroom A
Matt Ingenthron (Couchbase, Inc.)
Average rating: ****.
(4.00, 1 rating)
With contemporary web applications, data is never isolated to one store. Memcached has long been a partner to MySQL; now Membase, a persistent, replicated, clustered memcached-protocol-compatible datastore is used alongside MySQL for simple, fast key-value access. This session will dispel the idea of needing to choose between SQL or NoSQL, showing how you can be both rich and fast. Read more.
Add to your personal schedule
Location: Ballroom E
Tags: sharding
Gwen Shapira (Pythian)
Average rating: ****.
(4.00, 4 ratings)
Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database. Read more.
Add to your personal schedule
Location: Ballroom F
Average rating: ****.
(4.33, 3 ratings)
Most of high scale web applications use memcached + MySQL or NoSQL. It is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently developed HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our production. We'd like to share our experiences. Read more.
Add to your personal schedule
Location: Ballroom H
Mat Keep (MySQL), Bernhard Ocklin (Oracle Svenska AB)
Discover how MySQL Cluster can be used to store session data for the new generation of web applications that demand persistence, massive scalability and high levels of availability. We'll cover what today's applications need from a session store; why MySQL Cluster is so suited to meeting those needs and how to implement them. To make this more real we'll present some real life case studies. Read more.
Add to your personal schedule
Location: Ballroom D
Antony Curtis (Blizzard Entertainment)
Antony shows the OQGRAPH engine in MariaDB 5.2, allowing you to deal with graphs (networks) for social networking, hierarchies and other complex structures, all in plain clean SQL. Read more.
Add to your personal schedule
Location: Ballroom E
Sarah Novotny (NGINX)
Average rating: *****
(5.00, 1 rating)
MySQL's replication system has been a core feature often touted for scaling (sort of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicating to one another) as a reference for the many uses and misuses of replication. Read more.
Add to your personal schedule
Location: Ballroom H
Timour Katchaounov (Monty Program Ab)
Average rating: ****.
(4.50, 2 ratings)
MySQL supports subqueries since version 4.1 released 8 years ago. Due to their simplistic implementation and resulting poor performance, subqueries have been considered as practically unusable by many users. Read more.
Add to your personal schedule
Location: Ballroom E
Average rating: ****.
(4.00, 1 rating)
MySQL 5.5 features a new transactional lock manager, available to all storage engines. The new subsystem allowed to solve a number of old MySQL architecture problems, such as lack of transactional awareness of data definition language, as well as opened the door for a number of new performance and scalability improvements. Read more.
Add to your personal schedule
Location: Ballroom F
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.00, 2 ratings)
Aside from traditional master-slave setup used mostly for HA and read scale-out, there is an established history of attempts at multi-master replication with MySQL. In this presentation we will look at what multi-master replication can do for us and compare different approaches of doing it. Read more.
Add to your personal schedule
Location: Ballroom C
Moshe Shadmon (ScaleDB)
ScaleDB is a pluggable storage engine for MySQL. It turns MySQL into an enterprise-class, highly-available, clustered database that scales dynamically in a public and private cloud. Read more.
Add to your personal schedule
Location: Ballroom E
Michael McLaughlin (BYU - Idaho)
Average rating: ***..
(3.00, 1 rating)
Presents an in-depth view of how to combine and integrate MySQL subroutines with the security model. Shows how stored programs best support AJAX enabled web applications. Demonstrates how the MySQL security layers can support transaction control in stored functions and procedures. Provides examples on how to encapsulate key logic from web developers. Read more.
Add to your personal schedule
Location: Ballroom G
Tetsuro Ikeda (Sumisho Computer Sytems Corporation), Kentoku SHIBA (WildGrowth), Daijiro MORI (brazil), Tasuku SUENAGA (Brazil, Inc.)
Average rating: *****
(5.00, 1 rating)
In this session, We introduce groonga Storage engine which enables for MySQL to handle fulltext search lightly. groonga is a library which have storages and indexes for fast fulltext searching. The backend of groonga Storage Engine is groonga library. With groonga Storage Engine, you can use datas in groonga as a usual MySQL tables. Read more.
Add to your personal schedule
Location: Ballroom D
Justin Swanhart (Percona), Ryan Lowe (Percona)
Average rating: ****.
(4.67, 3 ratings)
This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation. I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads. Read more.
  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts