Personal schedule for Darren Cassar

Download or subscribe to Darren Cassar's schedule.

Tutorial
Location: Ballroom E
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.80, 5 ratings)
MySQL replication is the backbone of web scalability principles. This tutorial tells you how to go beyond the basics, to using MySQL replication more productively, by combining existing techniques and adopting new ones. After covering the basics, we will explore failover techniques, several performance boosting tricks, and emerging technologies that you can adopt in house and in the cloud. Read more.
Tutorial
Location: Ballroom F
Brian Aker (HP), Alan Kasindorf (Six Apart)
Average rating: ****.
(4.00, 1 rating)
Back by popular demand we have the Memcached tutorial. Come learn about what is new and exciting in the world of Memcached. Read more.
Tutorial
Location: Ballroom G
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.50, 4 ratings)
This is updated and revised version of tutorial done at MySQL Conference 2010 Read more.
Tutorial
Location: Ballroom D
Justin Swanhart (Percona), Ryan Lowe (Percona), Baron Schwartz (VividCortex)
Average rating: ****.
(4.50, 8 ratings)
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory. Read more.
Tutorial
Location: Ballroom H
Robert Hodges (Continuent.com), Edward Archibald (Continuent)
Average rating: ***..
(3.00, 1 rating)
MySQL replication deprivation is a common condition that occurs when you encounter problems built-in MySQL replication cannot solve. Do you need automatic master promotion, ability to replicate to PostgreSQL or Oracle, multi-master/multi-source replication, parallel slave apply, or built-in consistency checking? Read more.
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.60, 5 ratings)
MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks. Read more.
John Smiley (Amazon.com)
Average rating: **...
(2.14, 7 ratings)
Amazon engineers share experiences managing a large fleet of MySQL databases. Read more.
Architecture and Technology
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.
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.
Architecture and Technology
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.
Drizzle
Location: Ballroom F
Tags: drizzle
Andrew Hutchings (Hewlett-Packard)
Average rating: ***..
(3.00, 2 ratings)
Drizzle was originally forked from MySQL in 2008 and has since gone through many changes. It is now very different from its MySQL cousin, so this talk is aimed to help anyone new to Drizzle get to grips with it from both a DBA and an application developer point of view. Read more.
Tags: dba, schema
Danil Zburivsky (The Pythian Group)
Average rating: ****.
(4.20, 5 ratings)
Production schema changes are painful but unavoidable. This session will tell you how to minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables. Session will focus on pros and cons of each approach and describe most common use cases. Read more.
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.
PostgreSQL
Location: Ballroom E
Bruce Momjian (EnterpriseDB)
Average rating: **...
(2.50, 2 ratings)
This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. Read more.
Gerardo Narvaja (SkySQL Inc.)
Traditionally replication has been monitored using the information in SHOW SLAVE STATUS, however it doesn't always represent the full picture. This presentation will outline how combining different methodologies it is possible to obtain a more accurate picture about replication health. Read more.
Tags: dba, security, ssl
Chris Conlon (yaSSL)
Average rating: ***..
(3.75, 4 ratings)
Security is becoming more important than ever, and as such, it should be a high concern for MySQL users. In this session we will cover important MySQL security practices, with a focus on configuring and using SSL with MySQL. Although sometimes overlooked, data in transit is vulnerable and should be secured. The use of SSL/TLS provides us with a tool to help protect peace of mind and data security. Read more.
NoSQL
Location: Ballroom E
Tom Hanlon (Cloudera)
Average rating: ****.
(4.00, 2 ratings)
HBase is an open source column store built on top of Hadoop. In this 45 minute session you will get a brief introduction into the design of HBase, and the underlying framework along with some usage examples. Read more.
Tags: mysql, security
Darren Cassar (MySQLPreacher)
Average rating: ***..
(3.00, 2 ratings)
Security is often considered a waste of time given its tedious, painful and underestimated. This is where securich comes to the rescue helping you control users, privileges and enforce good passwords. User cloning, renaming, password complexity and much much more. Read more.
Dan Rogart (Zynga), mohan krishnan (Zynga)
Average rating: ***..
(3.33, 3 ratings)
We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands. Read more.
Tags: dba
Baron Schwartz (VividCortex)
Average rating: ***..
(3.88, 8 ratings)
This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status. Read more.
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.
Tags: dba, security
Fernando Ipar (Percona), Ryan Lowe (Percona)
Average rating: **...
(2.67, 3 ratings)
Achieving PCI compliance can be a difficult and expensive process. This session will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy them. Read more.
Tags: dba, security
Shlomi Noach (openark.org)
Average rating: ****.
(4.50, 2 ratings)
openark-kit is a tool set of scripts which fills in some gaps in daily MySQL maintenance work. Some scripts make for automation of routine work; others introduce new functionality to the MySQL server. This session introduces concepts and usage of the openark-kit. Read more.
Architecture and Technology
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.
Architecture and Technology
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.
Vadim Tkachenko (Percona Inc)
Average rating: ****.
(4.00, 1 rating)
This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy. Read more.
Drizzle, LAMP, Memcached
Location: Ballroom B
Patrick Galbraith (Blue Gecko)
Average rating: **...
(2.00, 3 ratings)
Perl has been around for a while now. Even with buzz around other interpreted languages, Perl is still prevalently used in many applications- anything from simple database utilities, database administrative tools or web applications, it is useful to know how to program with Perl along with a relational database. This session is refresher course for lovers and non-lovers of Perl alike. Read more.
Baron Schwartz (VividCortex)
Average rating: ****.
(4.14, 7 ratings)
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality. Read more.
Drizzle
Location: Ballroom H
Average rating: ***..
(3.00, 1 rating)
Now that you've decided to use Drizzle for everything, you're going to want to tune it to get the best out of your system. Some of the things you know from MySQL apply, some don't. Let's look at some real numbers and real graphs and see what Drizzle is doing. Read more.
Drizzle
Location: Ballroom D
Tags: drizzle, plugin
Average rating: ****.
(4.00, 3 ratings)
Drizzle has a rich plugin system, which means that Drizzle has a rather large set of available plugins which do things. Some of those plugins implement functionality that people have been asking for in the MySQL ecosystem for quite some time - such as LDAP or PAM based authentication, extremely flexible logging and direct use of Memcached. Come see how to actually do these things and more. Read more.
Drizzle
Location: Ballroom H
Tags: drizzle
Stewart Smith (Percona)
Average rating: ***..
(3.33, 3 ratings)
Drizzle has fixed many "gotcha" type things. Often we find ourselves saying "fixed in Drizzle". This is a whirlwind tour of what that is. Read more.
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