Personal schedule for Siby Nidhiry

Download or subscribe to Siby Nidhiry's schedule.

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.
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.
Zardosht Kasheff (Tokutek)
Average rating: ****.
(4.50, 4 ratings)
We present some simple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data. 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.
Ori Herrnstadt (FoundationDB)
Average rating: ****.
(4.00, 3 ratings)
Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting. Read more.
Products and Services
Location: Ballroom H
John Busch (Schooner Information Technology)
Average rating: **...
(2.25, 4 ratings)
We present innovative technology developed to achieve industry-leading availability coupled with industry-leading performance for MySQL/InnoDB. Downtime is reduced by over 90% with tightly integrated, fully synchronous replication. Highly-optimized thread, lock, DRAM, and flash algorithms maximize performance.We present the technology, demonstrate management simplicity, and show benchmark results. Read more.
Average rating: ****.
(4.14, 7 ratings)
When replication fails, it can be difficult to fix. This talk will show you how to diagnose the failure and, when possible, safely resume replication. Read more.
Peter Zaitsev (Percona Inc)
Average rating: **...
(2.86, 7 ratings)
It takes a lot to deliver consistent high performance for your MySQL powered system. In this presentation we'll look at defining Performance Goals, understanding Architecture Scalability and performing Capacity Planing. Read more.
Products and Services
Location: Ballroom H
Itamar Haber (Xeround)
mysql> EXPLAIN SELECT * FROM CLOUDSQLDB WHERE Availability=’always’ AND Scale=’auto’ AND COUNT (CloudProviders)>1; Come see a live demonstration of a highly-available and scalable cloud database – with self-healing, auto-scaling and pay-per-use – all with a click of a button. Read more.
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.
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.
Tags: mysql, cluster, ndb
Bernhard Ocklin (Oracle Svenska AB), Rob Young (Oracle/MySQL )
Average rating: ***..
(3.00, 1 rating)
This session will introduce you to new MySQL Cluster features, its performance in benchmarks, and shows how major mobile phone and web companies build highly available real time solutions based on MySQL Cluster. Sometimes even with SQL. Read more.
Harrison Fisk (Facebook), Domas Mituzas (Facebook)
Average rating: ***..
(3.80, 15 ratings)
Running MySQL at a scale of Facebook leads to many unique problems. We will discuss some of the performance problems seen in production systems and the tools and techniques involved in solutions. Read more.
Products and Services
Location: Ballroom G
Edward Archibald (Continuent)
Learn how to build scalable Database-as-a-Service with Tungsten, including: What is Tungsten & how it works, Configure Tungsten to create your own DBaaS, Implement fast, automatic database provisioning, Recover from failures through storage subsystem integration, Zero downtime maintenance & upgrades, Scale performance with SQL routing & load balancing, Replicate across sites. 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: 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.
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.
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.
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.
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: ***..
(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.
Ian Gulliver (Google), Eric Rollins (Google)
Average rating: ***..
(3.80, 5 ratings)
Google engineers have built a system that detects MySQL master failure, chooses a new master, promotes it and hooks up slaves with under a minute downtime. This is deployed in an environment where there's zero tolerance for transaction loss of any sort. The original designer and a sysadmin who worked on the deployment will talk about design, implementation and practical lessons learned. Read more.
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.
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.
Inaam Rana (Oracle), John Russell (Oracle Corporation)
Average rating: ***..
(3.50, 8 ratings)
InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works. Read more.
Replication and Scale-Out
Location: Ballroom F
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.67, 3 ratings)
Galera provides synchronous multi-master replication for MySQL/InnoDB. In a sense, it works like MySQL/Cluster but on top of InnoDB storage engine. Is this too good to be true? Read more.
Ivan Zoratti (SkySQL)
Average rating: ****.
(4.00, 1 rating)
MySQL Cluster (NDB) is one of the most interesting storage engines. Oracle promotes NDB as the perfect solution for high volume transactions in high availability. On the other hand, many famous users are reluctant in migrating applications to NDB. This session will help in understanding in practical terms when it makes sense to use NDB and when it is better to stay with or use InnoDB. Read more.
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.
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.
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.
Replication and Scale-Out
Location: Ballroom A
Daniel Peek (Facebook)
Average rating: ****.
(4.20, 5 ratings)
MySQL replication has been a critical part of scaling Facebook's storage infrastructure.  However, it brings with it the fear of divergent replicas.  This session discusses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.   Read more.
LAMP, NoSQL
Location: Ballroom F
Peter Zaitsev (Percona Inc), Richard Kelm (Sphinx Search)
Average rating: ****.
(4.00, 3 ratings)
Sphinx Search Engine is a well known tool for dealing with full text search problems on the large scale, but did you know you can use Sphinx for other tasks, which your traditional database may not be well suited for. This presentation will look into practical cases of using Sphinx beyond full text search and provide performance comparison to using MySQL for the same task. Read more.
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.33, 3 ratings)
Learn best practices in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices Read more.
Darpan Dinker (Schooner Information Technology, Inc.), Brian O’Krafka (Schooner Information Technology)
Most MySQL deployments use some form of replication. Whether the reason is availability, scalability, backup, disaster recovery or archiving, understanding the performance characterization and trade-offs is critical to design and planning. If you have always wondered when and why to choose async/semi-sync/sync MySQL replication, DRBD or other interoperable technologies, this session is for you. 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.
Migration, Replication and Scale-Out
Location: Ballroom F
Mark Konetchy (Facebook)
Average rating: ***..
(3.67, 3 ratings)
This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes 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