BEGIN:VCALENDAR X-WR-CALNAME:O'Reilly MySQL Conference & Expo 2011 VERSION:2.0 PRODID:Expectnation CALSCALE:GREGORIAN BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110418T192551 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17156 UID:http://mysqlconf.com/--s2011-04-11-09:00--17156 SUMMARY:Mastering MySQL, MariaDB and Drizzle Plugin Development DESCRIPTION:Presented by Sergei Golubchik (MariaDB), Andrew Hutchings (H ewlett-Packard). MySQL Plugins - first introduced in 5.1 - are server ex tensions that can be loaded into the running MySQL on the fly, without r estart. This tutorial will teach what tasks can be solved with plugins, what a plugin consists of, and how to write a plugin that helps with you r specific problem. Basic C/C++ and MySQL knowledge is expected, but no deep familiarity with either is required. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110415T143614 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17110 UID:http://mysqlconf.com/--s2011-04-14-10:50--17110 SUMMARY:MySQL to Drizzle, stress free migration DESCRIPTION:Presented by Andrew Hutchings (Hewlett-Packard). A guide to migrating your database and application from MySQL to Drizzle at every l ayer, from schemas to connections and application modifications. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110414T210458 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17648 UID:http://mysqlconf.com/--s2011-04-14-11:55--17648 SUMMARY:Using CouchDB for Emerging World Healthcare Solutions DESCRIPTION:Presented by Cory Zue (Dimagi). People talk about NoSQL in t he context of distributed cloud-based web applications, but what if your application needs to be deployed throughout rural Africa, with limited computer resources, intermittent power, and above all, extremely unrelia ble internet? This talk discusses the features of CouchDB that make it uniquely suited for developing world health applications. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110420T171347 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17524 UID:http://mysqlconf.com/--s2011-04-14-14:00--17524 SUMMARY:Error Detection and Correction with MySQL Replication DESCRIPTION:Presented by Daniel Peek (Facebook). MySQL replication has b een a critical part of scaling Facebook's storage infrastructure.  Howev er, it brings with it the fear of divergent replicas.  This session disc usses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.   END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110413T011203 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20240 UID:http://mysqlconf.com/--s2011-04-14-14:50--20240 SUMMARY:SkySQL Enterprise Monitor DESCRIPTION:Presented by Ivan Zoratti (SkySQL). The webyog monitor, how to use it, what it's good at etc. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110416T151451 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17154 UID:http://mysqlconf.com/--s2011-04-12-10:50--17154 SUMMARY:Where does MySQL Fit In (at Craigslist)? DESCRIPTION:Presented by Jeremy Zawodny (craigslist.org). This talk will discuss the ongoing evolution of data storage at Craigslist, starting f rom a homogeneous one-size fits all "MySQL everywhere" approach and movi ng toward a heterogeneous environment that considers our real data and p erformance needs and the plethora of tools available today (including Re dis, MongoDB, MySQL, and Sphinx). END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110419T125055 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17169 UID:http://mysqlconf.com/--s2011-04-12-11:55--17169 SUMMARY:MySQL High Availability at Yahoo DESCRIPTION:Presented by Jay Janssen (Percona, Inc.). In the midst of ma ny attempts to "solve" the RDBMS high availability problems, the vast ma jority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architec ture, it's advantages and disadvantages, as well what we see as needed f or future HA advances. It's old-school, it's crude, but somehow it solv es most HA problems. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110413T013220 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17475 UID:http://mysqlconf.com/--s2011-04-12-14:00--17475 SUMMARY:A New Approach For Dealing with Complex Database Schemas DESCRIPTION:Presented by Ori Herrnstadt (Akiban). Complex normalized sch emas can make database systems slow and inefficient. This presentation e xplores a storage layer that eliminates most joins in such systems by pr e-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. I t can also be accessed using standard SQL for efficient complex multi-ta ble reporting. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110418T193333 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17122 UID:http://mysqlconf.com/--s2011-04-12-15:05--17122 SUMMARY:Performance Best Practices for MySQL DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). It takes a lot to deliver consistent high performance for your MySQL powered system. In th is presentation we'll look at defining Performance Goals, understanding Architecture Scalability and performing Capacity Planing. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110412T233204 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17285 UID:http://mysqlconf.com/--s2011-04-12-16:25--17285 SUMMARY:Granular Archival and Nearline Storage Using MySQL, S3 and SQS DESCRIPTION:Presented by Walt Jones (SEOmoz). Moving rarely accessed dat a out of your main database can have a big impact on speed and cost. Thi s session covers techniques to analyze the granularity of your data and implement an archival strategy that allows you to recall archived data o n demand. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110413T143155 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17288 UID:http://mysqlconf.com/--s2011-04-12-17:15--17288 SUMMARY:Open Source reporting tools DESCRIPTION:Presented by David Stokes (Oracle). Need quick ad-hoc report s with sharp graphics from you MySQL instances? There are several open source reporting tools from Penatho, Actuate, Jaspersoft and others that can make a DBAs lies much easier. This session covers the more popular reporting tools and reommendations for for their use in your environmen t. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110415T143451 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17183 UID:http://mysqlconf.com/--s2011-04-13-10:50--17183 SUMMARY:Scaling MySQL in the Cloud - A Success Story DESCRIPTION:Presented by Dan Rogart (Zynga), mohan krishnan (Zynga). We will examine the challenges faced by Zynga in running a large scale MySQ L plant in EC2. Serving our social games to millions of players around t he globe has required significant investment in automation and performan ce 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110415T203947 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17656 UID:http://mysqlconf.com/--s2011-04-13-11:55--17656 SUMMARY:Lessons Learned: Scaling a Social Network DESCRIPTION:Presented by Michael Glaesemann (myYearbook.com). Founded by two high school students in 2005, myYearbook.com has grown to become on e 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 sup port the consistent growth and demand of a social network. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110414T223049 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17607 UID:http://mysqlconf.com/--s2011-04-13-14:00--17607 SUMMARY:MySQL at GitHub DESCRIPTION:Presented by Corey Donohoe (GitHub). GitHub's history with M ySQL and what we've built off of it. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110421T154842 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17191 UID:http://mysqlconf.com/--s2011-04-13-15:05--17191 SUMMARY:Building and Deploying Large Scale Real Time News System with My SQL and Distributed Cache DESCRIPTION:Presented by Tao Cheng (AOL). AOL deployed its large scale R eal Time News (RTN) system in 2007. This system receives news updates fr om over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabyt es of data. However, news are delivered to end users in close to real ti me fashion. This presentation shares how it is done and the lessons lear ned. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110414T025142 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17410 UID:http://mysqlconf.com/--s2011-04-13-16:25--17410 SUMMARY:Drizzle Replication Roadmap DESCRIPTION:Presented by David Shrewsbury (Rackspace). Drizzle has throw n out the MySQL replication system and has started from scratch in imple menting its own replication architecture. In this session, we'll take a look at the basics of the new architecture, what tools are available, an d discuss possible future functionality. An example setup will also be p resented. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110420T184220 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17499 UID:http://mysqlconf.com/--s2011-04-13-17:15--17499 SUMMARY:Be Rich and Fast: Membase Key-Value Stores for Interactivity, My SQL for Full Queryability DESCRIPTION:Presented by Matt Ingenthron (Couchbase, Inc.). With contemp orary 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 MyS QL 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T200000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110330T234934 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19307 UID:http://mysqlconf.com/--s2011-04-12-19:00--19307 SUMMARY:Severalnines ClusterControl for MySQL Cluster DESCRIPTION:CSince 2008 Johan Andersson has been publishing tools to hel p people test and deploy into production MySQL Cluster. Severalnines.com configurator, sandbox and cmon have been of help to thousands of MySQL Cluster users already. Come see what the new version, Severalnines Clust erControl has to offer. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T200000 DTSTART;TZID=US/Pacific:20110413T190000 DTSTAMP:20110408T201848 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20132 UID:http://mysqlconf.com/--s2011-04-13-19:00--20132 SUMMARY:Severalnines ClusterControl for MySQL Replication DESCRIPTION:Severalnines ClusterControl tools have already proven to bri ng ease of use to configuring and running MySQL Cluster. Now the same ex perience is available for MySQL Replication deployments: Master-master s etup and as many scale-out slaves as you want, it's all there with a few clicks. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110331T000026 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19308 UID:http://mysqlconf.com/--s2011-04-13-18:00--19308 SUMMARY:Xtrabackup Manager DESCRIPTION:Xtrabackup Manager is a new tool for scheduling your MySQL b ackups. It uses Xtrabackup from Percona as the backup tool - in the futu re we will support also other tools like mysqldump. This is a new projec t, rough around the edges and incomplete user interface, but it can alre ady take a backup. If you are interested in working on the code with us, even better! END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110413T224628 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17823 UID:http://mysqlconf.com/--s2011-04-11-09:00--17823 SUMMARY:DBA day DESCRIPTION:Presented by Max Mether (SkySQL Ab). Learn everything there is to know about being a MySQL DBA in 1 day. this full day tutorial will teach you all the most important topics of being a MySQL DBA. At the sa me time it will prepare you for the MySQL DBA certification. Topics incl uded in the tutorial are: Storage Engines, Backups, Server Architecture, Resource Usage, Optimisation, Security, Replication, Monitoring & Troub leshooting etc. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110418T192937 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17167 UID:http://mysqlconf.com/--s2011-04-14-10:50--17167 SUMMARY:Deploying MySQL & Drizzle in the Cloud with chef DESCRIPTION:Presented by Padraig O'Sullivan (Akiban Technologies Inc.). In this presentation, we will cover how to easily deploy MySQL and Drizz le databases on Amazon and the Rackspace cloud using chef. In particular , Drizzle is a database designed specifically for the cloud and we will discuss how its modular architecture benefits deployment. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110208T093520 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17788 UID:http://mysqlconf.com/--s2011-04-14-11:55--17788 SUMMARY:Mysql Data Warehousing – A Survival Guide DESCRIPTION:Presented by Marius Moscovici (Metric Insights Inc.), Steffa n Mejia (Linden Lab). This presentation provides architectural guidance, design patterns, and specific suggestions for deploying and administeri ng Data Warehouses using Mysql. It is based on lessons learned buildin g and operating a Multi-Terabyte Mysql 5 Data warehouse over a period o f 5 years. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110208T094625 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17528 UID:http://mysqlconf.com/--s2011-04-14-14:00--17528 SUMMARY:A code stub generator for MySQL and Drizzle plugins DESCRIPTION:Presented by Hartmut Holzgraefe (...???...). Writing a compl ete plugin requires quite a bit of infrastructure work to get all the fe ature registration and build system aspects right. A code generator can take care of such tasks, allowing you to focus on the actual functionali ty you want to add without having to figure out all plugin API details u p front. This can cut the time to create a simple plugin down from hours to minutes. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110415T143657 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17272 UID:http://mysqlconf.com/--s2011-04-14-14:50--17272 SUMMARY:Making MySQL Better for the Data Center DESCRIPTION:Presented by Mark Callaghan (Facebook), Ryan Mack (Facebook) , Vamsi Ponnekanti (Facebook). The Facebook database engineering team wo rks with the community and on its own to make MySQL better for data cent er deployments. This work is visible in the Facebook patch, bugs fixed i n official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110612T194705 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17364 UID:http://mysqlconf.com/--s2011-04-12-10:50--17364 SUMMARY:MySQL Replication Update DESCRIPTION:Presented by Lars Thalmann (Oracle), Alex Roedling (Oracle). The developers behind MySQL Replication describe the new features. Afte r a quick review of what MySQL 5.5 brings, focus turns to the features t hat are coming after MySQL 5.5. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110415T203432 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17391 UID:http://mysqlconf.com/--s2011-04-12-11:55--17391 SUMMARY:The Art of Sandboxing - Reducing Complex Systems to Manageable B oxes DESCRIPTION:Presented by Giuseppe Maxia (Continuent). Database technolog y is seldom simple. Unless you are dealing with an embedded, self contai ning database such as SQLite, chances are that your data management requ ires a complex system involving one or more database servers. Whether yo u need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database syst ems into obedience. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110415T184112 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17242 UID:http://mysqlconf.com/--s2011-04-12-14:00--17242 SUMMARY:Diagnosing MySQL Replication Failures DESCRIPTION:Presented by Devananda Van Der Veen (Percona), Justin Swanha rt (Percona). When replication fails, it can be difficult to fix. This t alk will show you how to diagnose the failure and, when possible, safely resume replication. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110419T193833 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17265 UID:http://mysqlconf.com/--s2011-04-12-15:05--17265 SUMMARY:Automated, Non-Stop MySQL Operations and Failover DESCRIPTION:Presented by Yoshinori Matsunobu (DeNA). In this session, I will talk about tough DBA tasks - how to automate failover under non-tri vial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sha rding). If you have spent too much time for these tasks, this session wi ll help your DBA life easier. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110419T125255 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17138 UID:http://mysqlconf.com/--s2011-04-12-16:25--17138 SUMMARY:Detecting Data Drift In a Live System DESCRIPTION:Presented by Mikey Dickerson (Google). Google engineers talk about the long fight against the specter of data drift. Starting from h istorical FUD about data drift, Google SREs will discuss design and impl ementation of a solution to detect data drift on any slave without downt ime, and lessons learned from deployment and running in a world with det ection. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110419T123121 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17117 UID:http://mysqlconf.com/--s2011-04-12-17:15--17117 SUMMARY:MySQL and SSD: Usage Patterns DESCRIPTION:Presented by Vadim Tkachenko (Percona Inc). Are you consider ing 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 END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110418T215436 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20211 UID:http://mysqlconf.com/--s2011-04-13-10:50--20211 SUMMARY:Gearman From A Worker's Perspective DESCRIPTION:Presented by Brian Aker (HP). Many people view topics like M ap/Reduce and queue systems as advanced concepts that require in-depth k nowledge and time consuming software setup. Gearman is changing all that by making this barrier to entry as low as possible with an open source, distributed job queuing system. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110414T235313 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17141 UID:http://mysqlconf.com/--s2011-04-13-11:55--17141 SUMMARY:Achieving PCI Compliance with MySQL DESCRIPTION:Presented by Fernando Ipar (Percona), Ryan Lowe (Percona). A chieving PCI compliance can be a difficult and expensive process. This s ession will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy th em. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110418T193421 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17098 UID:http://mysqlconf.com/--s2011-04-13-14:00--17098 SUMMARY:MySQL Best Practices for DBAs and Developers - Part 1 DESCRIPTION:Presented by Ronald Bradford (EffectiveMySQL). Learn the ri ght techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences be tween MySQL and other RDBMS products are essential to understand in orde r to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL securit y and schema optimizations. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110418T193435 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17616 UID:http://mysqlconf.com/--s2011-04-13-15:05--17616 SUMMARY:MySQL Best Practices for DBAs and Developers - Part 2 DESCRIPTION:Presented by Ronald Bradford (EffectiveMySQL). Too much for just one session, in Part 2 we continue with learning the right techniq ues to maximize your investment in MySQL by knowing the best practices f or DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110414T001952 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20239 UID:http://mysqlconf.com/--s2011-04-13-16:25--20239 SUMMARY:MySQL Cluster Architecture DESCRIPTION:Presented by Max Mether (SkySQL Ab). Describe cluster feater es, node types, internal processes etc. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110418T192824 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17252 UID:http://mysqlconf.com/--s2011-04-13-17:15--17252 SUMMARY:Perl programming with MySQL and Drizzle DESCRIPTION:Presented by Patrick Galbraith (Blue Gecko). Perl has been a round for a while now. Even with buzz around other interpreted languages , Perl is still prevalently used in many applications- anything from sim ple database utilities, database administrative tools or web application s, 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T200000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110314T204022 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18657 UID:http://mysqlconf.com/--s2011-04-12-19:00--18657 SUMMARY:PostgreSQL: Directions, Q&A DESCRIPTION:Many PostgreSQL developers and community members will be at the conference this year. Come to hear about the latest in 9.1 developme nt, talk directly to developers and users of PostgreSQL. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T200000 DTSTART;TZID=US/Pacific:20110413T190000 DTSTAMP:20110414T021159 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18358 UID:http://mysqlconf.com/--s2011-04-13-19:00--18358 SUMMARY:Get Relational Data Effectively with NotORM for PHP DESCRIPTION:NotORM for databases is like SimpleXML for XML. It is so fas t that it often performs better than native queries. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110411T015307 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20138 UID:http://mysqlconf.com/--s2011-04-13-18:00--20138 SUMMARY:Kick Some Flash with MySQL DESCRIPTION:Share, explore, and discover the performance potential of My SQL and flash memory! END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110412T050520 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17130 UID:http://mysqlconf.com/--s2011-04-11-09:00--17130 SUMMARY:Horizontal Scaling using PostgreSQL 9 DESCRIPTION:Presented by Josh Berkus (PostgreSQL Experts, Inc.). Want to really scale PostgreSQL using the new binary replication? Learn how to set up hot standby, streaming replication, failover, non-persistant dat abases and cloning to scale PostgreSQL 9 for reads. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110419T125532 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17349 UID:http://mysqlconf.com/--s2011-04-14-10:50--17349 SUMMARY:InnoDB: Status, Architecture, and Latest Enhancements DESCRIPTION:Presented by Inaam Rana (Oracle), John Russell (Oracle Corpo ration). InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enha ncements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB work s. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110415T143623 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17153 UID:http://mysqlconf.com/--s2011-04-14-11:55--17153 SUMMARY:Forecasting MySQL Performance and Scalability DESCRIPTION:Presented by Baron Schwartz (VividCortex Inc). This talk sho ws you how to gather the correct data for performance forecasting and ca pacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110303T061344 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17163 UID:http://mysqlconf.com/--s2011-04-14-14:00--17163 SUMMARY:Scaling MySQL in the Cloud DESCRIPTION:Presented by Moshe Shadmon (ScaleDB). ScaleDB is a pluggable storage engine for MySQL. It turns MySQL into an enterprise-class, high ly-available, clustered database that scales dynamically in a public and private cloud. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110208T100913 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17216 UID:http://mysqlconf.com/--s2011-04-14-14:50--17216 SUMMARY:Introducing kewpie - a feedback-based query generation and testi ng framework DESCRIPTION:Presented by Patrick Crews (HP Cloud Services). Kewpie is a random testing tool for database systems. Based on research by Microsof t's SQL Server team, it utilizes feedback from the system under test to help drive query generation. This design provides a greater degree of c ontrol and accuracy than purely random systems. This talk will discuss t he motivations behind the system as well as providing several applicatio ns for testing. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110413T162213 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/16850 UID:http://mysqlconf.com/--s2011-04-12-10:50--16850 SUMMARY:Leveraging Hadoop to Augment MySQL Deployments DESCRIPTION:Presented by Sarah Sproehnle (Cloudera, Inc.). Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reportin g and injestion of large amounts of raw or unstructured data. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110415T183121 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17236 UID:http://mysqlconf.com/--s2011-04-12-11:55--17236 SUMMARY:Understanding Indexing DESCRIPTION:Presented by Zardosht Kasheff (Tokutek). We present some sim ple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110419T125104 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17273 UID:http://mysqlconf.com/--s2011-04-12-14:00--17273 SUMMARY:Dealing with Schema Changes on Large Data Volumes DESCRIPTION:Presented by Danil Zburivsky (The Pythian Group). Production schema changes are painful but unavoidable. This session will tell you how to minimize (or totally eliminate) downtime during schema changes w ith master-master setup or by using "shadow" tables. Session will focus on pros and cons of each approach and describe most common use cases. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T191908 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17584 UID:http://mysqlconf.com/--s2011-04-12-15:05--17584 SUMMARY:Advanced Replication Monitoring DESCRIPTION:Presented by Gerardo Narvaja (OpenMarket Inc.). Traditionall y replication has been monitored using the information in SHOW SLAVE STA TUS, however it doesn't always represent the full picture. This presenta tion will outline how combining different methodologies it is possible t o obtain a more accurate picture about replication health. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110419T123115 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17160 UID:http://mysqlconf.com/--s2011-04-12-16:25--17160 SUMMARY:MySQL and Linux Tuning - Better Together DESCRIPTION:Presented by Steve Francis (LogicMonitor). This talk will co ver some of the less common linux tuning options, and how they can benef it MySQL performance, and benchmark results showing real impacts (or lac k thereof) of tuning. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110416T151434 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17372 UID:http://mysqlconf.com/--s2011-04-12-17:15--17372 SUMMARY:Securich DESCRIPTION:Presented by Darren Cassar (MySQLPreacher). Security is ofte n considered a waste of time given its tedious, painful and underestimat ed. This is where securich comes to the rescue helping you control users , privileges and enforce good passwords. User cloning, renaming, passwor d complexity and much much more. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110419T123156 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17510 UID:http://mysqlconf.com/--s2011-04-13-10:50--17510 SUMMARY:MySQL State of the Art at Facebook DESCRIPTION:Presented by Harrison Fisk (Facebook), Domas Mituzas (Facebo ok). Running MySQL at a scale of Facebook leads to many unique problems. We will discuss some of the performance problems seen in production sy stems and the tools and techniques involved in solutions. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110419T123204 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17129 UID:http://mysqlconf.com/--s2011-04-13-11:55--17129 SUMMARY:The Aspersa System Administrator's Toolkit DESCRIPTION:Presented by Baron Schwartz (VividCortex Inc). This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatk it tools. It includes tools such as an I/O profiler, a bottleneck analy sis tool, and tools to quickly summarize a system's configuration and st atus. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110415T143524 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17155 UID:http://mysqlconf.com/--s2011-04-13-14:00--17155 SUMMARY:openark-kit: MySQL utilities for everyday use DESCRIPTION:Presented by Shlomi Noach (openark.org). openark-kit is a to ol set of scripts which fills in some gaps in daily MySQL maintenance wo rk. Some scripts make for automation of routine work; others introduce n ew functionality to the MySQL server. This session introduces concepts a nd usage of the openark-kit. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110414T223054 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17190 UID:http://mysqlconf.com/--s2011-04-13-15:05--17190 SUMMARY:Performance 101 for Small Web Apps DESCRIPTION:Presented by Jens Bollmann (SkySQL AB). Small web apps runni ng on shared hosting or single/dual server environments can take advanta ge of many optimizations without requiring additional hardware or drasti c application redesign. This session is aimed at developers and covers t he "low hanging fruit" type optimizations that just about everyone has t o learn the hard way!  END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110414T231105 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17640 UID:http://mysqlconf.com/--s2011-04-13-16:25--17640 SUMMARY:Ubuntu and Drizzle -- Run Drizzle on your Narwhal DESCRIPTION:Presented by Clint Byrum (Canonical). Ubuntu has always been focused on leadership as a development platform for Free Software. Driz zle has always been focused on being flexible and integration friendly. The Ubuntu Server Team has teamed up with the Drizzle Development team t o get Drizzle working on Ubuntu, and show developers how easy it is to p ort their apps to use Drizzle. As of Ubuntu 11.04, Drizzle will be inclu ded in Ubuntu. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110414T175121 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17157 UID:http://mysqlconf.com/--s2011-04-13-17:15--17157 SUMMARY:Replace phpMyAdmin with Something Better DESCRIPTION:Presented by Jakub Vrana (Self-employed). phpMyAdmin is a we ll-known PHP application for managing MySQL database. What's wrong with it? It is big, slow and it misses support for many advanced features lik e stored procedures or triggers. Its free alternative Adminer provides u ser-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T200000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110321T202909 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18569 UID:http://mysqlconf.com/--s2011-04-12-19:00--18569 SUMMARY:The Checkpoint Blues DESCRIPTION:Transactional databases almost always use checkpointing, and checkpointing is really, really hard to do well. From Postgres to Inno DB to PBXT, the dreaded "checkpoint spike" has caused or continues to ca use server stalls. Come learn how different databases do checkpoints an d how to tune yours properly. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110331T033045 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20131 UID:http://mysqlconf.com/--s2011-04-13-18:00--20131 SUMMARY:Backup and Recovery of MySQL DESCRIPTION:Discussion of MySQL backup and recovery methods and practice s in various organizations. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110529T141308 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17111 UID:http://mysqlconf.com/--s2011-04-11-09:00--17111 SUMMARY:Linux and H/W optimizations for MySQL DESCRIPTION:Presented by Yoshinori Matsunobu (DeNA). Choosing right Har dware components, configuring them properly, and optimizing Linux settin gs are very important for MySQL and other database server deployments. B ut they are frequently overlooked. Learning best practices will certain ly improve performance and stability. Do you want to learn these best pr actices? This three-hour tutorial is for you. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110422T214513 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17142 UID:http://mysqlconf.com/--s2011-04-11-13:30--17142 SUMMARY:Diagnosing and Fixing MySQL Performance Problems DESCRIPTION:Presented by Justin Swanhart (Percona), Ryan Lowe (Percona), Baron Schwartz (VividCortex Inc). This tutorial focuses on the diagnost ic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. T he emphasis is on practical usage under pressure, and less on performanc e theory. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110208T102308 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17189 UID:http://mysqlconf.com/--s2011-04-14-10:50--17189 SUMMARY:OQGRAPH: Dealing with Graphs and Hierarchies in Plain SQL DESCRIPTION:Presented by Antony Curtis (Blizzard Entertainment). Antony shows the OQGRAPH engine in MariaDB 5.2, allowing you to deal with graph s (networks) for social networking, hierarchies and other complex struct ures, all in plain clean SQL. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110414T194934 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17283 UID:http://mysqlconf.com/--s2011-04-14-11:55--17283 SUMMARY:InnoDB vs MySQL Cluster: Which Storage Engine Is Right For You? DESCRIPTION:Presented by Ivan Zoratti (SkySQL). MySQL Cluster (NDB) is o ne of the most interesting storage engines. Oracle promotes NDB as the p erfect solution for high volume transactions in high availability. On th e 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 Inno DB. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110414T215315 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17493 UID:http://mysqlconf.com/--s2011-04-14-14:00--17493 SUMMARY:Finally! How Drizzle Does the Things You've Always Wanted to Do DESCRIPTION:Presented by Monty Taylor (HP). Drizzle has a rich plugin sy stem, which means that Drizzle has a rather large set of available plugi ns which do things. Some of those plugins implement functionality that p eople 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 m ore. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110421T154738 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17146 UID:http://mysqlconf.com/--s2011-04-14-14:50--17146 SUMMARY:Summary Tables, Aggregate Tables and Materialized Views Using Fl exviews DESCRIPTION:Presented by Justin Swanhart (Percona), Ryan Lowe (Percona). This talk describes using summary tables to improve application perform ance. It focuses on Flexviews, an open source toolkit based on MySQL st ored procedures. Flexviews maintains summary tables and supports joins a nd aggregation. I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provid ed for both OLTP and OLAP workloads. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110422T215841 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17472 UID:http://mysqlconf.com/--s2011-04-12-10:50--17472 SUMMARY:Real-world Experiences Managing Large MySQL Fleet DESCRIPTION:Presented by John Smiley (Amazon.com). Amazon engineers shar e experiences managing a large fleet of MySQL databases. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110412T204729 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17133 UID:http://mysqlconf.com/--s2011-04-12-11:55--17133 SUMMARY:Building Data Warehouses with PostgreSQL DESCRIPTION:Presented by Josh Berkus (PostgreSQL Experts, Inc.). Has you r database grown to hundreds of gigabytes in size, with no limit in sigh t? Are you considering moving to an expensive proprietary database syste m do deal with your huge database? PostgreSQL is an excellent database f or small to medium sized data warehouses in the 0.5 to 5 terabyte range. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110415T184012 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17492 UID:http://mysqlconf.com/--s2011-04-12-14:00--17492 SUMMARY:HailDB: A NoSQL API Direct to InnoDB DESCRIPTION:Presented by Stewart Smith (Percona). HailDB is a project th at maintains InnoDB as a shared library (forked from embedded_innodb). I t 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T192215 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17115 UID:http://mysqlconf.com/--s2011-04-12-15:05--17115 SUMMARY:Percona Server: Secret Features DESCRIPTION:Presented by Vadim Tkachenko (Percona Inc). Percona Server i s most known for its performance and slow-log diagnostics, but it has ma ny other useful features. In this talk I will describe them. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110415T055057 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17139 UID:http://mysqlconf.com/--s2011-04-12-16:25--17139 SUMMARY:Securing MySQL with a Focus on SSL DESCRIPTION:Presented by Chris Conlon (yaSSL). 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 sometim es 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110414T213832 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17134 UID:http://mysqlconf.com/--s2011-04-12-17:15--17134 SUMMARY:MQL-to-SQL: a JSON-based Puery Language for RDBMS Access from A JAX Applications DESCRIPTION:Presented by Roland Bouman (XCDSQL Solutions / Strukton Rail ). MQL-to-SQL is open source software that lets you query a RDBMS over H TTP 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 q uery language, instead of SQL. This talk explains what MQL is, how it co mpares to SQL, why MQL is great for AJAX apps, and how MQL-to-SQL allows you to query RDBMSes like MySQL & Postgres END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110415T120022 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17315 UID:http://mysqlconf.com/--s2011-04-13-10:50--17315 SUMMARY:Update on the PBXT Storage Engine DESCRIPTION:Presented by Paul McCullagh (PrimeBase Technologies GmbH). L earn about the latest developments in and around the PBXT Storage Engine . Emphasis will be placed on technical aspects, discussing how things wo rk, and giving practical examples. I will also present the latest perfor mance results for PBXT which reveal a particular sweet spot when running a new benchmark called the “Provider Benchmark”. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110413T192304 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17466 UID:http://mysqlconf.com/--s2011-04-13-11:55--17466 SUMMARY:Mixed MySQL/PostgreSQL Environments DESCRIPTION:Presented by Jeff Davis (Aster Data). Mixed SQL system envir onments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each o ther nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110414T002845 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17383 UID:http://mysqlconf.com/--s2011-04-13-14:00--17383 SUMMARY:Openstreetmap -> (PostGIS|MySQL|SpatiaLite) -> OpenLayers: From Map to Web DESCRIPTION:Presented by Hartmut Holzgraefe (...???...). OpenStreetMap r aw data for any non-trivial area comes as a massive amount of XML data. Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options t hough, especially when it comes to producing on demand map data for web applications with acceptable performance. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110208T093842 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17647 UID:http://mysqlconf.com/--s2011-04-13-15:05--17647 SUMMARY:War Stories and Solutions: Operational Fun with PostgreSQL and P ostGIS in the Cloud DESCRIPTION:Presented by Andy Parsons (Obikosh.com). As CTO of Outside.i n, and in my new stealth company, I've seen my share of challenging scen arios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Oth ers can probably learn from my battle scars! END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110418T193446 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17137 UID:http://mysqlconf.com/--s2011-04-13-16:25--17137 SUMMARY:Automatic Failover: Design and Reality DESCRIPTION:Presented by Ian Gulliver (Google), Eric Rollins (Google). G oogle engineers have built a system that detects MySQL master failure, c hooses a new master, promotes it and hooks up slaves with under a minute downtime. This is deployed in an environment where there's zero toleran ce for transaction loss of any sort. The original designer and a sysadmi n who worked on the deployment will talk about design, implementation an d practical lessons learned. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110419T130100 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17296 UID:http://mysqlconf.com/--s2011-04-13-17:15--17296 SUMMARY:Bottom-up Database Benchmarking DESCRIPTION:Presented by Greg Smith (2ndQuadrant US). While databases ar e increasingly being distributed across multiple nodes, the performance of every node still matters--especially if you're considering virtualize d or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performan ce, and using sysbench to benchmark both MySQL and PostgreSQL are all to pics covered here. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T200000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110321T174953 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19721 UID:http://mysqlconf.com/--s2011-04-12-19:00--19721 SUMMARY:Sphinx Search: 2.0 DESCRIPTION:Sphinx Search 2.0: this BOF will speak to the new features i n the forthcoming 2.0 release of Sphinx along with an overview of our Ro admap. Also we would like to hear from the community and see where you w ould like us to take Sphinx in the future. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110413T192342 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20140 UID:http://mysqlconf.com/--s2011-04-13-18:00--20140 SUMMARY:4 KEYS to a Successful Meetup DESCRIPTION:Mike Tougeron and Erin O'Neill co-wrangle the San Francisco MySQL Meetup taking it from an average of 10 attendees to 65. They'll la y out the 4 main keys to making their meetup a success. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110418T162235 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17381 UID:http://mysqlconf.com/--s2011-04-11-09:00--17381 SUMMARY:MySQL Replication Advanced Techniques DESCRIPTION:Presented by Giuseppe Maxia (Continuent). MySQL replication is the backbone of web scalability principles. This tutorial tells you h ow 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 bo osting tricks, and emerging technologies that you can adopt in house and in the cloud. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110414T184334 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17568 UID:http://mysqlconf.com/--s2011-04-14-10:50--17568 SUMMARY:MySQL replication - all data everywhere, is it a good idea? DESCRIPTION:Presented by Sarah Novotny (Meteor Entertainment). MySQL's replication system has been a core feature often touted for scaling (sor t of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicatin g to one another) as a reference for the many uses and misuses of replic ation. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110418T193513 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17340 UID:http://mysqlconf.com/--s2011-04-14-11:55--17340 SUMMARY:Metadata locking and deadlock detection in MySQL 5.5 DESCRIPTION:Presented by Konstantin Osipov (MySQL). MySQL 5.5 features a new transactional lock manager, available to all storage engines. The n ew subsystem allowed to solve a number of old MySQL architecture problem s, such as lack of transactional awareness of data definition language, as well as opened the door for a number of new performance and scalabili ty improvements. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110415T185336 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17511 UID:http://mysqlconf.com/--s2011-04-14-14:00--17511 SUMMARY:Engineering MySQL Subroutines for Integrity DESCRIPTION:Presented by Michael McLaughlin (BYU - Idaho). Presents an i n-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 tra nsaction control in stored functions and procedures. Provides examples o n how to encapsulate key logic from web developers. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110415T055501 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/16829 UID:http://mysqlconf.com/--s2011-04-14-14:50--16829 SUMMARY:High-Performance Storage Services Using HailDB and Java DESCRIPTION:Presented by Sunny Gleason (Ning). This presentation introdu ces the St8 server, an open-source, REST-enabled storage service built u sing Jersey, Jetty, Guice, and most importantly, HailDB (formerly Embedd ed InnoDB). We describe interfacing HailDB with Java using JNA, and revi ew benchmarks showing just how fast the service can be (including SSD as well as single-disk and RAID0 benchmarks). END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110418T192654 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17119 UID:http://mysqlconf.com/--s2011-04-12-10:50--17119 SUMMARY:Using MySQL 5.5 Performance Schema DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110416T151521 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17429 UID:http://mysqlconf.com/--s2011-04-12-11:55--17429 SUMMARY:The Secret Sauce of Sharding DESCRIPTION:Presented by Ryan Thiessen (Facebook). Getting sharding righ t is crucial for achieving high scale with MySQL on commodity hardware l ike we do at Facebook. We will overview sharding best practices, and sh ow some examples of both successful and unsuccessful methods at sharding MySQL. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110414T213837 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17529 UID:http://mysqlconf.com/--s2011-04-12-14:00--17529 SUMMARY:An Introduction to PostGIS - the PostgreSQL spatial extension DESCRIPTION:Presented by Ragi Burhum (Burhum LLC - GIS Consulting). Post GIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored i n the database. It includes support for spatial indexes, and functions f or analysis and processing of GIS objects. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T203003 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17544 UID:http://mysqlconf.com/--s2011-04-12-15:05--17544 SUMMARY:Securing PostgreSQL From External Attack DESCRIPTION:Presented by Bruce Momjian (EnterpriseDB). This talk explore s the ways attackers with no authorized database access can steal Postgr es passwords, see database queries and results, and even intercept datab ase sessions and return false data. Postgres supports features to elimin ate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110413T203013 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17652 UID:http://mysqlconf.com/--s2011-04-12-16:25--17652 SUMMARY:Introduction to HBase DESCRIPTION:Presented by Tom Hanlon (Cloudera). 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 f ramework along with some usage examples. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110413T203020 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17342 UID:http://mysqlconf.com/--s2011-04-12-17:15--17342 SUMMARY:Introduction to PostgreSQL Configuration DESCRIPTION:Presented by Robert Haas (EnterpriseDB). PostgreSQL is highl y customizable, but which settings are most important and what values ar e most appropriate for a typical installation? This talk will explain t he basics of how to configure PostgreSQL for reliability and good perfor mance. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110415T203927 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17280 UID:http://mysqlconf.com/--s2011-04-13-10:50--17280 SUMMARY:Data Warehousing the MySQL Way: What's Hot and How It Works DESCRIPTION:Presented by Ivan Zoratti (SkySQL). MySQL ubiquity is expand ing from the online world to many other areas. Data Warehousing is one o f the hottest and fast growing sectors for MySQL, due to its reduced TCO and ease of use. In this session we will present what's new in the DW m arket around MySQL and how MySQL Server can be used to achieve success i n Data Warehousing, Business Intelligence, OLAP and Reporting Projects. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110413T202757 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17195 UID:http://mysqlconf.com/--s2011-04-13-11:55--17195 SUMMARY:Maintaining Terabytes: 10 Things to Watch Out For When PostgresS QL Bets Big DESCRIPTION:Presented by Selena Deckelmann (PostgreSQL). Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage t hese systems as they grow, and find out what new features in 9.0 have ma de life easier for administrators and application developers working wit h big data. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110419T123206 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17259 UID:http://mysqlconf.com/--s2011-04-13-14:00--17259 SUMMARY:Preparing for the Big Oops: How to Build Disaster Recovery Site s for MySQL DESCRIPTION:Presented by Robert Hodges (Continuent.com). Site failures c an blow your business out of the water unless you have a disaster recove ry site already setup, tested, and ready to go. This talk presents a co okbook approach for setting up and managing MySQL DR. Standard architec tures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110415T204156 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17309 UID:http://mysqlconf.com/--s2011-04-13-15:05--17309 SUMMARY:Designing Scalable Data Warehouse With MySQL DESCRIPTION:Presented by Venu Anuganti (Venu Anuganti Blog). This is a D BA 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 END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110416T151830 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17527 UID:http://mysqlconf.com/--s2011-04-13-16:25--17527 SUMMARY:Partitioning Saves Load Data DESCRIPTION:Presented by Kevin Knapp (Facebook). 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 min utes. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110416T151813 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17170 UID:http://mysqlconf.com/--s2011-04-13-17:15--17170 SUMMARY:No Silver Bullet - The Slightly Less Painful Way to Sharding DESCRIPTION:Presented by Gwen Shapira (Pythian). Sharding is a pain. Any one who says differently is trying to sell you something. Gwen Shapira w ill share stories from her 13 years of sharding experience: Learn how y ou can have less-painful sharded architecture using your favorite relati onal database. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T200000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110413T045644 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20094 UID:http://mysqlconf.com/--s2011-04-12-19:00--20094 SUMMARY:Xtrabackup - Open Source Hot Backup for MySQL, MariaDB, Drizzle DESCRIPTION:Xtrabackup is an Open Source Hot Backup program for Innodb a nd XtraDB storage engine which works with MySQL, MariaDB, Drizzle and Pe rcona Server. This session is to share your experiences using this proj ect as well as discuss what features you would like to see in the future versions. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110410T114857 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20163 UID:http://mysqlconf.com/--s2011-04-13-18:00--20163 SUMMARY:Replication Enhancements in MySQL 5.6.2 Development Milestone Re lease DESCRIPTION:Join Lars Thalmann, Development Director of MySQL Replicatio n and Mat Keep, MySQL product manager for a discussion of the replicatio n enhancements delivered as part of the MySQL 5.6.2 Development Mileston e Release This will be an interactive session with the opportunity to di scuss your own replication requirements, providing feedback and input di rectly to the engineering team END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110412T062409 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17957 UID:http://mysqlconf.com/--s2011-04-11-09:00--17957 SUMMARY:The Memcached Tutorial DESCRIPTION:Presented by Brian Aker (HP), Alan Kasindorf (Six Apart). Ba ck by popular demand we have the Memcached tutorial. Come learn about wh at is new and exciting in the world of Memcached. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110417T044148 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/16813 UID:http://mysqlconf.com/--s2011-04-11-13:30--16813 SUMMARY:Testing LAMP Applications DESCRIPTION:Presented by Sebastian Bergmann (thePHP.cc). LAMP applicatio ns are used more and more to perform enterprise-critical tasks. Given by the creator of PHPUnit, this tutorial shows the audience how to efficie ntly test LAMP applications with PHPUnit and its DbUnit extension. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110419T123308 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17386 UID:http://mysqlconf.com/--s2011-04-14-10:50--17386 SUMMARY:Galera Replication DESCRIPTION:Presented by Seppo Jaakola (Codership), Alexey Yurchenko (Co dership). Galera provides synchronous multi-master replication for MySQL /InnoDB. In a sense, it works like MySQL/Cluster but on top of InnoDB st orage engine. Is this too good to be true? END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110419T123328 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17373 UID:http://mysqlconf.com/--s2011-04-14-11:55--17373 SUMMARY:A State of Multi-Master Replication DESCRIPTION:Presented by Seppo Jaakola (Codership), Alexey Yurchenko (Co dership). Aside from traditional master-slave setup used mostly for HA a nd 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110415T055446 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17638 UID:http://mysqlconf.com/--s2011-04-14-14:00--17638 SUMMARY:Using Sphinx Beyond Full Text Search DESCRIPTION:Presented by Peter Zaitsev (Percona Inc), Adam Rice (Sphinx Search). 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 S phinx for other tasks, which your traditional database may not be well s uited for. This presentation will look into practical cases of using Sp hinx beyond full text search and provide performance comparison to using MySQL for the same task. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110416T152017 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17360 UID:http://mysqlconf.com/--s2011-04-14-14:50--17360 SUMMARY:Capacity Planning for High Volume Mysql Installations DESCRIPTION:Presented by Mark Konetchy (Facebook). This talk will cover forecasting and planning future growth for high volume mysql instances o ccupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimization s such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110415T143342 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17178 UID:http://mysqlconf.com/--s2011-04-12-10:50--17178 SUMMARY:Large datasets in MySQL on Amazon EC2 DESCRIPTION:Presented by Anders Karlsson (Recorded Future). Does it real ly work well to have large amount of data on Amazon EC2? Yes it does, bu t it does require some careful thinking and testing. EC2 is not like you r standard Linux box when in terms of cabability of sustaining a high lo ad and large amounts of data. But it can sure be done, but in a differe nt way. This talk is about what Recorded Future has experienced when wor king with EC2. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110415T143355 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17151 UID:http://mysqlconf.com/--s2011-04-12-11:55--17151 SUMMARY:A Beginner's Guide to Drizzle DESCRIPTION:Presented by Andrew Hutchings (Hewlett-Packard). Drizzle was originally forked from MySQL in 2008 and has since gone through many ch anges. 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110208T094611 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17814 UID:http://mysqlconf.com/--s2011-04-12-14:00--17814 SUMMARY:A Beginner's Guide to MariaDB DESCRIPTION:Presented by Colin Charles (Monty Program Ab). MariaDB - Com munity Developed. Feature Enhanced. Backward Compatible. A branch of the popular MySQL database, the project began in 2009 around a storage engi ne, but quickly evolved to being another database project, with two majo r releases in 2010. This session will introduce the project, and will he lp any DBA or developer get to grips with MariaDB. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110415T005122 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17672 UID:http://mysqlconf.com/--s2011-04-12-15:05--17672 SUMMARY:Installing Eucalpytus DESCRIPTION:Presented by Mark Atwood (HP Cloud Services). Eucalpytus is a GPL open-source private cloud computing infrastructure platform that i s compatible with Amazon Web Services. It has an undeserved reputation as being hard to provision, install, and operate. We hope to help dispe l this reputation by walking through and talking through installation an d operation of a small Eucalyptus cloud. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110413T193034 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17306 UID:http://mysqlconf.com/--s2011-04-12-16:25--17306 SUMMARY:Introduction to OpenStack DESCRIPTION:Presented by Eric Day (Rackspace Cloud). The OpenStack proje ct was launched last summer by Rackspace, NASA, and a number of other cl oud technology leaders in an effort to build a fully-open cloud computin g platform. It is a collection of scalable, secure, standards-based proj ects currently consisting of OpenStack Compute and OpenStack Object Stor age. This session will introduce the projects, principles behind it, and how to get started. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110415T055110 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17186 UID:http://mysqlconf.com/--s2011-04-12-17:15--17186 SUMMARY:Building Your First Web Application with MongoDB DESCRIPTION:Presented by Roger Bodamer (10gen). MongoDB -- from "humongo us" -- is an open source, non-relational, document-oriented database. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110413T185023 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17557 UID:http://mysqlconf.com/--s2011-04-13-10:50--17557 SUMMARY:MySQL Cluster - Real Time Performance for the Web with 5x9 Avail ability and Sometimes SQL DESCRIPTION:Presented by Bernhard Ocklin (Oracle Svenska AB), Rob Young (Oracle/MySQL ). This session will introduce you to new MySQL Cluster fe atures, its performance in benchmarks, and shows how major mobile phone and web companies build highly available real time solutions based on My SQL Cluster. Sometimes even with SQL. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110416T151621 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17465 UID:http://mysqlconf.com/--s2011-04-13-11:55--17465 SUMMARY:MySQL and MongoDB joined at the hip DESCRIPTION:Presented by Eliot Horowitz (10gen). 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 differen t things, so its important to understand when to use one or the other, a nd how to make them work well together. Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110418T022720 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17618 UID:http://mysqlconf.com/--s2011-04-13-14:00--17618 SUMMARY:CouchDB Simplicity DESCRIPTION:Presented by J Chris Anderson (Couchbase). Apache CouchDB im plements a reliable storage engine, webserver, and HTTP application serv er 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110415T143541 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17384 UID:http://mysqlconf.com/--s2011-04-13-15:05--17384 SUMMARY:Gizzard: A Pragmatic Distributed Storage Framework DESCRIPTION:Presented by Matt Freels (Twitter). At Twitter, we have gon e through many iterations of storage systems as we have coped with treme ndous growth. We have been able to solve many general distributed storag e 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110419T123221 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17289 UID:http://mysqlconf.com/--s2011-04-13-16:25--17289 SUMMARY:NoSQL with MySQL DESCRIPTION:Presented by Yekesa Kosuru (Nokia), Peter Zaitsev (Percona I nc). The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discus sions that focus on availability and scalability highlight ACID issues b ut not really SQL. The key-value systems can be built many ways and rel ational databases as a back end is a serious contender. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110512T212542 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17226 UID:http://mysqlconf.com/--s2011-04-13-17:15--17226 SUMMARY:Using MySQL As NoSQL - Introduction to HandlerSocket Plugin DESCRIPTION:Presented by Yoshinori Matsunobu (DeNA), Kazuho Oku (DeNA). Most of high scale web applications use memcached + MySQL or NoSQL. It i s said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently deve loped HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our productio n. We'd like to share our experiences. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110413T175334 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17636 UID:http://mysqlconf.com/--s2011-04-11-09:00--17636 SUMMARY:Scaling Applications with Caching, Sharding and Replication DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). This is updated an d revised version of tutorial done at MySQL Conference 2010 END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110419T122840 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17637 UID:http://mysqlconf.com/--s2011-04-11-13:30--17637 SUMMARY:Innodb and XtraDB Architecture and Performance Optimization DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). This talk is about Innodb and XtraDB architecture with focus on architecture aspects impor tant for performance optimization. We will also look into tuning Innodb settings as well as designing database schema and application to take a dvantage of architecture. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110414T231345 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20210 UID:http://mysqlconf.com/--s2011-04-14-10:50--20210 SUMMARY:BLOB Data And Thinking Out Side The Box DESCRIPTION:Presented by Barry Leslie (PrimeBase Technologies), Volker O boda (PrimeBase Technologies GmbH). MySQL and Drizzle were never designe d to handle BLOBs efficiently, storing BLOBs in the database results in huge memory requirements and bloated backups and replication logs. The P rimeBase BLOB management system (PBMS) is a daemon that is loaded by the database server and provides an efficient way of handling BLOBs that do esn’t have these problems. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110415T204711 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17282 UID:http://mysqlconf.com/--s2011-04-14-11:55--17282 SUMMARY:Narada: using Gearman, Sphinx, Memcached, Drizzle and PHP to bui ld a search application DESCRIPTION:Presented by Patrick Galbraith (Blue Gecko). The Narada Sear ch Application is a project that was an idea that was inspired while wri ting a book on how to take advantage of Sphinx, Gearman and MySQL that i ntroduces a whole new way of thinking about web applications. Instead of a single monolithic web application, functionality is broken out into s everal Gearman workers to make for a much more scalable and dynamic appl ication. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110411T172809 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17317 UID:http://mysqlconf.com/--s2011-04-14-14:00--17317 SUMMARY:Fulltext Searching with a Groonga Storage Engine DESCRIPTION:Presented by Tetsuro Ikeda (Sumisho Computer Sytems Corporat ion), Kentoku SHIBA (WildGrowth), Daijiro MORI (brazil), Tasuku SUENAGA (Brazil, Inc.). In this session, We introduce groonga Storage engine whi ch enables for MySQL to handle fulltext search lightly. groonga is a lib rary which have storages and indexes for fast fulltext searching. The ba ckend of groonga Storage Engine is groonga library. With groonga Storage Engine, you can use datas in groonga as a usual MySQL tables. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110418T193550 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17121 UID:http://mysqlconf.com/--s2011-04-14-14:50--17121 SUMMARY:Upgrading MySQL: Best Practices DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). Learn best practic es in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110418T023443 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19899 UID:http://mysqlconf.com/--s2011-04-12-11:55--19899 SUMMARY:Why Are The New Optimizer Features Important and How Can I Benef it From Them? DESCRIPTION:Presented by Sergey Petrunya (Monty Program Ab), Igor Babaev (Monty Program). MariaDB has a lot of improvements to the core optimise r that powers both MySQL & MariaDB. These optimiser features all have fl ags which you can enable (they are disabled by default). Igor and Sergey both work on all these optimiser features on a daily basis, and will be able to go deep in-depth to explain them and why they are beneficial to end-users in general. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110412T213249 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19740 UID:http://mysqlconf.com/--s2011-04-12-14:00--19740 SUMMARY:A Tour of PostgreSQL for Developers DESCRIPTION:Presented by Robin Schumacher (EnterpriseDB), Bruce Momjian (EnterpriseDB). PostgreSQL has much to offer today’s developers who has been charged with creating applications for Web, embedded, data warehous ing, OLTP, geo-spatial, and other environments. Developers will find man y flexible options at their disposal with PostgreSQL no matter what lang uage or IDE they choose to use. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110412T234657 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20223 UID:http://mysqlconf.com/--s2011-04-12-15:05--20223 SUMMARY:Dropping ACID: Eating Data In A Web 2.0 World DESCRIPTION:Presented by Stewart Smith (Percona). Those who cannot remem ber the past are condemned to repeat it. This is part survey, part criti que of the various Atomicity, Consistency, Isolation and Durability mode ls available from various modern databases and data stores used in moder n Web and Cloud environments. We'll not just look at the single machine solution but how these systems work in a distributed environment. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110316T200636 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19742 UID:http://mysqlconf.com/--s2011-04-13-11:55--19742 SUMMARY:Build your own PaaS for MySQL with Tungsten Enterprise DESCRIPTION:Presented by Edward Archibald (Continuent). Learn how to bui ld scalable Database-as-a-Service with Tungsten, including: What is Tung sten & how it works, Configure Tungsten to create your own DBaaS, Implem ent fast, automatic database provisioning, Recover from failures through storage subsystem integration, Zero downtime maintenance & upgrades, Sc ale performance with SQL routing & load balancing, Replicate across site s. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110228T171255 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17747 UID:http://mysqlconf.com/--s2011-04-13-14:00--17747 SUMMARY:Running Your Database In The Cloud DESCRIPTION:Presented by Eran Levin (Xeround). If you thought running a database in the cloud was easy, think again. Databases in a cloud envir onment are inherently different from traditional installations in a data center or even in your trusted hosted environment. Today I'll explain th e four key considerations we believe every system architect should take into account when designing their database for the cloud. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110418T114655 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17829 UID:http://mysqlconf.com/--s2011-04-13-15:05--17829 SUMMARY:Dynamic Columns DESCRIPTION:Presented by Michael Widenius (Monty Program Ab), Oleksandr Byelkin (Monty Program). New feature of Maria DB which makes schema-less part of table possible will be described for database users with some d etails of its implementation on the server. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110413T235405 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17116 UID:http://mysqlconf.com/--s2011-04-13-16:25--17116 SUMMARY:Percona Server and XtraBackup: painless operations DESCRIPTION:Presented by Vadim Tkachenko (Percona Inc). This talk shows how to use Percona Server together with XtraBackup to make important ope rational tasks easy. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110316T200626 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19732 UID:http://mysqlconf.com/--s2011-04-13-10:50--19732 SUMMARY:Replication for Availability & Durability with MySQL and Amazon RDS DESCRIPTION:Presented by Grant McAlister (Amazon.com). Whether running w ith commodity servers on premise or in the cloud, there are many failure scenarios to protect your database against. In this session we will wal k through the different types of replication possible with both self-man aged MySQL deployments and managed Amazon Relational Database Service cl oud deployments, understanding how they can help improve your availabili ty and durability. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110412T234658 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17651 UID:http://mysqlconf.com/--s2011-04-13-17:15--17651 SUMMARY:The NDB Engine for Memcached DESCRIPTION:Presented by John David Duncan (Oracle Corp.), Edwin DeSouza (Oracle). The next major release of Memcached, memcached 1.6, will supp ort loadable storage engines to manage cached data. The NDB Engine for Memcached allows MySQL Cluster and Memcached to be used together in a wi de variety of ways, and can be individually configured for particular me mcached key prefixes. The presentation will include an overview, how-to s, and benchmarks. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110412T052212 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17821 UID:http://mysqlconf.com/--s2011-04-11-09:00--17821 SUMMARY:MySQL Cluster Tutorial DESCRIPTION:Presented by Max Mether (SkySQL Ab), Joffrey Michaie (SkySQL Ab), Johan Andersson (Severalnines). This Cluster Tutorial guides DBAs and other mere mortals into the world of MySQL Cluster. At the end of th e session you will have started your own cluster on your laptop and be a ble to administer and manage it as needed. You will also be able to crea te and install new clusters at ease. More advanced topics such as perfor mance tuning and common pitfalls and best practices will also be showcas ed. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110412T022801 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19268 UID:http://mysqlconf.com/--s2011-04-11-13:30--19268 SUMMARY:Learn how to cure MySQL replication deprivation with Tungsten! DESCRIPTION:Presented by Robert Hodges (Continuent.com), Edward Archibal d (Continuent). MySQL replication deprivation is a common condition that occurs when you encounter problems built-in MySQL replication cannot so lve. Do you need automatic master promotion, ability to replicate to Po stgreSQL or Oracle, multi-master/multi-source replication, parallel slav e apply, or built-in consistency checking? END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T115000 DTSTART;TZID=US/Pacific:20110414T105000 DTSTAMP:20110418T023455 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20238 UID:http://mysqlconf.com/--s2011-04-14-10:50--20238 SUMMARY:Subqueries to the People: MariaDB Making the Impossible Possible and the Slow Fast DESCRIPTION:Presented by Timour Katchaounov (Monty Program Ab). MySQL su pports subqueries since version 4.1 released 8 years ago. Due to their s implistic implementation and resulting poor performance, subqueries have been considered as practically unusable by many users. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110414T231405 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17498 UID:http://mysqlconf.com/--s2011-04-14-11:55--17498 SUMMARY:Performance Tuning for Drizzle DESCRIPTION:Presented by Monty Taylor (HP). Now that you've decided to u se Drizzle for everything, you're going to want to tune it to get the be st out of your system. Some of the things you know from MySQL apply, som e don't. Let's look at some real numbers and real graphs and see what Dr izzle is doing. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110419T123339 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17441 UID:http://mysqlconf.com/--s2011-04-14-14:00--17441 SUMMARY:Fixed in Drizzle: No more "GOTCHA's" DESCRIPTION:Presented by Stewart Smith (Percona). Drizzle has fixed many "gotcha" type things. Often we find ourselves saying "fixed in Drizzle" . This is a whirlwind tour of what that is. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110307T200206 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17301 UID:http://mysqlconf.com/--s2011-04-14-14:50--17301 SUMMARY:Performance comparisons and trade-offs for various MySQL replica tion schemes DESCRIPTION:Presented by Darpan Dinker (Schooner Information Technology, Inc.), Brian O’Krafka (Schooner Information Technology). Most MySQL dep loyments use some form of replication. Whether the reason is availabilit y, scalability, backup, disaster recovery or archiving, understanding th e 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, t his session is for you. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110414T004955 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19743 UID:http://mysqlconf.com/--s2011-04-12-14:00--19743 SUMMARY:Maximum Availability for MySQL/InnoDB with Synchronous Replicati on, Automated Failover, Full Data Consistency, Simplified Management, an d Industry-Leading Performance DESCRIPTION:Presented by John Busch (Schooner Information Technology). W e present innovative technology developed to achieve industry-leading av ailability coupled with industry-leading performance for MySQL/InnoDB. D owntime is reduced by over 90% with tightly integrated, fully synchronou s replication. Highly-optimized thread, lock, DRAM, and flash algorithms maximize performance.We present the technology, demonstrate management simplicity, and show benchmark results. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110309T123144 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19728 UID:http://mysqlconf.com/--s2011-04-12-15:05--19728 SUMMARY:A Ridiculously Easy & Seriously Powerful Cloud Database - See it in Action! DESCRIPTION:Presented by Itamar Haber (Xeround). mysql> EXPLAIN SELECT * FROM CLOUDSQLDB WHERE Availability=’always’ AND Scale=’auto’ AND COUN T (CloudProviders)>1; Come see a live demonstration of a highly-availa ble and scalable cloud database – with self-healing, auto-scaling and pa y-per-use – all with a click of a button. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110414T034014 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19897 UID:http://mysqlconf.com/--s2011-04-13-11:55--19897 SUMMARY:SkySQL's Reference Architecture Partner Panel Discussion DESCRIPTION:Presented by Kaj Arnö (SkySQL Ab). Kaj Arnö, executive vice president of products for SkySQL will lead a panel of strategic partners including Calpont, Linbit, ScaleDB, Webyog and Zimory in a discussion o f the SkySQL Reference Architecture for deploying data infrastructure so lutions for the MySQL® database. Wednesday, April 13, 11:55 a.m. Ballro om H END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110411T185253 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18554 UID:http://mysqlconf.com/--s2011-04-13-14:00--18554 SUMMARY:Group Commit and Related Enhancements to the MariaDB Binary Log DESCRIPTION:Presented by Michael Widenius (Monty Program Ab), Kristian N ielsen (MariaDB / Monty Program AB). Group commit is a very important op timisation for ACID storage engines in high transaction-per-second OLTP that is implemented for the binlog in MariaDB. Usage, benchmarks, and te chnical details of the implementation are presented, as well as the unde rlying extension to the storage engine API that enables better provision ing of replication slaves from non-blocking backup, and other enhancemen ts END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110418T192744 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19735 UID:http://mysqlconf.com/--s2011-04-13-15:05--19735 SUMMARY:Redis to the Rescue? DESCRIPTION:Presented by Tim Lossen (wooga - world of gaming). As an in- memory database, Redis offers an order-of-magnitude reduction in query r oundtrip latency, but also introduces new challenges. This case study re counts how we successfully scaled up two Facebook games with Redis, and what we learned on the way. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110414T002926 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17199 UID:http://mysqlconf.com/--s2011-04-13-16:25--17199 SUMMARY:Own it: Working with a changing open source database community DESCRIPTION:Presented by Selena Deckelmann (PostgreSQL). Taking lessons from the PostgreSQL community, and recent experience with the growing co mmunities 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110309T163151 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17612 UID:http://mysqlconf.com/--s2011-04-13-17:15--17612 SUMMARY:Delivering Scalable and Highly Available Session Management with MySQL Cluster DESCRIPTION:Presented by Mat Keep (MySQL), Bernhard Ocklin (Oracle Svens ka 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 a pplications 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 w e'll present some real life case studies. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T140000 DTSTART;TZID=US/Pacific:20110413T100000 DTSTAMP:20110412T221414 LOCATION:Expo Hall URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18561 UID:http://mysqlconf.com/--s2011-04-13-10:00--18561 SUMMARY:MySQL Career Zone DESCRIPTION:Join participating sponsors and other companies as they pres ent open positions from their respective companies. Wednesday, April 13t h, 10:00am – 2:00pm. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T171500 DTSTART;TZID=US/Pacific:20110414T163500 DTSTAMP:20110419T130047 LOCATION:Ballroom Foyer URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17820 UID:http://mysqlconf.com/--s2011-04-14-16:35--17820 SUMMARY:Ice Cream Social Closing Reception DESCRIPTION:Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Ta ke the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T190000 DTSTART;TZID=US/Pacific:20110412T180000 DTSTAMP:20110415T005213 LOCATION:Exhibit Hall A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17819 UID:http://mysqlconf.com/--s2011-04-12-18:00--17819 SUMMARY:Expo Hall Reception DESCRIPTION:Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T203000 DTSTART;TZID=US/Pacific:20110413T190000 DTSTAMP:20110419T084515 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19409 UID:http://mysqlconf.com/--s2011-04-13-19:00--19409 SUMMARY:Ignite MySQLconf DESCRIPTION:Presented by Brian Aker (HP). If you had five minutes on sta ge what would you say? What if you only got 20 slides and they rotated a utomatically after 15 seconds? Would you pitch a project? Launch a web s ite? Teach a hack? We’ll find out this year at Ignite MySQLconf. Ignite MySQLconf will happen on Wednesday, April 13 at 7:00pm. The call for Ign ite MySQLconf talk proposals now closed. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T163500 DTSTART;TZID=US/Pacific:20110414T155000 DTSTAMP:20110419T123357 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20121 UID:http://mysqlconf.com/--s2011-04-14-15:50--20121 SUMMARY:Big and Small Data at @Twitter DESCRIPTION:Presented by Jeremy Cole (Twitter). Keynote by Jeremy Cole, DBA Team Lead and MySQL Architect, Twitter. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T094000 DTSTART;TZID=US/Pacific:20110412T090000 DTSTAMP:20110419T122849 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/18530 UID:http://mysqlconf.com/--s2011-04-12-09:00--18530 SUMMARY:State of the Dolphin DESCRIPTION:Presented by Tomas Ulin (Oracle), Duleepa Wijayawardhana (Em pire Avenue). Join Tomas Ulin, Oracle’s Vice President of MySQL Engineer ing, as he summarizes MySQL’s first year under Oracle’s stewardship, dis cusses the current and ongoing engagement with the MySQL user community and offers insights into future roadmaps and commitment to MySQL product s. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T100000 DTSTART;TZID=US/Pacific:20110412T094000 DTSTAMP:20110415T203242 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19739 UID:http://mysqlconf.com/--s2011-04-12-09:40--19739 SUMMARY:The State of the Elephant DESCRIPTION:Presented by Ed Boyajian (EnterpriseDB), Bruce Momjian (Ente rpriseDB). In the State of the Elephant keynote, Ed Boyajian, CEO of Ent erpriseDB, and Bruce Momjian, Co-Founder of The Global PostgreSQL Develo pment Group, will present an overview of the PostgreSQL Community. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T102000 DTSTART;TZID=US/Pacific:20110412T100000 DTSTAMP:20110419T125305 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20172 UID:http://mysqlconf.com/--s2011-04-12-10:00--20172 SUMMARY:2011 MySQL Awards DESCRIPTION:Presented by David Axmark (Me, MySelf and I), Michael Wideni us (Monty Program Ab). Join us for the annual MySQL Awards, as we recogn ize excellence in Community Contributor, MySQL Application, and Corporat e Contributor categories. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T093000 DTSTART;TZID=US/Pacific:20110413T090000 DTSTAMP:20110419T123131 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17805 UID:http://mysqlconf.com/--s2011-04-13-09:00--17805 SUMMARY: State of MariaDB DESCRIPTION:Presented by Michael Widenius (Monty Program Ab). Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what Mar iaDB is all about. MariaDB is now 2 years old, and has made 2 releases i n 2010. He’ll also present an overview of the future of this community d eveloped branch of the MySQL database. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T100000 DTSTART;TZID=US/Pacific:20110413T093000 DTSTAMP:20110419T123136 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17807 UID:http://mysqlconf.com/--s2011-04-13-09:30--17807 SUMMARY:Data in the Cloud DESCRIPTION:Presented by Mårten Mickos (Eucalyptus Systems). Elasticity is a key characteristic of public, private and hybrid clouds. Virtual ma chines can be spun up and spun down at a moment's notice. But how do dat abases behave in clouds? END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T102000 DTSTART;TZID=US/Pacific:20110413T100000 DTSTAMP:20110419T123149 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17806 UID:http://mysqlconf.com/--s2011-04-13-10:00--17806 SUMMARY:State of Drizzle DESCRIPTION:Presented by Brian Aker (HP). What’s the forecast for Drizzl e, a database optimized for Cloud and Net applications? Brian provides a n overview of the Drizzle project’s current state as well as what’s ahea d. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T093000 DTSTART;TZID=US/Pacific:20110414T090000 DTSTAMP:20110419T125517 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17808 UID:http://mysqlconf.com/--s2011-04-14-09:00--17808 SUMMARY:Building on Strengths, Learning from Differences DESCRIPTION:Presented by Baron Schwartz (VividCortex Inc). The last few years have brought technological and market shifts that have disrupted o pen-source databases. These include cloud computing, solid-state storag e, non-SQL databases, and MySQL's acquisition. In this keynote presenta tion, Baron Schwartz will discuss the new reality that faces open-source database users and developers. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T100000 DTSTART;TZID=US/Pacific:20110414T093000 DTSTAMP:20110419T123302 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19703 UID:http://mysqlconf.com/--s2011-04-14-09:30--19703 SUMMARY:The Next Decade in Data Management DESCRIPTION:Presented by Mike Olson (Cloudera). The meteoric growth of M ySQL through the 1990s and 2000s were marked by some big in the enterpri se database market -- a willingness to adopt open source software for cr itical business applications, and the emergence of a new class of databa se-backed web applications that needed a simpler, cheaper and more flexi ble storage model than the established vendors provided. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T102000 DTSTART;TZID=US/Pacific:20110414T100000 DTSTAMP:20110419T084551 LOCATION:Ballroom EFGH URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20166 UID:http://mysqlconf.com/--s2011-04-14-10:00--20166 SUMMARY:Best of Ignite DESCRIPTION:If you missed Ignite MySQLconf on Wednesday evening, come ch eck out the Best of Ignite - several fun, high-energy “speed presentatio ns” given by people like you. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T190000 DTSTART;TZID=US/Pacific:20110413T180000 DTSTAMP:20110414T040654 LOCATION:See BoF Schedule for Locations URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19815 UID:http://mysqlconf.com/--s2011-04-13-18:00--19815 SUMMARY:Wednesday Night BoFs DESCRIPTION:Birds of a Feather (BoF) sessions provide face to face expos ure to those interested in the same projects and concepts. BoFs are happ ening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednes day from 6:00p - 11:00p. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T230000 DTSTART;TZID=US/Pacific:20110413T203000 DTSTAMP:20110314T203941 LOCATION:See BoF Schedule for Locations URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19817 UID:http://mysqlconf.com/--s2011-04-13-20:30--19817 SUMMARY:Wednesday Night Bofs, con't DESCRIPTION:Birds of a Feather (BoF) sessions provide face to face expos ure to those interested in the same projects and concepts. BoFs are happ ening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednes day from 6:00p - 11:00p. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T230000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110419T122948 LOCATION:See BoF Schedule for Locations URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19814 UID:http://mysqlconf.com/--s2011-04-12-19:00--19814 SUMMARY:Tuesday Night BoFs DESCRIPTION:Birds of a Feather (BoF) sessions provide face to face expos ure to those interested in the same projects and concepts. BoFs are happ ening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednes day from 6:00p - 11:00p. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T210000 DTSTART;TZID=US/Pacific:20110412T190000 DTSTAMP:20110406T181835 LOCATION:Lobby Bar URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20169 UID:http://mysqlconf.com/--s2011-04-12-19:00--20169 SUMMARY:MySQL Conference & Expo Meetup DESCRIPTION:Join fellow MySQL Conference & Expo participants at this fun and exciting event. Come together, meet each other face to face, and di scuss things in real time over a drink at the bar at this year's MySQL C E Meetup. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T210000 DTSTART;TZID=US/Pacific:20110413T203000 DTSTAMP:20110419T133235 LOCATION:Techmart Santa Clara Dining Room URL:http://en.oreilly.com/mysql2011/public/schedule/detail/20193 UID:http://mysqlconf.com/--s2011-04-13-20:30--20193 SUMMARY:MySQL Community Reception by Oracle DESCRIPTION:Join the MySQL Team at Techmart Santa Clara (next door to th e Convention Center) on April 13, 2011, as we celebrate the health and g rowth of the MySQL community. END:VEVENT END:VCALENDAR