BEGIN:VCALENDAR X-WR-CALNAME:O'Reilly MySQL Conference & Expo 2011 VERSION:2.0 PRODID:Expectnation CALSCALE:GREGORIAN 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: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: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: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: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: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: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: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: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: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 END:VCALENDAR