Personal schedule for Brett Garland
Download or
subscribe to Brett Garland's
schedule.
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the first part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
Read more.
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the second part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
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.
Many things happen when MySQL is part of the core technology used to
scale a rapidly growing social networking service. Mark will share
stories and details about the MySQL deployment at Facebook.
Read more.
War and peace stories from Facebook - how to detect, analyze and fix problems below, inside and above overloaded MySQL servers.
This covers concurrecy problems that appear in real world environments, beyond labs and benchmarks.
Read more.
Sharding is a hot topic. Every big web site is using some sharding
technique with home made solutions. The quest for the silver bullet goes on
without apparent good results. This session will present two MySQL storage
engines (Spider and Vertical partitioning) that implement transparent
sharding techniques.
Read more.
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
Read more.
Memcached has become the de facto standard for caching web applications. But, many users jump in feet first without understanding what it does or perhaps more importantly what it does not do. Once you understand memcached, you may come to realize that it is what it does not do that makes it so good.
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.
InnoDB is the most popular, reliable and functional of the transactional storage engines available for MySQL. At this session, you will learn the current state of InnoDB and the new features in the InnoDB Plugin. You will also learn how InnoDB works and why those new features improve the performance and scalability.
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.
Learn how to find your database problems more quickly without special software. Automatically tracking all database changes and keeping a historical record enables you to figure out problems faster, reducing downtime for critical production systems. Existing monitoring systems are very good at detecting actual errors but not very good at telling you what triggered your performance issue
Read more.
Reporting and data analysis, or "business intelligence", is a part of many MySQL environments. This session will show how to implement business intelligence with Jaspersoft and MySQL, embedded in applications or as a stand-alone service for direct use by your audience.
Read more.
This session is a must for all DBAs and users
who store data in various word languages in MySQL database,
including European languages, Japanese, Chinese, Korean,
as well as for those using MySQL in a multi-lingual environment.
All SQL standard fans are also welcome to know what's happening
in MySQL for better conformance in how MySQL handles identifiers, character sets, collations.
Read more.
Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL, such as how to avoid OOM Killer, performance difference between I/O schedulers, tuning Linux kernel parameters, profiling with SystemTap, etc.
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.
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.
Sheeri Cabral knows the MySQL Community. Working for the Pythian
Group, she has tapped her co-workers' knowledge about the Oracle
Community. In this brief community keynote, Sheeri maps out the
differences between the communities and what we can expect next now
that MySQL is "under new management".
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.
The MySQL Server ships with a number of command-line administration tools. However, they only provide basic functionality and make it complicated or sometimes even impossible to accomplish common DBA tasks. In this session, Lenz will give an introduction to the most popular and commonly used Open Source tools that a DBA should be aware of and that make MySQL administration tasks a breeze.
Read more.
Many times, data warehouses are thrown up without much thought going into the logical/ physical design. But, high performance data warehouses and analytic databases don’t happen by accident; they come from solid up-front design work. This session describes the procedures to go from an empty data model to a physical data warehouse that can stand up to terabytes of data and intense user activity.
Read more.
Meet the developers behind the partitioning feature in MySQL and take your chance to influence the future development!
Get a detailed view of how the partitioning works inside the MySQL server, including the new features in 5.5 (COLUMS partitioning type, truncate partition, MyISAM key cache per partition, etc). And what is in development right now.
Read more.
Are you interested in splitting your application's reads and writes, so writes go to the master and SELECT queries go to slaves? This session is for you. Learn common patterns, pitfalls, and solutions.
Read more.
Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference.
In this session, I'll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning.
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.
Replication is big news and not just because of built-in replication from MySQL itself. Projects like Drizzle, Tungsten, and Galera are changing the replication game with higher speed and greater flexibility than ever before. Join Jay Pipes (Drizzle Replication API) and Robert Hodges (Tungsten Clustering) for a tour of the new replication solutions and how they can help your applications.
Read more.
Description:
In this session, the speaker will explain some important but not well known indexing topics. Advanced topics such as indexes and lock contentions, how indexes impact MySQL optimizer will be covered. This session is the sequel to "Mastering the Art of Indexing" (http://www.mysqlconf.com/mysql2009/public/schedule/detail/6661), presented at the last MySQL Conference.
Read more.
MySQL is becoming more and more popular as a DB for business intelligence and data warehouse solutions. The implementation of these solutions are often based on an approach that is typical of commercial DBs and expensive HW. In this session we will present the best techniques to use MySQL in a OLAP environment, for modelling, loading, querying, caching and indexing multidimensional DBs.
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.
Galera is emerging synchronous multi-master replication method, providing tightly coupled InnoDB clustering solution.
Galera has nice features like:
* High Availability - no lost transactions
* Performance - scalability even with 100% write rate
* Transparency - direct MySQL connections
MySQL/Galera 0.7 is production-ready GA release
Read more.
InnoDB Hot Backup is the ideal solution for online backups of InnoDB
tables in MySQL databases, as well as for backups of MyISAM tables. At
this session, you will learn how InnoDB Hot Backup works, and how to
develop a backup strategy using the Hot Backup utility.
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.
Ever wanted to de-fragment your data set to regain disk space and increase performance? Ever needed to add or change an index on a large table? Ever needed to change a primary key? If you answered yes to any of these and you already know a lot about MySQL then this talk is for you!
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.
This talk is for those that know the basics of replication but want to take it to another level. We will show you how replication can solve complicated problems, give you better performance, and avoid excess downtime.
Read more.
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work.
Read more.
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
Read more.
dim_STAT is a very powerful tool to monitor and analyze everything you need from your server. This presentation will cover MySQL oriented solutions integrated within dim_STAT.
Read more.
Need instant results to your queries? Learn how to become a real-time data and analytics expert by adding Streaming SQL to your MySQL skill set. SQLstream's streaming SQL architects will introduce you to key concepts in Stream Computing using SQL:2008 & MySQL, followed by real world examples
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.
Before you throw away the binary logs that you use for replication, transform them into an analysis tool. Use them to track the frequency of inserts, updates and deletes on all of your tables. Maintain a history of the response times of your most frequent write queries.
Read more.
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work.
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.
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.
In this brand new talk, Jono Bacon, Ubuntu Community Manger, author of
the critically acclaimed The Art Of Community by O'Reilly and founder of
the annual Community Leadership Summit, talks about the evolution of
community and how we can identify the engines of community, helping us
to unite a global collection of volunteers to solve interesting and
worthwhile problems.
Read more.
There are many exciting performance features in the InnoDB Plugin. But how to best use them? What are the caveats? At this session, we will describe those performance features in depth. We will also present benchmark results that explore the performance of those features.
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.
The best way to understand your application's performance is to have good performance instrumentation in your application. This session will teach you how and where to instrument your application, and how to analyze the results.
Read more.
Are you ensuring that a slave has the same data is the same as its master? Using mk-table-checksum from Ma'atkit as the basic tool, we will show you how to check that your data is in sync -- in a non-invasive way. We will share the tricks, tips and gotchas we have learned deploying this method in several different environments and schemas.
Read more.
When it is time to choose a High-Availability solution for MySQL, the number of solutions can lead to confusion. This session will help you make sense of replication, Cluster, DRBD and more.
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.