Schedule: Security and Database Administration sessions

Add to your personal schedule
Location: Ballroom B
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.25, 4 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Location: Ballroom F
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.17, 6 ratings)
MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. The latest release, MySQL 5.5 enhances partitioning to make them even more user friendly and powerful. This tutorial explains the basics, and some advanced techniques to get the most from partitioning. Read more.
Add to your personal schedule
Location: Ballroom G
Baron Schwartz (VividCortex), Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.33, 18 ratings)
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.
Add to your personal schedule
Location: Ballroom B
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.38, 8 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Location: Ballroom E
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.29, 7 ratings)
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.
Add to your personal schedule
Location: Ballroom C
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Average rating: **...
(2.78, 9 ratings)
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.
Add to your personal schedule
Location: Ballroom C
Baron Schwartz (VividCortex)
Average rating: ****.
(4.27, 11 ratings)
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.
Add to your personal schedule
Location: Ballroom B
Jimmy Yang (Oracle Corporation)
Average rating: **...
(2.60, 15 ratings)
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.
Add to your personal schedule
Location: Ballroom A
Robert Hamel (Pythian)
Average rating: ****.
(4.00, 8 ratings)
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.
Add to your personal schedule
Location: Ballroom D
Robert Hodges (Continuent.com)
Average rating: ****.
(4.00, 2 ratings)
Production MySQL deployments face constant challenges to keep databases up, avoid data loss, and scale performance. Tungsten offers a unique open source implementation of master/slave clustering that integrates replication, management, and SQL routing. We will present a tutorial introduction that shows how to set up and use Tungsten at home. Come see what the excitement is about! Read more.
Add to your personal schedule
Location: Ballroom D
Ben Black (Garmin), Mark Filipi (Garmin International)
Average rating: ***..
(3.00, 3 ratings)
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.
Add to your personal schedule
Location: Ballroom A
Darren Cassar (Trading Screen Inc)
Average rating: ***..
(3.50, 4 ratings)
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.
Add to your personal schedule
Location: Ballroom D
Baron Schwartz (VividCortex)
Average rating: ****.
(4.12, 8 ratings)
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.
Add to your personal schedule
Location: Ballroom E
Lenz Grimmer (Sun Microsystems)
Average rating: ****.
(4.70, 10 ratings)
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.
Add to your personal schedule
Location: Ballroom F
Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.38, 8 ratings)
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.
Add to your personal schedule
Location: Ballroom F
Bill Karwin (Karwin Software Solutions)
Average rating: ***..
(3.75, 4 ratings)
SQL Injection is one of the most common and most serious threats to web application security. In this presentation, you'll see some myths busted, you'll get a better understanding of SQL Injection, and you'll learn simple and effective techniques to combat it. Read more.
Add to your personal schedule
Location: Ballroom F
Harrison Fisk (Facebook)
Average rating: ****.
(4.08, 13 ratings)
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.
Add to your personal schedule
Location: Ballroom A
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.00, 1 rating)
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.
Add to your personal schedule
Location: Ballroom C
Nicklas Westerlund (Electronic Arts)
Average rating: **...
(2.50, 6 ratings)
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.
Add to your personal schedule
Location: Ballroom F
Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
Average rating: ****.
(4.50, 2 ratings)
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.
Add to your personal schedule
Location: Ballroom C
Danil Zburivsky (The Pythian Group)
Average rating: ***..
(3.50, 4 ratings)
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.
Add to your personal schedule
Location: Ballroom E
Ryan Lowe (Percona)
Achieving PCI compliance can be a difficult and expensive process. This session will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy them. Read more.
Add to your personal schedule
Location: Ballroom D
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Average rating: ***..
(3.50, 4 ratings)
This session is an overview of XtraBackup, a free, open-source hot backup solution for InnoDB and XtraDB engines. Read more.
Add to your personal schedule
Location: Ballroom C
Gerardo Narvaja (SkySQL Inc.)
Discuss what to look at when regular monitoring information is not descriptive enough. Review how to obtain useful status snapshots and how to interpret the results using real world examples covering items like: replication health, memory allocation, network issues and performance. Read more.
Add to your personal schedule
Location: Ballroom D
Aleksandr Kuzminsky (Percona Inc)
Average rating: ****.
(4.00, 3 ratings)
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.
  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.