Personal schedule for Valerie Parham-Thompson
Download or
subscribe to Valerie Parham-Thompson's
schedule.
This is updated and revised version of tutorial done at MySQL Conference
2010
Read more.
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Read more.
Amazon engineers share experiences managing a large fleet of MySQL databases.
Read more.
Getting sharding right is crucial for achieving high scale with MySQL on commodity hardware like we do at Facebook. We will overview sharding best practices, and show some examples of both successful and unsuccessful methods at sharding MySQL.
Read more.
Production schema changes are painful but unavoidable. This session will tell you how to
minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables.
Session will focus on pros and cons of each approach and describe most common use cases.
Read more.
Traditionally replication has been monitored using the information in SHOW SLAVE STATUS, however it doesn't always represent the full picture. This presentation will outline how combining different methodologies it is possible to obtain a more accurate picture about replication health.
Read more.
Security is becoming more important than ever, and as such, it should be a high concern for MySQL users. In this session we will cover important MySQL security practices, with a focus on configuring and using SSL with MySQL. Although sometimes overlooked, data in transit is vulnerable and should be secured. The use of SSL/TLS provides us with a tool to help protect peace of mind and data security.
Read more.
Security is often considered a waste of time given its tedious, painful and underestimated. This is where securich comes to the rescue helping you control users, privileges and enforce good passwords. User cloning, renaming, password complexity and much much more.
Read more.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
Read more.
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. MariaDB is now 2 years old, and has made 2 releases in 2010. He’ll also present an overview of the future of this community developed branch of the MySQL database.
Read more.
Elasticity is a key characteristic of public, private and hybrid clouds. Virtual machines can be spun up and spun down at a moment's notice. But how do databases behave in clouds?
Read more.
What’s the forecast for Drizzle, a database optimized for Cloud and Net applications? Brian provides an overview of the Drizzle project’s current state as well as what’s ahead.
Read more.
We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands.
Read more.
Running MySQL at a scale of Facebook leads to many unique problems. We will
discuss some of the performance problems seen in production systems and the tools and
techniques involved in solutions.
Read more.
This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status.
Read more.
Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works.
Read more.
AOL deployed its large scale Real Time News (RTN) system in 2007. This system receives news updates from over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabytes of data. However, news are delivered to end users in close to real time fashion. This presentation shares how it is done and the lessons learned.
Read more.
A real-world example of how re-sharding and table partitioning cut load data times in Facebook's analytics infrastructure from greater than 24 hours to less than 5 minutes.
Read more.
Most of high scale web applications use memcached + MySQL or NoSQL. It is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently developed HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our production. We'd like to share our experiences.
Read more.
The last few years have brought technological and market shifts that have disrupted open-source databases. These include cloud computing, solid-state storage, non-SQL databases, and MySQL's acquisition. In this keynote presentation, Baron Schwartz will discuss the new reality
that faces open-source database users and developers.
Read more.
InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works.
Read more.
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
Read more.
This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes
Read more.
Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Take the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments.
Read more.