Personal schedule for John Russell
Download or
subscribe to John Russell's
schedule.
Back by popular demand we have the Memcached tutorial. Come learn about what is new and exciting in the world of Memcached.
Read more.
This talk is about Innodb and XtraDB architecture with focus on architecture aspects important for performance optimization. We will also look into tuning Innodb settings as well as designing database schema and application to take advantage of architecture.
Read more.
Join Tomas Ulin, Oracle’s Vice President of MySQL Engineering, as he summarizes MySQL’s first year under Oracle’s stewardship, discusses the current and ongoing engagement with the MySQL user community and offers insights into future roadmaps and commitment to MySQL products.
Read more.
MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks.
Read more.
Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience.
Read more.
We present some simple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data.
Read more.
HailDB is a project that maintains InnoDB as a shared library (forked from embedded_innodb). It 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.
Read more.
Percona Server is most known for its performance and slow-log diagnostics, but it has many other useful features. In this talk I will describe them.
Read more.
Are you considering 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
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.
Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations.
Read more.
This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy.
Read more.
Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database.
Read more.
Perl has been around for a while now. Even with buzz around other interpreted languages, Perl is still prevalently used in many applications- anything from simple database utilities, database administrative tools or web applications, it is useful to know how to program with Perl along with a relational database. This session is refresher course for lovers and non-lovers of Perl alike.
Read more.
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.
A guide to migrating your database and application from MySQL to Drizzle at every layer, from schemas to connections and application modifications.
Read more.
MySQL Cluster (NDB) is one of the most interesting storage engines. Oracle promotes NDB as the perfect solution for high volume transactions in high availability. On the other hand, many famous users are reluctant in migrating applications to NDB. This session will help in understanding in practical terms when it makes sense to use NDB and when it is better to stay with or use InnoDB.
Read more.
Sphinx Search Engine is a well known tool for dealing with full text search problems on the large scale, but did you know you can use Sphinx for other tasks, which your traditional database may not be well suited for. This presentation will look into practical cases of using Sphinx beyond full text search and provide performance comparison to using MySQL for the same task.
Read more.
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in 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.
Read more.
Learn best practices in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices
Read more.