Personal schedule for Darren Cassar
Download or
subscribe to Darren Cassar's
schedule.
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.
Scaling Applications with Caching, Sharding and Replication
Read more.
Command line skills for administering and using MySQL are still one of the main requirements for professionals in the Unix world. This tutorial
provides the basics and several advanced techniques.
Read more.
Join Edward Screven, Oracle’s Chief Corporate Architect and leader of the MySQL business, as he discusses the current and future state of MySQL, now part of the Oracle family of products. The presentation also covers Oracle’s investment in MySQL technology and community; and the role that open source in general is playing within heterogeneous customer environments around the world.
Read more.
Tim returns to share insights into the world of emerging technology, presenting his take on what matters most-and what will be most disruptive-to the tech community.
Read more.
Join the MySQL and InnoDB Engineering teams as they describe the
low-level technical details behind the MySQL 5.5 performance and
scalability gains.
Read more.
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
Read more.
MySQL's EXPLAIN output is rich with information, but can be difficult to understand. This session helps EXPLAIN make sense by showing how it reveals the server's estimated query execution plan.
Read more.
At this session, we will talk about current interfaces of the InnoDB monitoring system, including server status variables, information schema table, as well as table and space monitor. We will also discuss how to utilize these information to better understand the system running state.
Read more.
Many casually written stored routines are unnecessarily slow. By observing a few principles, you can gain substantive benefits for performance and maintainability of your stored routines. By applying step-wise improvements to real-world examples you will become aware of potential problems in your own stored routines and learn how to refactor them to increase performance and maintainability.
Read more.
Running multiple MySQL instances on the same hardware can be useful in a number of cases.
Some uses are rapid creation of test instances, consolidating several instances, mixing masters and slaves for redundancy and to balance load, and better hardware utilization. We will cover aspects including load balancing, LVM, repeatable builds, ports, proxy, and problems we encountered along the way.
Read more.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
Read more.
Birds of a Feather (BoF) sessions provide face-to-face exposure to those interested in the same projects and concepts. BoFs can be organized for individual projects or broader topics (best practices, open data, standards). BoFs are entirely up to you. We post your topic online and onsite and provide the space and time. You provide the engaging topic.
Read more.
Moderated by: Baron Schwartz
Discussion of all things Maatkit, hosted by Maatkit's creator.
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.
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. He'll also present an overview of the future of this community developed branch of the MySQL database.
Read more.
MySQL Security and User Administration is now made easy. Grant all on *.* no more. With SECURICH it is very easy to grant privileges on all but a few tables, make use of roles (groups of privileges), clone, rename, block or unblock users. You can set password complexity, history, expiry and you can do all this using either command line or an open-source, GUI cross platform tool called SAM-My.
Read more.
Disks are often credited with being the biggest performance bottleneck to any database system. This session introduces you to Linux diagnostic tools, hardware purchasing options, and how you should be thinking about IO.
Read more.
Increasing number of large MySQL applications, e.g. social networking
back-ends, use a distributed MySQL architecture. Backing up such large environments presents its own complexities. Application managers want a point-in-time restore which is coordinated across multiple servers. We will discuss multiple techniques to solve this problem and provide trade-offs based on on-the-ground experiences.
Read more.
Database operations gets interesting when it involves several thousand databases, a high-profile site and you have a small core team of DBAs. Among other things, we will give a high-level overview of Facebook database architecture, Backup (and recovery) strategy and the mysql upgrade process.
Read more.
InnoDB provides many sources of diagnostic information. Filtering through that information to find what is wrong with a system can be a big task.
This talk with detail all of the different sources and what useful information you can get from them. In addition, it will offer common solutions for these problems to get you started in the right direction.
Read more.
Want to learn what the difference between a 10 server deployment and a 200 server deployment is in terms of administration? Best practices in large deployments? Got questions on centralized management and change management? Capacity planning? All these subjects and more will be covered in this session
Read more.
MySQL security usually means strong passwords, proper user@host grants and SSL connectivity. However MySQL does not operate in a void. This talk will focus on how MySQL security can be compromised through the hardware, operating system (using Linux examples), network, and the applications. We will also discuss attack prevention from external and internal sources.
Read more.
In a complement to Edward Screven's opening keynote, Kaj will interpret the state of the MySQL community and the happenings of the MySQL Conference in a language familiar to those whose business has grown up with MySQL. What has changed already, what will change soon, and what won't change with Oracle as the steward of MySQL?
Read more.
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances.
Read more.
MySQL consultants have collected a toolset of MySQL architecture design patterns that are proven solutions for most MySQL system requirements. Each pattern has different strengths or weaknesses based on the application it may be used with. Learn the common patterns and which will work best for your applications and requirements.
Read more.
Taking a client from a minimum 700ms, and at times 1-2 seconds front page load time to a consistent 60ms is a great success story for the improvements possible in optimizing database performance. In this presentation we will outline the steps taken and what can be applied to any website as one possible model to use in evaluation of your website, as well as provide specific examples.
Read more.
It is still possible to bring back corrupted or unintentionally deleted InnoDB tables as long as data remain on medium.
During the session various recovery scenarios will be scrutinized.
The typical cases will be illustrated using InnoDB Recovery Tool.
Read more.
Take the opportunity to network one last time at this closing event, enjoy ice cream and refreshments. Say thank you and exchange contact information until next year.
Read more.